[MCOL-242] DBT3 query 16 returned incorrect result Created: 2016-07-01  Updated: 2016-09-02  Resolved: 2016-09-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.0.1
Fix Version/s: 1.0.2

Type: Bug Priority: Critical
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-280 Beta issues Closed

 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)



 Comments   
Comment by Daniel Lee (Inactive) [ 2016-09-02 ]

The empty resultset issue was caused by the bug described in MCOL-281.

Generated at Thu Feb 08 02:19:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.