On Mon, Oct 12, 2026 at 10:57 AM wenhui qiu <[email protected]> wrote: > In addition, looking at the regression tests: the patch updates both > convert_EXISTS_sublink_to_join() and convert_ANY_sublink_to_join(), but the > added tests only cover the NOT EXISTS case. It would be great to also add a > test case for NOT IN (which exercises the convert_ANY_sublink_to_join() code > path with under_not = true).
Makes sense. But the query you suggested doesn't not work. int4_tbl.f1 and tenk1.unique1 are both nullable, so the NOT IN is not converted to an antijoin. In v2 I added a NOT IN test that works. (That test won't be in the back-patches for v16 to v18.) - Richard
