Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison - Mailing list pgsql-bugs

From Zu-Ming Jiang
Subject Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison
Date
Msg-id 5d183639-dbc5-e6be-39bd-6ada253c5ece@inf.ethz.ch
Whole thread Raw
In response to Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Thanks for your information and the fixing! I will then apply your patch and test postgres again.

Best,
Zuming

From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, June 19, 2023 at 6:08 PM
Subject: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison

PG Bug reporting form <noreply@postgresql.org> writes:

My fuzzer finds a correctness bug in Postgres, which makes Postgres return
inconsistent results.

This appears to be the same issue you already reported in bug #17978.
At least, the patch I just posted in that thread fixes this too.
			regards, tom lane

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon
Next
From: PG Bug reporting form
Date:
Subject: BUG #17983: Assert IsTransactionState() failed when empty string statement prepared in aborted transaction