Postgres 14 update clause bug

From: Jüri Tali <Jyri(dot)Tali(at)agri(dot)ee>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Postgres 14 update clause bug
Date: 2022-02-10 07:29:54
Message-ID: e7861ec3fb4d47b0a18f37fa6ce37731@agri.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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%7C2c501cc847db4c44f6d808d8190228e3%7C406a174be31548bdaa0acdaddc44250b%7C1%7C0%7C637286844356924423&sdata=gEoIYRgWZKNlK7Oa5PB1RyA7Z%2FmMpT8kfiZnQDI3C%2FY%3D&reserved=0> , Facebook<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FMaaeluministeerium%2F&data=02%7C01%7C%7C2c501cc847db4c44f6d808d8190228e3%7C406a174be31548bdaa0acdaddc44250b%7C1%7C0%7C637286844356934378&sdata=ISEPqRUfus%2BIu%2Fbm%2Fm7FK%2F6oLI6jAnYbOg%2BvAyn8yZc%3D&reserved=0>

<p></p>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2022-02-10 08:28:27 Re: Postgres 14 update clause bug
Previous Message Tom Lane 2022-02-10 03:03:34 Re: BUG #17391: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL tests fail on OpenBSD 7.0