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 #7
select
supp_nation,
cust_nation,
l_year,
sum(volume) as revenue
from
(
select
n1.n_name as supp_nation,
n2.n_name as cust_nation,
year(l_shipdate) as l_year,
l_extendedprice * (1 - l_discount) as volume
from
supplier,
lineitem,
orders,
customer,
nation n1,
nation n2
where
s_suppkey = l_suppkey
and o_orderkey = l_orderkey
and c_custkey = o_custkey
and s_nationkey = n1.n_nationkey
and c_nationkey = n2.n_nationkey
and (
(n1.n_name = 'ETHIOPIA' and n2.n_name = 'JORDAN')
or (n1.n_name = 'JORDAN' and n2.n_name = 'ETHIOPIA')
)
and l_shipdate between date('1995-01-01') and date('1996-12-31')
) as shipping
group by
supp_nation,
cust_nation,
l_year
order by
supp_nation,
cust_nation,
l_year;
The same query on InnoDB returned:
-------------------------------------------+
supp_nation | cust_nation | l_year | revenue |
-------------------------------------------+
ETHIOPIA | JORDAN | 1995 | 54454793.4142 |
ETHIOPIA | JORDAN | 1996 | 49143119.7914 |
JORDAN | ETHIOPIA | 1995 | 49447292.2659 |
JORDAN | ETHIOPIA | 1996 | 46573682.6700 |
-------------------------------------------+
4 rows in set (15.88 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed