Check we don't misoptimize a NOT IN where the subquery returns no rows.
Tom Lane <tgl@sss.pgh.pa.us>
Check we don't misoptimize a NOT IN where the subquery returns no rows. Future-proofing against a common mistake in attempts to optimize NOT IN. We don't have such an optimization right now, but attempts to do so are in the works, and some of 'em are buggy. Add a regression test case covering the point. David Rowley Discussion: https://postgr.es/m/CAKJS1f90E9agVZryVyUpbHQbjTt5ExqS2Fsodmt5_A7E_cEyVA@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/subselect.out | modified | +13 −0 |
| src/test/regress/sql/subselect.sql | modified | +9 −0 |
Discussion
- NOT IN subquery optimization 52 messages · 2019-02-20 → 2019-06-14