Support "Right Semi Join" plan shapes

[wenhui qiu]

Hi Richard Guo       I see that the test samples are all (exists)
subqueries ,I think semi join should also support ( in) and ( any)
subqueries. would you do more test on  ( in) and ( any) subqueries?


Best whish