Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Done
-
1.5.1
-
None
Description
Build tested: 1.5.0-1 (drone build #120)
database: dbt3 1mb
query:
select
c_count,
count as custdist
from
(
select
c_custkey,
count(o_orderkey) as c_count
from
customer left outer join orders on
c_custkey = o_custkey
and o_comment not like '%special%requests%'
group by
c_custkey
) as c_orders
group by
c_count
order by
custdist desc,
c_count desc;
ColumnStore returned:
-----------------+
c_count | custdist |
-----------------+
0 | 109 |
7 | 6 |
6 | 5 |
5 | 5 |
12 | 4 |
9 | 4 |
4 | 3 |
3 | 3 |
14 | 2 |
10 | 2 |
8 | 2 |
17 | 1 |
15 | 1 |
11 | 1 |
2 | 1 |
1 | 1 |
-----------------+
16 rows in set (0.051 sec)
InnoDB returned:
-----------------+
c_count | custdist |
-----------------+
0 | 50 |
16 | 8 |
17 | 7 |
20 | 6 |
13 | 6 |
12 | 6 |
9 | 6 |
23 | 5 |
14 | 5 |
10 | 5 |
21 | 4 |
18 | 4 |
11 | 4 |
8 | 4 |
7 | 4 |
26 | 3 |
22 | 3 |
6 | 3 |
5 | 3 |
4 | 3 |
29 | 2 |
24 | 2 |
19 | 2 |
15 | 2 |
28 | 1 |
25 | 1 |
3 | 1 |
-----------------+
27 rows in set (0.115 sec)
Attachments
Issue Links
- is caused by
-
MCOL-4084 Integrated release builds cause random results for some queries
- Closed