[regression-test](join) Add test case of join sql

[smallhibiscus]

Proposed changes

Issue Number: close #xxx

Problem summary

1.Add test case of join sql. 2.sql select t.* from ( select * from wftest1 t1 left join wftest2 t2 on t1.aa=t2.cc ) t where dayofweek(current_date())=2; correct result should be empty

Checklist(Required)

1. Does it affect the original behavior:
   • [ ] Yes
   • [x] No
   • [ ] I don't know
2. Has unit tests been added:
   • [ ] Yes
   • [x] No
   • [ ] No Need
3. Has document been added or modified:
   • [ ] Yes
   • [x] No
   • [ ] No Need
4. Does it need to update dependencies:
   • [ ] Yes
   • [x] No
5. Are there any changes that cannot be rolled back:
   • [ ] Yes (If Yes, please explain WHY)
   • [x] No

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...