The order by subquery was not parsed successfully

[jiangzj2024]

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]

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