Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjdZ-001tlZ-L0 for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2024 14:58:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sTjdX-001OTr-Et for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2024 14:58:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjdX-001OTj-2O for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2024 14:58:39 +0000 Received: from sonic322-37.consmr.mail.ne1.yahoo.com ([66.163.189.60]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sTjdP-002Qep-Dr for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2024 14:58:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721141909; bh=ba4+ALMslxgqKdjpo0QDzTuOAtREj9ltXtsAcbtop+w=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=Z57PWn4thFGfBRf2QxCUPrX+lcdgjvZZNYjOlfQPrW5/ZGXBBRNRKvXomROvnAkJMcz847hJdzQ7FrTDF5whj8jhyUeH9RMWyPZwj+E2IbUBU/CxojySdo6TgwpKAT6+LE1wn4xfhhYMrpUoGEyQtLztfcYBUjT5OZfjocYUyCGXih+C9CwnmcMbr8JrPS8BWcgSwAputqJSLbnlaJOHAWpeKqtvu18ke4m3U7Q3mbULVUvjsYIOz1D5VrSEB3UWhr7x3mnaDaGS4voU9pe/sb4KLB+jgC4A6Y3yPqrKC6sjnEVM0vvjUVVNAg3GFYAl9q6e+OgEqdzg2m9lxtlS+A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721141909; bh=3gg49yWwa17sOCmkhz3IYWz9ldsuw4yHr9o50NTIBbk=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=fmf9sBB2BV6vPeKv4QNDGuSxCbMtSElRS0+gUHmsovhv3hOjMHGp6AXi5kQeF8cir10B2BNPzBoMKbrPm/Leb/lO5KtYnNycz2DWIzTRrfKR6Yy2T8Ga1dN9TsqJPNMIfjI8W+sA5epZnjHDacd+Snujy+h9bKWuEXtoyAgPLB5/R3rfym97Z3eygFpel1t3XvEUwKxk8OOos/aqIqDiRC6TiogcBdN86y5Db7sZGFuhH5QXzqFt4b9GnBJclreZgJq7FyLlGN0yDZLvZKydZGXkzNuzym28crkz6rBTJQxIBSOfMcwe/4Ljfnwc6faMIFnSl16BmDtACuSf+QJFvA== X-YMail-OSG: Egup7BIVM1m_NdklXX71yaycJCTLpIdvkpq2HRnDPNkTaCztGtaCfOz_cf8u2zL 4ktX2nsrzjESl8._3mDu03MS7BrVzvt4MuPZ9LMBUx1jXaL87j7sXlapmUNwQcGBMGm9Qm3iQXdn xFyNfGTFGkwwZ7ImEKVl1YIxcwOMDrLiPSOcS2C2F0KKvrrEwEMeXCHzjPRL_oxuwmlkZtLDydtD .4fHzas8Sqd6wkI3h3067W_3.MP6tw2LLzx5.bHvHzMxB6xkXRTHdBXUALCXYOJ0xAaHejVUCALn qGQgSRG6bT1LDJ8vFuGranJmh4F1qRrlGLZDpndGxSjxjLD2KHzHmnBlJQDpZ9DVwkwm8eaRnyiD Uz1HxJ6Wst4JWXDfjLNGKq4NxhoclbICYO8whU2dTcOtw.3STv4qlGgBvWS3fA61mLbgpkbvwmdd gx.4v4HnudQLech7C.oyW54xrjkbB2qzg9HJecJ6as.KkckInR3s6fQtGcCWR4X3zIUgrWuFTTBI n6aFECHV9DARLDyQ21EzGsmMs.O3u8FlbZerqOzqSUWcDemKu1yu1DQGRN_Et0RxeyniqLpayfJ3 Xwvon3mQe29g.v8DiVJlcI5nqy84vI_N588Y4dfy_uZZv9dQshBSg6tMzlSEpOvyWJ8P9o6WYWJN ROagXk.Gx9.RJCf2vJGHLS5vvIwxXQf6_uxuyQf4h0WqMu42vtUhLSWf_pdVgpdqSqJVqAIjWP3c jFlKMWW_qOIRaOTmflZOgXgHZXpHyGFBSgqgRxbuQNMntctcOzHPZDqDEMXYbHtvElPWPwbJgt8. qDRFkNCcJKZxXFlFq8uy0e1RRWGw.xzIqFhRTg1PyaL2vjV612awO5fXMMHTIw6hvmI0v8eGxDcM Cfcqu9iSypbas.owF6Cz9oQ6hMFbuXVghxX8zl0i1Zta.Z3nX0dArXe2fZE9i37R6EBRC9uAg1B5 5YzbKYx0QgYamQr4FnoZb5Wuqi1eGnBIAouikNf2GoRjYeA3vvn1tnhH0F7zW1PNBr6y79tVqfPM TinUuEWDxNvB5XGUVHaTVM4jaPRAb8XR67cuSzj_KtLS21c55Dv2HBRq9TOZlxl8a4GgtrCOAFQN R9ELIwkYi1Y.0yqG9YM5IbGEr7_iX8S0o.sqXOXJsu21Db70Gm_aQ3hYlsN9QcYK6GujLZDrgObh yD0Dc6vgj1zCZcv7WmdRHkicZrm9tNl1GZFNlvuIgUHObk4UxHOnofkdkGiUXtDxpcCMbKh.wg1D M.J8gopqS_w2XrPoH8Uqyw3LEgjvDoFgcTJ1KUKm9A0gwmTdjwf6YWhwAFev1WpliZHIsExM7GPo yTHwEb4EMfajdASvrPdiqbnBl.Eis1BVRt09X1oHkgCGMDHnIhxvUvMsKF8AGlN8RKyqrzmSTshL WbZlyPGtpkXYM6SJ6XW4RKpm3moeLKWxFExLmEu0LNqTBn6utJEihgY2sJ9PQKClX9Y5a2ODuQDD 5YgidvvalQ9QwBb7wG1TRCPOScNbvKe9vRhYh..cr45b0bA.FB9YjJajcZA1AmBidl5qVhhE23DW 3mAtjCVCwv6yme1l9qsqAgRSdD8VEBMYeKgVPSTYZjg6rpgmf63d4rEbAUPM06FhZ408ut04tfyj InmCuZ1ZPVNCOPCeT79aKVCVSDr7F1AvLC.yEpm0.QckUZcMk7GYweGdDZ5kxnHDjMRt9RTFxzkR zeCfpjr.q4bTuKVh_.u6zY0AwadUwzC3peU654.dMUmfYss0ajwhu5.tnYaTFJH9lyFuRjBhaUgK IaOnFJB1PhJZqd5cm8npquF2a0xrzbPctK7b5B4esUjEe34PtMFn2qo5.edNkcv99uxbRqk7F0Lr 2n46KfmIrm.8pyl4ZLTDPJf7QB3zJtJsdNmgjcRxtNfp15.meI2POIsn_Ztq8LXRm3YdHMUd6UMG g9_eA7skdMrA5za4SGult2fHhCGvz2MX3MQ.SyCEwsGwEsSQ3VuJYN2Z6cpCf1aloRjSNqgFrf6k mYZp1ak7j5K.IhGv6L119wL49xWaLichirFpd5Fgh4xR9gIa_n_srcNYUVSm2XuhCLKnprTSMyOO 3btHqHwmgaXkPaEYZojxnwguEZD7clEci1dTgaeWfX0IaLyu0Eo6F6UPzr2HBJi09QN1.kGyezve tlHfC0tCzdM._b_K5qJJ.Xrc5DYlEdrHGJQdcG6KVKmXvEDsQZgKwCNUYd3SmFSSTTvtUR7tA8pM YnFxZoM_6dXI5W1zft0daEJLG5SdHsFdHVVEYJF7cnA-- X-Sonic-MF: X-Sonic-ID: a02c37af-1f50-4b2b-a878-60198b05edbe Received: from sonic.gate.mail.ne1.yahoo.com by sonic322.consmr.mail.ne1.yahoo.com with HTTP; Tue, 16 Jul 2024 14:58:29 +0000 Date: Tue, 16 Jul 2024 14:56:26 +0000 (UTC) From: Bharani SV-forum To: "pgsql-sql@lists.postgresql.org" , Frank Komsic Message-ID: <151842168.569875.1721141786874@mail.yahoo.com> In-Reply-To: References: Subject: Re: SQL statements error in pgsql 16 but not in pgsql 12 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_569874_242906311.1721141786873" X-Mailer: WebService/1.1.22501 YMailNorrin Content-Length: 4753 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_569874_242906311.1721141786873 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable cross checkWHERE (lot =3D 19749 OR lot=3D 19750) where the OR is tagged to numeric 19749. On Monday, July 15, 2024 at 06:58:06 PM EDT, Frank Komsic wrote: =20 =20 =20 Hi, =20 =C2=A0 =20 I was trying to upgrade our database from version 12.18 to the latest 16.3 =20 =C2=A0 =20 After upgrading, the application has reported errors or =E2=80=9Cjunk info= =E2=80=9D in the sql command line. =20 =C2=A0 =20 Example SQL code: =20 Message: ERROR: 42601: trailing junk after numeric literal at or near "1974= 9O" SQL: SELECT bb,mass,classifier,lot FROM=C2=A0lab.pt_f003_view WHERE (lot =3D 19749OR lot=3D 19750) ORDER BY lot,bb =20 =C2=A0 =20 =C2=A0 =20 The above sql command works in version 12 but does not work in version 16 d= ue to missing space in =E2=80=9CWHERE (lot =3D 19749OR lot=3D 19750)=E2=80= =9D =20 =C2=A0 =20 Why did this work before and now it does not work? =20 =C2=A0 =20 Thanks =20 =C2=A0 =20 Frank Komsic =20 ------=_Part_569874_242906311.1721141786873 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
cross check
WHERE (lot= =3D 19749 OR lot=3D 19750)

where t= he OR is tagged to numeric 19749.

=20
=20
On Monday, July 15, 2024 at 06:58:06 PM EDT, Frank = Komsic <komsicf@shoeicanada.com> wrote:


=20 =20
=20 =20

Hi,

=20

 

=20

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

=20

 

=20

After upgrading, the applica= tion has reported errors or =E2=80=9Cjunk info=E2=80=9D in the sql command = line.

=20

 

=20

Example SQL code:

=20

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

=20

 

=20

 

=20

The above sql command works in version 12 but does not work in version 1= 6 due to missing space in =E2=80=9CWHERE (lot =3D 19749OR lot=3D 19750)=E2= =80=9D

=20

 

=20

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

=20

 

=20

Thanks

=20

 

=20

Frank Komsic

=20
------=_Part_569874_242906311.1721141786873--