Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.0.0
-
None
Description
Build tested: 1.5.4-1 (drone #441)
Some queries returned results in incorrect order. For example:
SELECT
`LOGICAL_TABLE_1`.`p_name` AS `COL0`,
`LOGICAL_TABLE_1`.`p_size` AS `COL1`
FROM
(select * from part where p_partkey < 20 limit 10) `LOGICAL_TABLE_1`
ORDER BY COL0, COL1;
COL0 COL1
goldenrod lavender spring chocolate lace 7
blush thistle blue yellow saddle 1
spring green yellow purple cornsilk 21
cornflower chocolate smoke green pink 14
forest brown coral puff cream 15
bisque cornflower lawn forest magenta 4
moccasin green thistle khaki floral 45
misty lace thistle snow royal 41
thistle dim navajo dark gainsboro 12
linen pink saddle puff powder 44
The columns are not sorted
Another example. the view is a join of two tables
select * from bug6134vv order by 1, 2, 3;
a b c
1 1 2
1 1 3
1 1 1
2 2 1
2 2 2
the third column is not sorted correctly.