While reviewing v6, I noticed try_coalesce_eq() in eqjoinsel() returns
before the function ever looks at sjinfo->jointype, so SEMI/ANTI joins
get the same formula meant for INNER/LEFT/FULL. I'm not sure it is true.
Shouldn't the fat path be restricted to INNER/LEFT/FULL until SEMI/ANTI
get their own existence-base treatment?
--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/