[MCOL-4078] DBT3 query #10 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
c_custkey,
c_name,
sum(l_extendedprice * (1 - l_discount)) as revenue,
c_acctbal,
n_name,
c_address,
c_phone,
c_comment
from
customer,
orders,
lineitem,
nation
where
c_custkey = o_custkey
and l_orderkey = o_orderkey
and o_orderdate >= '1994-12-01'
and o_orderdate < date_add( '1994-12-01' , interval 3 month)
and l_returnflag = 'R'
and c_nationkey = n_nationkey
group by
c_custkey,
c_name,
c_acctbal,
c_phone,
n_name,
c_address,
c_comment
order by
revenue desc
LIMIT 20;

ColumnStore returned:

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

c_custkey c_name revenue c_acctbal n_name c_address c_phone c_comment

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

95 Customer#000000095 138209.6028 5327.38 MOROCCO EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 25-923-255-2929 ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the
113 Customer#000000113 117107.1886 2912.00 JAPAN eaOl5UBXIvdY57rglaIzqvfPD,MYfK 22-302-930-4756 usly regular theodolites boost furiously doggedly pending instructio
52 Customer#000000052 94407.0535 5630.28 IRAQ 7 QOqGqqSy9jfV51BC71jcHJSD0 21-186-284-5998 ic platelets use evenly even accounts. stealthy theodolites cajole furiou
124 Customer#000000124 80480.2608 1842.49 CHINA aTbyVAW5tCd,v09O 28-183-750-7809 le fluffily even dependencies. quietly s
122 Customer#000000122 53607.8100 7865.46 CANADA yp5slqoNd26lAENZW3a67wSfXA6hTF 13-702-694-4520 the special packages hinder blithely around the permanent requests. bold depos
133 Customer#000000133 50900.7590 2314.67 PERU IMCuXdpIvdkYO92kgDGuyHgojcUs88p 27-408-997-8430 t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu
139 Customer#000000139 48305.0910 7897.78 INDONESIA 3ElvBwudHKL02732YexGVFVt 19-140-352-1403 nstructions. quickly ironic ideas are carefully. bold,
100 Customer#000000100 46388.7744 9889.89 SAUDI ARABIA fptUABXcmkC5Wx 30-749-445-4907 was furiously fluffily quiet deposits. silent, pending requests boost against
97 Customer#000000097 34023.7184 2164.48 PERU OApyejbhJG,0Iw3j rd1M 27-588-919-5638 haggle slyly. bold, special ideas are blithely above the thinly bold theo
88 Customer#000000088 29371.8645 8031.44 MOZAMBIQUE wtkjBN9eyrFuENSMmMFlJ3e7jE5KXcg 26-516-273-2566 s are quickly above the quickly ironic instructions; even requests about the carefully final deposi
61 Customer#000000061 21924.4050 1536.24 PERU 9kndve4EAJxhg3veF BfXr7AqOsT39o gtqjaYE 27-626-559-8599 egular packages shall have to impress along the
35 Customer#000000035 13721.6970 1228.24 PERU TEjWGE4nBzJL2 27-566-888-7431 requests. special, express requests nag slyly furiousl
148 Customer#000000148 8841.7920 2135.60 IRAQ BhSPlEWGvIJyT9swk vCWE 21-562-498-6636 ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious
91 Customer#000000091 6407.4458 4643.14 INDIA S8OMYFrpHwoNHaGBeuS6E 6zhHGZiprw1b7 q 18-239-400-3677 onic accounts. fluffily silent pinto beans boost blithely according to the fluffily exp

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.056 sec)

InnoDB returned:

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

c_custkey c_name revenue c_acctbal n_name c_address c_phone c_comment

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

95 Customer#000000095 159993.5628 5327.38 MOROCCO EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 25-923-255-2929 ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the
133 Customer#000000133 130454.2784 2314.67 PERU IMCuXdpIvdkYO92kgDGuyHgojcUs88p 27-408-997-8430 t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu
49 Customer#000000049 122242.8362 4573.94 IRAN cNgAeX7Fqrdf7HQN9EwjUa4nxT,68L FKAxzl 20-908-631-4424 nusual foxes! fluffily pending packages maintain to the regular
113 Customer#000000113 117107.1886 2912.00 JAPAN eaOl5UBXIvdY57rglaIzqvfPD,MYfK 22-302-930-4756 usly regular theodolites boost furiously doggedly pending instructio
115 Customer#000000115 115503.9282 7508.92 INDIA 0WFt1IXENmUT2BgbsB0ShVKJZt0HCBCbFl0aHc 18-971-699-1843 sits haggle above the carefully ironic theodolite
62 Customer#000000062 111701.0967 595.61 GERMANY upJK2Dnw13, 17-361-978-7059 kly special dolphins. pinto beans are slyly. quickly regular accounts are furiously a
148 Customer#000000148 105971.4034 2135.60 IRAQ BhSPlEWGvIJyT9swk vCWE 21-562-498-6636 ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious
121 Customer#000000121 98942.3170 6428.32 PERU tv nCR2YKupGN73mQudO 27-411-990-2959 uriously stealthy ideas. carefully final courts use carefully
52 Customer#000000052 94407.0535 5630.28 IRAQ 7 QOqGqqSy9jfV51BC71jcHJSD0 21-186-284-5998 ic platelets use evenly even accounts. stealthy theodolites cajole furiou
134 Customer#000000134 91440.2266 4608.90 IRAQ sUiZ78QCkTQPICKpA9OBzkUp2FM 21-200-159-5932 yly fluffy foxes boost final ideas. b
124 Customer#000000124 80480.2608 1842.49 CHINA aTbyVAW5tCd,v09O 28-183-750-7809 le fluffily even dependencies. quietly s
89 Customer#000000089 74578.7108 1530.76 KENYA dtR, y9JQWUO6FoJExyp8whOU 24-394-451-5404 counts are slyly beyond the slyly final accounts. quickly final ideas wake. r
142 Customer#000000142 73704.2692 2209.81 INDONESIA AnJ5lxtLjioClr2khl9pb8NLxG2, 19-407-425-2584 . even, express theodolites upo
73 Customer#000000073 68108.4300 4288.50 ALGERIA 8IhIxreu4Ug6tt5mog4 10-473-439-3214 usual, unusual packages sleep busily along the furiou
79 Customer#000000079 64295.2946 5121.28 MOROCCO n5hH2ftkVRwW8idtD,BmM2 25-147-850-4166 es. packages haggle furiously. regular, special requests poach after the quickly express ideas. blithely pending re
118 Customer#000000118 60621.8265 3582.37 CHINA OVnFuHygK9wx3xpg8 28-639-943-7051 uick packages alongside of the furiously final deposits haggle above the fluffily even foxes. blithely dogged dep
131 Customer#000000131 60393.0600 8595.53 IRAQ jyN6lAjb1FtH10rMC,XzlWyCBrg75 21-840-210-3572 jole special packages. furiously final dependencies about the furiously speci
137 Customer#000000137 59509.9566 7838.30 MOZAMBIQUE cdW91p92rlAEHgJafqYyxf1Q 26-777-409-5654 carefully regular theodolites use. silent dolphins cajo
122 Customer#000000122 53607.8100 7865.46 CANADA yp5slqoNd26lAENZW3a67wSfXA6hTF 13-702-694-4520 the special packages hinder blithely around the permanent requests. bold depos
139 Customer#000000139 48305.0910 7897.78 INDONESIA 3ElvBwudHKL02732YexGVFVt 19-140-352-1403 nstructions. quickly ironic ideas are carefully. bold,

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