Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The order by subquery was not parsed successfully #31039

Open
jiangzj2024 opened this issue Apr 28, 2024 · 2 comments
Open

The order by subquery was not parsed successfully #31039

jiangzj2024 opened this issue Apr 28, 2024 · 2 comments

Comments

@jiangzj2024
Copy link

Query A:
select * from user_info001
union all
select * from user_info002
order by id;

Query B:
select * from (
select * from user_info001
union all
select * from user_info002) a
order by id;

Query A Global sorting of multiple horizontal sub-database;
Query B Individual sub-database are sorted independently,The order by subquery was not parsed successfully

@TherChenYang
Copy link
Collaborator

@jiangzj2024 Thank you very much for your feedback, Can you provide a test demo? This can help me locate the problem faster.

Copy link

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

@github-actions github-actions bot added the stale label May 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants