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>
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 |