From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: Moisés Limón <neomega@yahoo.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Bug in UPDATE statement
Date: Sat, 10 Sep 2022 07:21:06 -0500
Message-ID: <YxyBMoBUY2+0dMQZ@ahch-to> (raw)
In-Reply-To: <038F1E06-4866-4563-8DE0-229B8B19ABD2@yahoo.com>
References: <038F1E06-4866-4563-8DE0-229B8B19ABD2.ref@yahoo.com>
<038F1E06-4866-4563-8DE0-229B8B19ABD2@yahoo.com>
On Sat, Sep 10, 2022 at 01:44:40AM -0500, Moisés Limón 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.
>
> Moisés Limón Ruiz
Hi Moisés,
Can you give a complete example of what you are describing (at least a
create table command, insert some rows and an UPDATE with the behaviour
you describe).
--
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL
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: jcasanov@systemguards.com.ec, neomega@yahoo.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Bug in UPDATE statement
In-Reply-To: <YxyBMoBUY2+0dMQZ@ahch-to>
* 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