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

From David G. Johnston
Subject Re: Bug in execution of EXISTS and IN clauses for large tables
Date
Msg-id CAKFQuwZu-JTRz2R6+Xshm3-VzYEctzMo7hjj4Zn+dVcXypJHMA@mail.gmail.com
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs


On Tuesday, February 22, 2022, David G. Johnston <david.g.johnston@gmail.com> wrote:


On Tuesday, February 22, 2022, Martin Kos <martin.kos@molecularhealth.com> wrote:


I would like to report an unexpected behavior of the queries using either the EXISTS or IN clauses.


I am using PostgreSQL version 11.1 (accessed via the DBVisualizer).



Reporting bugs without a standalone reproducer against long unsupported versions is generally inactionable.

Though at minimum providing explain analyze results, especially if you have a near equivalent query that supposedly works, is needed.


My bad, too early for me…

This seems like a decent report (haven’t played with it), still, version 11.1!

David J.
 

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: Tom Lane
Date:
Subject: Re: Bug in execution of EXISTS and IN clauses for large tables