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
nation,
o_year,
sum(amount) as sum_profit
from
(
select
n_name as nation,
year(o_orderdate) as o_year,
l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
from
part,
supplier,
lineitem,
partsupp,
orders,
nation
where
s_suppkey = l_suppkey
and ps_suppkey = l_suppkey
and ps_partkey = l_partkey
and p_partkey = l_partkey
and o_orderkey = l_orderkey
and s_nationkey = n_nationkey
and p_name like '%gainsboro%'
) as profit
group by
nation,
o_year
order by
nation,
o_year desc;
ColumnStore returned:
51 rows
sum_profile column values in returned rows are also incorrect
---------------------------------
nation | o_year | sum_profit |
---------------------------------
ARGENTINA | 1998 | 13789.3675 |
ARGENTINA | 1997 | 39231.2708 |
ARGENTINA | 1996 | 26622.2065 |
.
.
InnoDB returned:
62 rows
---------------------------------
nation | o_year | sum_profit |
---------------------------------
ARGENTINA | 1998 | 46383.6615 |
ARGENTINA | 1997 | 59845.8944 |
ARGENTINA | 1996 | 48629.9245 |
.
.
Attachments
Issue Links
- is caused by
-
MCOL-4084 Integrated release builds cause random results for some queries
- Closed