pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBug 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>
2022-09-10 12:21 ` Re: Bug in UPDATE statement Jaime Casanova <jcasanov@systemguards.com.ec>
2022-09-10 14:43 ` Bug in UPDATE statement David G. Johnston <david.g.johnston@gmail.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 06:44 Bug in UPDATE statement Moisés Limón <neomega@yahoo.com>
@ 2022-09-10 12:21 ` Jaime Casanova <jcasanov@systemguards.com.ec>
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 06:44 Bug in UPDATE statement Moisés Limón <neomega@yahoo.com>
@ 2022-09-10 14:43 ` David G. Johnston <david.g.johnston@gmail.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