pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Bug in UPDATE statement
3+ messages / 3 participants
[nested] [flat]

* Bug in UPDATE statement
@ 2022-09-10 06:44  Moisés Limón <neomega@yahoo.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Moisés Limón @ 2022-09-10 06:44 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Bug in UPDATE statement
@ 2022-09-10 12:21  Jaime Casanova <jcasanov@systemguards.com.ec>
  parent: Moisés Limón <neomega@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Jaime Casanova @ 2022-09-10 12:21 UTC (permalink / raw)
  To: Moisés Limón <neomega@yahoo.com>; +Cc: pgsql-bugs@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Bug in UPDATE statement
@ 2022-09-10 14:43  David G. Johnston <david.g.johnston@gmail.com>
  parent: Moisés Limón <neomega@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: David G. Johnston @ 2022-09-10 14:43 UTC (permalink / raw)
  To: Moisés Limón <neomega@yahoo.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

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.

https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_
PostgreSQL_report_a_column_not_found_error_when_using_
the_wrong_name_in_a_subquery.3F

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2022-09-10 14:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-09-10 06:44 Bug in UPDATE statement Moisés Limón <neomega@yahoo.com>
2022-09-10 12:21 ` Jaime Casanova <jcasanov@systemguards.com.ec>
2022-09-10 14:43 ` David G. Johnston <david.g.johnston@gmail.com>

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