Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.0.1
-
None
Description
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:
---------------------------+
s_name | numwait |
---------------------------+
Supplier#000000699 | 19 |
Supplier#000001543 | 19 |
Supplier#000007696 | 19 |
Supplier#000009689 | 19 |
Supplier#000002701 | 17 |
Supplier#000005892 | 17 |
Supplier#000005912 | 17 |
Supplier#000009367 | 17 |
Supplier#000000966 | 16 |
Supplier#000000967 | 16 |
Supplier#000003408 | 16 |
Supplier#000004069 | 16 |
Supplier#000004809 | 16 |
Supplier#000005081 | 16 |
Supplier#000006966 | 16 |
Supplier#000007317 | 16 |
Supplier#000007624 | 16 |
Supplier#000008182 | 16 |
Supplier#000008963 | 16 |
Supplier#000009774 | 16 |
Supplier#000009946 | 16 |
Supplier#000001513 | 15 |
Supplier#000001846 | 15 |
Supplier#000002284 | 15 |
Supplier#000003206 | 15 |
Supplier#000004012 | 15 |
Supplier#000005111 | 15 |
Supplier#000005417 | 15 |
Supplier#000005958 | 15 |
Supplier#000006063 | 15 |
Supplier#000006663 | 15 |
Supplier#000007331 | 15 |
Supplier#000008425 | 15 |
Supplier#000009500 | 15 |
Supplier#000000133 | 14 |
Supplier#000000160 | 14 |
Supplier#000001374 | 14 |
Supplier#000001485 | 14 |
Supplier#000001535 | 14 |
Supplier#000001796 | 14 |
Supplier#000002016 | 14 |
Supplier#000002255 | 14 |
Supplier#000002360 | 14 |
Supplier#000002884 | 14 |
Supplier#000003945 | 14 |
Supplier#000004264 | 14 |
Supplier#000005437 | 14 |
Supplier#000006134 | 14 |
Supplier#000006743 | 14 |
Supplier#000006837 | 14 |
Supplier#000006988 | 14 |
Supplier#000007831 | 14 |
Supplier#000008129 | 14 |
Supplier#000008439 | 14 |
Supplier#000008653 | 14 |
Supplier#000009269 | 14 |
Supplier#000009595 | 14 |
Supplier#000009674 | 14 |
Supplier#000000208 | 13 |
Supplier#000000994 | 13 |
Supplier#000001155 | 13 |
Supplier#000002276 | 13 |
Supplier#000002619 | 13 |
Supplier#000002984 | 13 |
Supplier#000003762 | 13 |
Supplier#000004378 | 13 |
Supplier#000004423 | 13 |
Supplier#000004439 | 13 |
Supplier#000004559 | 13 |
Supplier#000005512 | 13 |
Supplier#000005902 | 13 |
Supplier#000006060 | 13 |
Supplier#000006818 | 13 |
Supplier#000007076 | 13 |
Supplier#000007256 | 13 |
Supplier#000007485 | 13 |
Supplier#000008558 | 13 |
Supplier#000009280 | 13 |
Supplier#000009533 | 13 |
Supplier#000000022 | 12 |
Supplier#000000111 | 12 |
Supplier#000000227 | 12 |
Supplier#000000502 | 12 |
Supplier#000000655 | 12 |
Supplier#000000856 | 12 |
Supplier#000001041 | 12 |
Supplier#000001116 | 12 |
Supplier#000002067 | 12 |
Supplier#000002120 | 12 |
Supplier#000002376 | 12 |
Supplier#000002424 | 12 |
Supplier#000003074 | 12 |
Supplier#000003186 | 12 |
Supplier#000003334 | 12 |
Supplier#000003344 | 12 |
Supplier#000003409 | 12 |
Supplier#000003760 | 12 |
Supplier#000004084 | 12 |
Supplier#000004444 | 12 |
Supplier#000004688 | 12 |
---------------------------+
100 rows in set (1 min 57.14 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed