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

Thanks for your information! I checked it again. Seems this bug can be
reproduced when I used "quick-fix-for-bug-17985.patch" for bug 17985,
but cannot be reproduced after I used "better-fix-for-bug-17985.patch".
So it was fixed by the patch "better-fix-for-bug-17985.patch".

Best wishes,
Zuming

------------------------------------------------------------------------
*From:* Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
*Sent:* Wednesday, June 21, 2023 at 6:11 AM
*To:* Tomas Vondra
*Cc:* zuming(dot)jiang(at)inf(dot)ethz(dot)ch; pgsql-bugs(at)lists(dot)postgresql(dot)org
*Subject:* BUG #17986: Inconsistent results of SELECT affected by btree
index

> 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