Mar 2019

1 commit
Check we don't misoptimize a NOT IN where the subquery returns no rows.
1 Mar 2019Tom Lanemaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surewritten from the discussion, no matching patch

Adds only the empty-inner NOT IN regression in src/test/regress/sql/subselect.sql and its expected output, following David Rowley's standalone SQL test in #25, which is not an indexed patchset. Tom Lane confirms pushing it in #26; none of the optimizer implementations landed in this commit.

Credits across 1 commit

Committer
Tom Lane1