Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.5.2
-
Component/s: ExeMgr
-
Labels:None
Description
DROP TABLE IF EXISTS a; |
CREATE TABLE a (a INT) ENGINE=Columnstore; |
INSERT INTO a VALUES (1), (1), (2), (3); |
SELECT DISTINCT a FROM a LIMIT 2; |
/*
|
+------+
|
| a |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
*/
|
SELECT DISTINCT a FROM a LIMIT 2,2; |
/*
|
+------+
|
| a |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
Expected:
|
+------+
|
| a |
|
+------+
|
| 3 |
|
+------+
|
*/
|
SELECT DISTINCT a FROM a ORDER BY 1 LIMIT 2,2; |
/*
|
+------+
|
| a |
|
+------+
|
| 3 |
|
+------+
|
*/ |