Thread: left, right, full sort merge join plan

left, right, full sort merge join plan

From
CK Tan
Date:
Hi Hackers, 

I am looking for some help in creating LEFT/RIGHT/FULL sort-merge-join. Does anyone have a complete and reproducible script that would generate those plans? Can I find it in the regression test suite? If not, how do you exercise those code path for QA purposes? 

Thanks!

-cktan