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)