[MCOL-2050] ORDER BY with OFFSET in subquery produces random and incorrect result Created: 2018-12-26  Updated: 2019-02-21  Resolved: 2019-02-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.2.2
Fix Version/s: 1.2.3

Type: Bug Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2019-01, 2019-02

 Description   

Using the schema and data from MCOL-1829 CS 1.1.6 and 1.2.2 produce different output for the query:

1.1.6

MariaDB [test]> select * from (select  num from football_teams order by num limit 3 offset 2) a;
 
+------+
 
| num  |
 
+------+
 
|    4 |
 
|    3 |
 
+------+
 
2 rows in set (0.02 sec)

1.2.2

MariaDB [test]> select * from (select num from football_teams order by num limit 3 offset 2) a;
 
+------+
 
| num  |
 
+------+
 
|    0 |
 
|    3 |
 
+------+
 
2 rows in set (0.014 sec)



 Comments   
Comment by Roman [ 2019-02-01 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2019-02-21 ]

Build verified: 1.2.3-1

server commit:
61f32f2
engine commit:
46cc344

Generated at Thu Feb 08 02:33:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.