Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Done
-
1.5.1
-
None
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)
Attachments
Issue Links
- is caused by
-
MCOL-4084 Integrated release builds cause random results for some queries
- Closed