From: Frank Komsic <komsicf@shoeicanada.com>
To: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Subject: SQL statements error in pgsql 16 but not in pgsql 12
Thread-Topic: SQL statements error in pgsql 16 but not in pgsql 12
Thread-Index: AQHa1wnOMhJUAaFo+UG34+xmp6JYLA==
Date: Mon, 15 Jul 2024 22:57:24 +0000
Message-ID: 
 <DM4PR05MB92551C285B81BB5FB12F1BC6B3A12@DM4PR05MB9255.namprd05.prod.outlook.com>
Accept-Language: en-CA, en-US
Content-Language: en-CA
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?Windows-1252?Q?c+HjXtL/MXnB2XOqtCtxJ16SJkVdhgH3Cr7Yx9Mkh5CzKYW8fIs3Ui8D?=
 =?Windows-1252?Q?erc3GgXFwmnd/RFuiP1Kbn8iFHhAbc5d0UpulX1TtNWJf11NNS3jMfiU?=
 =?Windows-1252?Q?o4IGdE3fwhKHJfmfKjqsAuQfIm4gB+QGomoEgN3Grc1IFudx6i+PbCdz?=
 =?Windows-1252?Q?px9Y5C+7bFkNqLqR1nhmmI+29GjH1MUJNumHKtppy0j1jkyOPhBiytAr?=
 =?Windows-1252?Q?a89DciZBfCgbkbhurlmhdGxJn0ryfQ4KSESdAKb2D3xepRzZeKJSqsrx?=
 =?Windows-1252?Q?DddeEgkDbbkLAujPDpIRun+CPCv9jqG9N1VWmpW1LqU1Xi1N/hdTyiPk?=
 =?Windows-1252?Q?6saFKbUQGN0wD4QAbozcXsum04D34BLTuuBvhZ4taEYvh5yYckIrmRht?=
 =?Windows-1252?Q?9jhqLByfC4A2wANFS0lYrFl7myffd6B7mHESY6UJiwble/weM+q2E50Z?=
 =?Windows-1252?Q?kPaZV62Wg644Wza0kFDiNLtdgarDiKelohYNMO7x446LU1bua8SE7+UL?=
 =?Windows-1252?Q?7yO+LlQ6kttw2GMs8jvJ30v0udkFo5x7qxUINC1nzcVtSkR6LazY7gza?=
 =?Windows-1252?Q?79iritxBcj2wAfolv2QYpv/9SNoZscQ5xQiCxBJwrGXz6KpcDdPiLnWt?=
 =?Windows-1252?Q?1qIQoZ78syDuaGhOkYZ/rVKo8E9+BKse2ipZ374kbKyPW7H9vkVC9mO6?=
 =?Windows-1252?Q?KqZIVkT2iaFkwL5nORlLk5UzYz9Psl7wN4KVQ10iDbqVUKYpRyxlyz3I?=
 =?Windows-1252?Q?7MpsttvAH8Wj4dX6Bd7jP1o6CxogxnnaDUpsKFAFRKct9P5OGWmh5A8M?=
 =?Windows-1252?Q?l+R4QxKrG4LWcpdSwUSsA7AUFtof9ua9ZtSqjofw7wN+D1cL3WhNI5S0?=
 =?Windows-1252?Q?RlJ8QzyTewL9/2yJDAlq8XWnL1mE/bFdqrOJdJn92p5iSxQzkhV6ujYY?=
 =?Windows-1252?Q?CwVFfVxFFMGZXM8mzT1Etkmq+tyBKLCt9vWrwtFwN0u6wo+a+hDKhHYs?=
 =?Windows-1252?Q?AbwRDsuFakwJXTPtRv1XVXEfzqWwYmNXiSERmmWZzhM610hlTH9t4C/i?=
 =?Windows-1252?Q?2Mw7A05hZcAKiquKjem0JAiijkVBzC19v1K4/dCevoTBJguJGkOAvVpf?=
 =?Windows-1252?Q?epHX9b8YJH8tDdKGiR9Euo7iTaULM8qA01KPKgxqx6s/zu4LaaolfVYg?=
 =?Windows-1252?Q?f+yJi7wT2bKLyjiUiKEoFLkFe7I5nIkVCHXq9C+H+oHGj9ubzwCIV++C?=
 =?Windows-1252?Q?5gZwPK7wUeyxRDGUB0njh1ll8BiG5n4dUVzDCGwuEgQhjdIGiylLsLuc?=
 =?Windows-1252?Q?2hRy3hB2tr9m87NvbyEd4KqBPSbphPjtuHxGx1fXeJYMHyDyYICCN+cM?=
 =?Windows-1252?Q?8Yx780TYnTWUGcYwDZ+jh48qCXUmQQn97oRvpssCjyJLtuuvRYQYASCu?=
 =?Windows-1252?Q?YDX5BQPnngUxIsEzqhBZDqv1i424s9vbWFPlhNKhJxkrQZibk7Rh51Ji?=
 =?Windows-1252?Q?K4+Z9sXFOCLvIGGGMwbot5mUiCwi7md9SJqWw1V1Iae2cfpXV466qW6B?=
 =?Windows-1252?Q?ICQfrvKqv6s/PrZY5dVEjXTvMKoyo22URMNk4keeZPt23nPM/OLe8okd?=
 =?Windows-1252?Q?/Hx3eI8HFpZCDZuOuDkbyFQboYNFxa1NnCLTofZJQK+fV/Atj3RPrjAb?=
 =?Windows-1252?Q?exI1HbWPdzPspGiNEX9Y5V3UTlUE4IKh+Q+LPC7oKw2zSSVNiEyy9g?=
 =?Windows-1252?Q?=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DM4PR05MB92551C285B81BB5FB12F1BC6B3A12DM4PR05MB9255namp_"
MIME-Version: 1.0
X-OriginatorOrg: shoeicanada.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DM4PR05MB9255.namprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 a88458af-a6ba-4eaa-94fe-08dca52188c9
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Jul 2024 22:57:42.6731
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 01347b42-4202-49b1-8efe-675406351eed
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 dQvIF6PoRwCHtOmzV5DI9LvkFWaqW8nTgPhNGu+h13WrWfxNeSpnRHbuW97A0TAueVSdpxYWaKvIpD3gbCCK0g==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR05MB7531
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/DM4PR05MB92551C285B81BB5FB12F1BC6B3A12%40DM4PR05MB9255.namprd05.prod.outlook.com>
Precedence: bulk

--_000_DM4PR05MB92551C285B81BB5FB12F1BC6B3A12DM4PR05MB9255namp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,

I was trying to upgrade our database from version 12.18 to the latest 16.3

After upgrading, the application has reported errors or =93junk info=94 in =
the sql command line.

Example SQL code:
Message: ERROR: 42601: trailing junk after numeric literal at or near "1974=
9O"
SQL: SELECT bb,mass,classifier,lot
FROM lab.pt_f003_view
WHERE (lot =3D 19749OR lot=3D 19750)
ORDER BY lot,bb


The above sql command works in version 12 but does not work in version 16 d=
ue to missing space in =93WHERE (lot =3D 19749OR lot=3D 19750)=94

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

Thanks

Frank Komsic

--_000_DM4PR05MB92551C285B81BB5FB12F1BC6B3A12DM4PR05MB9255namp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;
	panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
span.apple-converted-space
	{mso-style-name:apple-converted-space;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-CA" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I was trying to upgrade our database from version 12=
.18 to the latest 16.3<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">After upgrading, the application has reported errors=
 or =93junk info=94 in the sql command line.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Example SQL code:<o:p></o:p></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121">Message: ERROR: 42601:=
 trailing junk after numeric literal at or near &quot;19749O&quot;<br>
SQL: SELECT bb,mass,classifier,lot<br>
FROM<span class=3D"apple-converted-space">&nbsp;</span>lab.pt_f003_view<br>
WHERE (lot =3D 19749OR lot=3D 19750)<br>
ORDER BY lot,bb<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121"><o:p>&nbsp;</o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121"><o:p>&nbsp;</o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121">The above sql command =
works in version 12 but does not work in version 16 due to missing space in=
 =93WHERE (lot =3D 19749OR lot=3D 19750)=94<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121"><o:p>&nbsp;</o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121">Why did this work befo=
re and now it does not work?<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121"><o:p>&nbsp;</o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121">Thanks<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121"><o:p>&nbsp;</o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"color:#212121">Frank Komsic</span><o:=
p></o:p></p>
</div>
</body>
</html>

--_000_DM4PR05MB92551C285B81BB5FB12F1BC6B3A12DM4PR05MB9255namp_--