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

[smallhibiscus]

Proposed changes

Issue Number: close #xxx

Problem summary

Add test case of left join sql.

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...