Build tested: 1.5.0-1 (drone build #120)

database: dbt3 1mb
query:
select
p_brand,
p_type,
p_size,
count(distinct ps_suppkey) as supplier_cnt
from
partsupp,
part
where
p_partkey = ps_partkey
and p_brand <> 'Brand#25'
and p_type not like 'MEDIUM BRUSHED%'
and p_size in (1, 37, 22, 30, 12, 26, 39, 43)
and ps_suppkey not in (
select
s_suppkey
from
supplier
where
s_comment like '%Customer%Complaints%'
)
group by
p_brand,
p_type,
p_size
order by
supplier_cnt desc,
p_brand,
p_type,
p_size;

ColumnStore returned:

--------------------------------------------------+

--------------------------------------------------+

--------------------------------------------------+
6 rows in set (0.053 sec)

InnoDB returned:

---------------------------------------------------+

---------------------------------------------------+

---------------------------------------------------+
24 rows in set (0.012 sec)