Add more joined and distributed sub select test cases.