Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17986: Inconsistent results of SELECT affected by btree index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17986: Inconsistent results of SELECT affected by btree index
Date
Msg-id 3689741.1687320665@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #17986: Inconsistent results of SELECT affected by btree index  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: BUG #17986: Inconsistent results of SELECT affected by btree index  (Zu-Ming Jiang <zuming.jiang@inf.ethz.ch>)
List pgsql-bugs
Tree view 
Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
> On 6/20/23 22:54, PG Bug reporting form wrote:
>> My fuzzer finds a correctness bug in Postgres, which makes Postgres return
>> inconsistent results.

> I can't reproduce this with current master - perhaps one of the commits
> since efeb12ef0b fixes this too?

It looks like this is another manifestation of the hashjoin bug
fixed in 45392626c.

            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: Richard Guo
Date:
Subject: Re: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by JOIN