[MCOL-4081] DBT3 query #16 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
p_brand,
p_type,
p_size,
count(distinct ps_suppkey) as supplier_cnt
from
partsupp,
part
where
p_partkey = ps_partkey
and p_brand <> 'Brand#25'
and p_type not like 'MEDIUM BRUSHED%'
and p_size in (1, 37, 22, 30, 12, 26, 39, 43)
and ps_suppkey not in (
select
s_suppkey
from
supplier
where
s_comment like '%Customer%Complaints%'
)
group by
p_brand,
p_type,
p_size
order by
supplier_cnt desc,
p_brand,
p_type,
p_size;

ColumnStore returned:

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

p_brand p_type p_size supplier_cnt

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

Brand#11 ECONOMY ANODIZED STEEL 26 4
Brand#14 SMALL ANODIZED TIN 26 4
Brand#32 PROMO ANODIZED STEEL 1 4
Brand#35 STANDARD BRUSHED BRASS 39 4
Brand#41 PROMO BRUSHED NICKEL 43 4
Brand#43 LARGE POLISHED STEEL 30 4

--------------------------------------------------+
6 rows in set (0.053 sec)

InnoDB returned:

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

p_brand p_type p_size supplier_cnt

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

Brand#11 ECONOMY ANODIZED STEEL 26 4
Brand#11 ECONOMY ANODIZED TIN 1 4
Brand#13 LARGE BRUSHED BRASS 1 4
Brand#14 SMALL ANODIZED TIN 26 4
Brand#21 MEDIUM ANODIZED BRASS 1 4
Brand#23 SMALL PLATED NICKEL 26 4
Brand#32 LARGE ANODIZED STEEL 26 4
Brand#32 PROMO ANODIZED STEEL 1 4
Brand#33 STANDARD PLATED BRASS 26 4
Brand#35 SMALL BURNISHED NICKEL 39 4
Brand#35 STANDARD BRUSHED BRASS 39 4
Brand#41 PROMO BRUSHED NICKEL 43 4
Brand#43 LARGE POLISHED STEEL 30 4
Brand#43 SMALL BURNISHED STEEL 12 4
Brand#45 PROMO ANODIZED BRASS 22 4
Brand#53 SMALL BURNISHED TIN 12 4
Brand#54 MEDIUM POLISHED BRASS 22 4
Brand#54 STANDARD ANODIZED BRASS 22 4
Brand#55 MEDIUM BURNISHED NICKEL 1 4
Brand#52 STANDARD ANODIZED BRASS 43 2
Brand#53 SMALL POLISHED TIN 43 2
Brand#15 ECONOMY POLISHED TIN 12 1
Brand#44 STANDARD PLATED TIN 37 1
Brand#45 SMALL ANODIZED NICKEL 26 1

---------------------------------------------------+
24 rows in set (0.012 sec)



 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.