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