Re: BUG #17986: Inconsistent results of SELECT affected by btree index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc: zuming(dot)jiang(at)inf(dot)ethz(dot)ch, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17986: Inconsistent results of SELECT affected by btree index
Date: 2023-06-21 04:11:05
Message-ID: 3689741.1687320665@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2023-06-21 07:20:50 Re: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by JOIN
Previous Message Andres Freund 2023-06-21 03:59:06 Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon