Postgres Pro
Downloads
Home   >   mailing lists

Bug in UPDATE statement - Mailing list pgsql-bugs

From David G. Johnston
Subject Bug in UPDATE statement
Date
Msg-id CAKFQuwbMU8inji2kfRYUdfR-0113LeBPxmGPewiLTm+3pyuD7g@mail.gmail.com
Whole thread Raw
In response to Bug in UPDATE statement  (Moisés Limón <neomega@yahoo.com>)
List pgsql-bugs
Tree view
On Friday, September 9, 2022, Moisés Limón <neomega@yahoo.com> wrote:
Hello,

PostgreSQL 14.4 compiled by Visual C++ build 1914, 64 bit


A bug was found in the UPDATE statement when the WHERE condition hasn't valid fields and only one valid field, the changes are applied for all rows.

Error detected using a Function with an UPDATE statement.


This is only a bug in the code you wrote, not a bug in PostgreSQL.  The code doesn’t error because it is valid.


(Yes, I’m assuming the problem here because you’ve filed a crappy bug report about a query bug without providing a query).

David J.


pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Bug in UPDATE statement
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Excessive number of replication slots for 12->14 logical replication