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 #12
select
l_shipmode,
sum(case
when o_orderpriority = '1-URGENT'
or o_orderpriority = '2-HIGH'
then 1
else 0
end) as high_line_count,
sum(case
when o_orderpriority <> '1-URGENT'
and o_orderpriority <> '2-HIGH'
then 1
else 0
end) as low_line_count
from
orders,
lineitem
where
o_orderkey = l_orderkey
and l_shipmode in ('REG AIR', 'RAIL')
and l_commitdate < l_receiptdate
and l_shipdate < l_commitdate
and l_receiptdate >= '1994-01-01'
and l_receiptdate < date_add( '1994-01-01' , interval 1 year)
group by
l_shipmode
order by
l_shipmode;
The same query on InnoDB returned:
-----------------------------------------
l_shipmode | high_line_count | low_line_count |
-----------------------------------------
RAIL | 6313 | 9320 |
REG AIR | 6246 | 9245 |
-----------------------------------------
2 rows in set (32.63 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed