[HIVE-25606] The global limit invalidates the subquery order by

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.1
• Component/s: CBO, Parser
• Target Version/s: 3.1.1
• Assignee: Unassigned
• Reporter: jinwensc
• Due: 09/Oct/21
• Created: 09/Oct/21 10:18
• Updated: 12/Oct/21 11:31

Description

create table test_1009(id int);
insert into table test_1009 values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13);
select * from (select * from test_1009 order by id desc) a limit 10;

 

-------

a.id

-------

1
2
3
4
5
6
7
8
9
10

–

 

-----------------------

the right result should be 

-------

a.id

-------

13
12
11
10
9
8
7
6
5
4

-------