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 #3
select
l_orderkey,
sum(l_extendedprice * (1 - l_discount)) as revenue,
o_orderdate,
o_shippriority
from
customer,
orders,
lineitem
where
c_mktsegment = 'HOUSEHOLD'
and c_custkey = o_custkey
and l_orderkey = o_orderkey
and o_orderdate < '1995-03-08'
and l_shipdate > '1995-03-08'
group by
l_orderkey,
o_orderdate,
o_shippriority
order by
revenue desc,
o_orderdate
LIMIT 10;
Empty set (0.32 sec)
The same query on InnoDB returned:
------------------------------------------------+
l_orderkey | revenue | o_orderdate | o_shippriority |
------------------------------------------------+
2845094 | 433962.5553 | 1995-03-06 | 0 |
2113221 | 400959.3634 | 1995-02-19 | 0 |
1902471 | 400497.3847 | 1995-03-01 | 0 |
2184195 | 396839.1463 | 1995-03-04 | 0 |
519556 | 390030.5160 | 1995-02-15 | 0 |
2529826 | 387365.1560 | 1995-02-17 | 0 |
5329575 | 374659.8572 | 1995-03-07 | 0 |
3323684 | 370249.1932 | 1995-03-05 | 0 |
2906022 | 370116.1556 | 1995-02-27 | 0 |
1062786 | 368331.4043 | 1995-02-10 | 0 |
------------------------------------------------+
10 rows in set (48.14 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed