Build tested: alpha 1.0.1

mscadmin> getsoft
getsoftwareinfo Fri Jul 1 18:33:11 2016

Name : mariadb-columnstore-platform
Version : 1.0
Release : 1
Architecture: x86_64
Install Date: Fri 24 Jun 2016 07:28:00 PM UTC

Create a DBT3 (TPCH) database and load 1gb of data

execute the query #21

--------------
select
s_name,
count as numwait
from
supplier,
lineitem l1,
orders,
nation
where
s_suppkey = l1.l_suppkey
and o_orderkey = l1.l_orderkey
and o_orderstatus = 'F'
and l1.l_receiptdate > l1.l_commitdate
and exists (
select
*
from
lineitem l2
where
l2.l_orderkey = l1.l_orderkey
and l2.l_suppkey <> l1.l_suppkey
)
and not exists (
select
*
from
lineitem l3
where
l3.l_orderkey = l1.l_orderkey
and l3.l_suppkey <> l1.l_suppkey
and l3.l_receiptdate > l3.l_commitdate
)
and s_nationkey = n_nationkey
and n_name = 'EGYPT'
group by
s_name
order by
numwait desc,
s_name
LIMIT 100;

Empty set (0.92 sec)

The same query on InnoDB returned 100 rows:

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

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

---------------------------+
100 rows in set (1 min 57.14 sec)