From: Jüri Tali <Jyri.Tali@agri.ee>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Postgres 14 update clause bug
Date: Thu, 10 Feb 2022 07:29:54 +0000
Message-ID: <e7861ec3fb4d47b0a18f37fa6ce37731@agri.ee> (raw)
Hi,
Postgres 14 probably have Update clause bug
If I write Update clause little bit wrong:
UPDATE "table name" SET column1=1 and column2=2
WHERE id=1; there is a syntax error, in set part columns must be delimited with comma
Then postgres 14 do not give a error message and show 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))
I will be happy to answer any additional questions that may arise
Best regards,
Jüri 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<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.agri.ee%2F&data=02%7C01%7C%...; , Facebook<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FMaaeluministeer...;
<p></p>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: Jyri.Tali@agri.ee, pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres 14 update clause bug
In-Reply-To: <e7861ec3fb4d47b0a18f37fa6ce37731@agri.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox