[MCOL-245] DBT3 query 20 returned an empty result set 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 #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)



 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:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.