[MCOL-3916] Limit with offset doesn't work Created: 2020-04-01  Updated: 2020-04-09  Resolved: 2020-04-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 1.4.3
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: David Hall (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Consider the following in 1.2.6:

MariaDB [tpch1]> select * from region limit 1 offset 2;
 
+-------------+--------+---------------------------------+
 
| r_regionkey | r_name | r_comment                       |
 
+-------------+--------+---------------------------------+
 
|           2 | ASIA   | ges. thinly even pinto beans ca |
 
+-------------+--------+---------------------------------+
 
1 row in set (0.549 sec)

In 1.4:

MariaDB [tpch1]> select * from region limit 1 offset 2;
 
Empty set (0.211 sec)



 Comments   
Comment by David Hall (Inactive) [ 2020-04-01 ]

This regression is brought to you by queries/working_tpch1/misc/bug4222.sql

Comment by David Hall (Inactive) [ 2020-04-09 ]

The bug had been fixed in a later version of server. A simple pull of new code removed the problem.

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