[MCOL-236] DBT3 query 3 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 #3

select
l_orderkey,
sum(l_extendedprice * (1 - l_discount)) as revenue,
o_orderdate,
o_shippriority
from
customer,
orders,
lineitem
where
c_mktsegment = 'HOUSEHOLD'
and c_custkey = o_custkey
and l_orderkey = o_orderkey
and o_orderdate < '1995-03-08'
and l_shipdate > '1995-03-08'
group by
l_orderkey,
o_orderdate,
o_shippriority
order by
revenue desc,
o_orderdate
LIMIT 10;

Empty set (0.32 sec)

The same query on InnoDB returned:

------------------------------------------------+

l_orderkey revenue o_orderdate o_shippriority

------------------------------------------------+

2845094 433962.5553 1995-03-06 0
2113221 400959.3634 1995-02-19 0
1902471 400497.3847 1995-03-01 0
2184195 396839.1463 1995-03-04 0
519556 390030.5160 1995-02-15 0
2529826 387365.1560 1995-02-17 0
5329575 374659.8572 1995-03-07 0
3323684 370249.1932 1995-03-05 0
2906022 370116.1556 1995-02-27 0
1062786 368331.4043 1995-02-10 0

------------------------------------------------+
10 rows in set (48.14 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:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.