Hi Richard, > I left convert_ANY_sublink_to_join alone in this patch, since the fix > needs to go back to v16 and that change isn't needed for it. We can > do it as a follow-up cleanup on master.
Attached is the follow-up cleanup for master. It builds the subquery RTE directly in convert_ANY_sublink_to_join(), without a dummy ParseState. The patch builds and passes the core regression tests. Regards, Dongpo Liu
v1-0001-Build-subquery-RTEs-directly-for-ANY-sublinks.patch
Description: Binary data
