Hi Alexander Korotkov, I saw the Bug: #18852 fix had been pushed. While I debug the sem- join pushed down codes, I wrote a patch to remove an unnecessary check on semijoin_target_ok() in [1]. The patch has been reviewed by Alexander Pyhalov. I think it's ready to commit.
Any thoughts? [1] https://www.postgresql.org/message-id/flat/CAHewXN=8aW4hd_W71F7Ua4+_w0=bppuvvtebfbf6g0nusxl...@mail.gmail.com -- Thanks, Tender Wang