[MCOL-4080] DBT3 query #14 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 1mb
query:
select
100.00 * sum(case
when p_type like 'PROMO%'
then l_extendedprice * (1 - l_discount)
else 0
end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
from
lineitem,
part
where
l_partkey = p_partkey
and l_shipdate >= '1995-02-01'
and l_shipdate < date_add( '1995-02-01' , interval 1 month);

ColumnStore returned:

---------------

promo_revenue

---------------

13.4636998004

---------------
1 row in set (0.030 sec)

InnoDB returned:

---------------

promo_revenue

---------------

14.5856344411

---------------

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