Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nI4g8-0000iO-PR for pgsql-bugs@arkaria.postgresql.org; Thu, 10 Feb 2022 08:19:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nI4g7-0008Kb-Lj for pgsql-bugs@arkaria.postgresql.org; Thu, 10 Feb 2022 08:19:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nI3u4-00065H-Ho for pgsql-bugs@lists.postgresql.org; Thu, 10 Feb 2022 07:30:08 +0000 Received: from mail1.agri.ee ([195.80.100.164]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nI3tw-0008Fq-2F for pgsql-bugs@lists.postgresql.org; Thu, 10 Feb 2022 07:30:07 +0000 Received: from mail1.agri.ee (unknown [127.0.0.1]) by DDEI (Postfix) with ESMTP id BF3BB1221C9B for ; Thu, 10 Feb 2022 10:29:55 +0300 (+03) Received: from mail1.agri.ee (unknown [127.0.0.1]) by DDEI (Postfix) with ESMTP id AE185122238E for ; Thu, 10 Feb 2022 10:29:55 +0300 (+03) X-TM-AS-ERS: 10.1.1.74-127.5.254.253 X-TM-AS-SMTP: 1.0 bWFpbC5hZ3JpLmVl anlyaS50YWxpQGFncmkuZWU= Received: from mail.agri.ee (unknown [10.1.1.74]) by mail1.agri.ee (Postfix) with ESMTPS for ; Thu, 10 Feb 2022 10:29:55 +0300 (+03) Received: from pegasus.pmin.agri (10.1.1.74) by galactica.pmin.agri (10.1.1.73) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.986.15; Thu, 10 Feb 2022 09:29:54 +0200 Received: from pegasus.pmin.agri ([fe80::417a:61db:f16a:a312]) by pegasus.pmin.agri ([fe80::417a:61db:f16a:a312%8]) with mapi id 15.02.0986.015; Thu, 10 Feb 2022 09:29:54 +0200 From: =?iso-8859-1?Q?J=FCri_Tali?= To: "pgsql-bugs@lists.postgresql.org" Subject: Postgres 14 update clause bug Thread-Topic: Postgres 14 update clause bug Thread-Index: AdgeTsSLeexJA+0TRYmM5lU9IjPmxQ== Importance: high X-Priority: 1 Date: Thu, 10 Feb 2022 07:29:54 +0000 Message-ID: Accept-Language: en-US, et-EE Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.9.0.6] x-esetresult: clean, is OK x-esetid: 37303A292B98D95361706A x-eset-ndr: 010050E01411C93BAE1208B45A6E99332DF867165CA6721006620000 Content-Type: multipart/alternative; boundary="_000_e7861ec3fb4d47b0a18f37fa6ce37731agriee_" MIME-Version: 1.0 X-TMASE-Version: DDEI-5.0-8.6.1018-26706.006 X-TMASE-Result: 10--26.425900-10.000000 X-TMASE-MatchedRID: 6WlUmGq+AXPevf2qR5u0IZR7dxEUfuV1b4+volVFX84apMXJvkhMF2a8 8z8hzg4eV0THn3z2cQgSSHEMPQLczN5x7RpGJf1aOyBTDrxRCtg1Y73PdzvXZDn3zGQhjJHe24H 8UfXjxqynJa3++NYptw2RxS6Vxaw/haUx00nO1OvwUenwsKlntNGyEwQ9ROBAf8p1M7hdSu5lFS ORUVE4XsDeICriHXRtWfRNBfXFz37vVbHa5Rs8t/2xX1OVrWqLStFk/81wIJKQM2zg4yhfEpqEb +LwlrVjH76PVFvSJl7/s+8Vrwj8j1nAtIGDGCFojlRp8uau9oYj0vSXSt1uP81OB9nOoE46b7Oz ugStl7BqUmD8YRpTDfKBM2pCSxwPemu6h6JZhrmZEoWHC6Rh/RC4GOYwNkNJbVsEFJqff8n4G0N iaio+lqnrJuBqiSLfsPeJGsXu4c8PfWEquatUqeHHVUlPzis9QiO6TS4ko32WBb5xBlJ5nA5Fd3 u9jwovhtfOGOSyK2kfE8yM4pjsDxM0JxSxHjFJENbIgmC4a1bQBQ8SBUzMX7FVO/b6tafe/wnff sU7xJI+Mqg+CyrtwA== X-TMASE-SNAP-Result: 1.821001.0001-0-1-22:0,33:0,34:0-0 X-TMASE-INERTIA: 0-0;;;; X-TMASE-XGENCLOUD: 0086257d-02ab-4eb4-a966-c8d33dc8bde1-0-0-200-0 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=agri.ee; s=20191024; t=1644478196; bh=r4ymhYO180r+95D2aZrtqNjJn1zNfI+fXqTnLdWro+o=; l=7157; h=From:To:Subject:Date:Message-ID:Content-Type:MIME-Version; b=Ur+l0l3JV1acObdjLPFz8/32k+BD9eSGJ0Rw8S2R+wtFjJesqCWzYAyVn1H5R+CCy oVqEss7Aj7KGYi7gfu9LwMKwfHK14hdo73aG3C/8oB5hO940CbQ+JImjXfLLu/pAqx Tc0cMK+tMyK1p7nms7AH4ga/AXZLtdC7Khgewpks= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_e7861ec3fb4d47b0a18f37fa6ce37731agriee_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Postgres 14 probably have Update clause bug If I write Update clause little bit wrong: UPDATE "table name" SET column1=3D1 and column2=3D2 WHERE id=3D1; there is a syntax error, in set part columns must be delim= ited with comma Then postgres 14 do not give a error message and show that Update is succ= essful, but without no updated columns. POstgres 12 gives a error. Exact version: psql (14.1 (Ubuntu 14.1-2.pgdg20.04+1)) I will be happy to answer any additional questions that may arise Best regards, J=FCri Tali Chief specialist | IT department +372 625 6549 Ministry of Rural Affairs Lai tn 39 // Lai tn 41 | 15056 Tallinn 625 6101 | www.agri.ee , Facebook

--_000_e7861ec3fb4d47b0a18f37fa6ce37731agriee_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

 

Postgres 14 probably have Update clause bug

 

If I write Update clause little bit wrong:

 

UPDATE „table name“ SET column1=3D1 an= d column2=3D2

WHERE id=3D1;  there is a syntax error, in se= t part columns must be delimited with comma

 

Then postgres 14 do not give a error message and s= how that Update is successful, but without no updated columns.=

POstgres 12 gives a error.

 

Exact version: psql (14.1 (Ubuntu 14.1-2.pgdg20.04+1))

&nbs= p;

I will be happy to answer any additional questions= that may arise

 

 

Best regards,

J=FCri Tali
Chief sp= ecialist  | IT department

+372 625 6549


Ministry of Rural Affairs

Lai tn 39 // Lai tn 41 | 15056 Tallinn

625 6101 | www.agri.ee , Facebook

 

 

=
--_000_e7861ec3fb4d47b0a18f37fa6ce37731agriee_--