Re: Bug in execution of EXISTS and IN clauses for large tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in execution of EXISTS and IN clauses for large tables
Date
Msg-id 701248.1645544708@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in execution of EXISTS and IN clauses for large tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses RE: Bug in execution of EXISTS and IN clauses for large tables
List pgsql-bugs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> This seems like a decent report (haven’t played with it), still, version
> 11.1!

Indeed.  I can't see any problem in 11.current --- for me, the first
four queries all give 44272445, the next 72002328, and the last two
60000000.  So either we fixed it since 11.1, or the problem requires
some nondefault setting that wasn't mentioned.  I'm not particularly
interested in bisecting to see where it was fixed.

            regards, tom lane



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Bug in execution of EXISTS and IN clauses for large tables
Next
From: Martin Kos
Date:
Subject: RE: Bug in execution of EXISTS and IN clauses for large tables