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 #16
--------------
select
p_brand,
p_type,
p_size,
count(distinct ps_suppkey) as supplier_cnt
from
partsupp,
part
where
p_partkey = ps_partkey
and p_brand <> 'Brand#25'
and p_type not like 'MEDIUM BRUSHED%'
and p_size in (1, 37, 22, 30, 12, 26, 39, 43)
and ps_suppkey not in (
select
s_suppkey
from
supplier
where
s_comment like '%Customer%Complaints%'
)
group by
p_brand,
p_type,
p_size
order by
supplier_cnt desc,
p_brand,
p_type,
p_size;
ColumnStore returned 19069 rows:
.
.
.
Brand#45 | LARGE BURNISHED NICKEL | 1 | 3 |
Brand#45 | STANDARD PLATED TIN | 26 | 3 |
Brand#51 | STANDARD BRUSHED TIN | 39 | 3 |
Brand#54 | MEDIUM POLISHED TIN | 26 | 3 |
Brand#55 | ECONOMY PLATED TIN | 37 | 3 |
Brand#55 | PROMO POLISHED TIN | 39 | 3 |
-----------------------------------------------------+
19069 rows in set (0.31 sec)
The same query on InnoDB returned 18284 rows:
.
.
.
Brand#45 | STANDARD PLATED TIN | 26 | 3 |
Brand#51 | STANDARD BRUSHED TIN | 39 | 3 |
Brand#54 | MEDIUM POLISHED TIN | 26 | 3 |
Brand#55 | ECONOMY PLATED TIN | 37 | 3 |
Brand#55 | PROMO POLISHED TIN | 39 | 3 |
-----------------------------------------------------+
18284 rows in set (0.26 sec)
Attachments
Issue Links
- is part of
-
MCOL-280 Beta issues
- Closed