Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL statements error in pgsql 16 but not in pgsql 12 - Mailing list pgsql-sql

From David G. Johnston
Subject Re: SQL statements error in pgsql 16 but not in pgsql 12
Date
Msg-id CAKFQuwb1Fugw3jQGuqPQZBPZjQyskBi=TzpP5vjM+bDKmFhFhg@mail.gmail.com
Whole thread Raw
In response to SQL statements error in pgsql 16 but not in pgsql 12  (Frank Komsic <komsicf@shoeicanada.com>)
Responses Re: SQL statements error in pgsql 16 but not in pgsql 12
List pgsql-sql
Tree view
On Mon, Jul 15, 2024 at 3:57 PM Frank Komsic <komsicf@shoeicanada.com> wrote:

The above sql command works in version 12 but does not work in version 16 due to missing space in “WHERE (lot = 19749OR lot= 19750)”

 

Why did this work before and now it does not work?

 


It seems to be a side-effect of supporting non-decimal literals.

https://www.postgresql.org/message-id/flat/b239564c-cad0-b23e-c57e-166d883cb97d@enterprisedb.com
Git: 6fcda9aba83449082124825b6d375c0a61e21c42

This comment in particular refers to a v15 change that is probably related if you want to dive deeper.

https://www.postgresql.org/message-id/flat/1467947.1669851407%40sss.pgh.pa.us#66391c571b4db866e222450fb3fa9eb9

Suffice to say, we became more strict here since v12 and you will need to modify the query accordingly.

David J.

pgsql-sql by date:

Previous
From: Frank Komsic
Date:
Subject: SQL statements error in pgsql 16 but not in pgsql 12
Next
From: Bharani SV-forum
Date:
Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12