fix(tianmu): The outermost query returned wrong result #1931

[Double0101]

Cause: Query execute by join->exec(). Solution: Solve limit=0 in tianmu, and fix crash in compile which refer to issue#1394. Then execute this query in tianmu.

Summary about this PR

Issue Number: close #issue_number_you_created

Tests Check List

• [ ] Unit test
• [x] Integration test
• [ ] Manual test (add detailed scripts or steps below)
• [ ] No code

Changelog

• [ ] New Feature
• [x] Bug Fix
• [ ] Performance Improvement
• [ ] Build/Testing/CI/CD
• [ ] Documentation
• [ ] Not for changelog (changelog entry is not required)

Documentation

• [ ] Affects user behaviors
• [ ] Contains syntax changes
• [ ] Contains variable changes
• [ ] Contains experimental features

[Double0101]

[ 99%] tianmu.issue1876                         w7 [ pass ]  1180619
[100%] shutdown_report                          w0 [ pass ]       
--------------------------------------------------------------------------
The servers were restarted 21 times
Spent 1835.439 of 1245 seconds executing testcases

Completed: All 278 tests were successful.

[mergify[bot]]

Thanks for the contribution! I have applied any labels matching special text in your PR Changelog.

Please review the labels and make any necessary changes.