[MCOL-4074] DBT3 query #4 returns incorrect results Created: 2020-06-16  Updated: 2020-11-12  Resolved: 2020-06-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.5.1
Fix Version/s: N/A

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

Issue Links:
Problem/Incident
is caused by MCOL-4084 Integrated release builds cause rando... Closed

 Description   

Build tested: 1.5.0-1 (drone build #120)

Database: dbt3 1m
query:

select
o_orderpriority,
count as order_count
from
orders
where
o_orderdate >= date '1995-06-01'
and o_orderdate < date_add( '1995-06-01', interval 3 month)
and exists (
select
*
from
lineitem
where
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
)
group by
o_orderpriority
order by
o_orderpriority;

ColumnStore returned:

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

o_orderpriority order_count

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

1-URGENT 4
2-HIGH 2
3-MEDIUM 1
4-NOT SPECIFIED 1
5-LOW 1

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

InnoDB returned:

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

o_orderpriority order_count

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

1-URGENT 12
2-HIGH 18
3-MEDIUM 7
4-NOT SPECIFIED 8
5-LOW 8

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



 Comments   
Comment by Daniel Lee (Inactive) [ 2020-06-18 ]

Query worked with a debug build

Comment by Daniel Lee (Inactive) [ 2020-06-18 ]

It turned out the issue was caused by MCOL-4084. Engineering is working to resolve MCOL-4084 instead.

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