Integrated release builds cause random results for some queries (MCOL-4084)

[MCOL-4075] DBT3 query #5 returns incorrect result 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: Sub-Task 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 1 mb
query:

select
n_name,
sum(l_extendedprice * (1 - l_discount)) as revenue
from
customer,
orders,
lineitem,
supplier,
nation,
region
where
c_custkey = o_custkey
and l_orderkey = o_orderkey
and l_suppkey = s_suppkey
and c_nationkey = s_nationkey + 0
and s_nationkey = n_nationkey
and n_regionkey = r_regionkey
and r_name = 'AMERICA'
and o_orderdate >= '1993-01-01'
and o_orderdate < date_add( '1993-01-01' , interval 1 year)
group by
n_name
order by
revenue desc;

ColumnStore returned:

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

n_name revenue

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

PERU 274012.6324

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

InnoDB returned:

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

n_name revenue

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

PERU 527161.1575
ARGENTINA 34521.3330

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



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