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 #20
--------------
select
s_name,
s_address
from
supplier,
nation
where
s_suppkey in (
select
distinct (ps_suppkey)
from
partsupp,
part
where
ps_partkey=p_partkey
and p_name like 'goldenrod%'
and ps_availqty > (
select
0.5 * sum(l_quantity)
from
lineitem
where
l_partkey = ps_partkey
and l_suppkey = ps_suppkey
and l_shipdate >= '1993-01-01'
and l_shipdate < date_ADD('1993-01-01',interval 1 year)
)
)
and s_nationkey = n_nationkey
and n_name = 'IRAN'
order by
s_name;
Empty set (0.92 sec)
The same query on InnoDB returned 190 rows:
.
.
.
Supplier#000009538 | Ayts8hIvhFOuCtoGe5G9tbcFg |
Supplier#000009551 | 8fW3HZk0UVkr25gA |
Supplier#000009668 | nntt4TuvakUBxhfNuFg3 sQ3d8 |
Supplier#000009720 | leK82UIpE4GmuwkGpg3stx48r2WGr neoG |
Supplier#000009825 | MtmjXZzwLYcF5Sdte8KYKp9pzF |
Supplier#000009966 | f7UB YWpwxkecW40I07kFYA9Ytnwg |
------------------------------------------------------------+
190 rows in set (30.41 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed