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
100.00 * sum(case
when p_type like 'PROMO%'
then l_extendedprice * (1 - l_discount)
else 0
end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
from
lineitem,
part
where
l_partkey = p_partkey
and l_shipdate >= '1995-02-01'
and l_shipdate < date_add( '1995-02-01' , interval 1 month);
ColumnStore returned:
---------------
promo_revenue |
---------------
13.4636998004 |
---------------
1 row in set (0.030 sec)
InnoDB returned:
---------------
promo_revenue |
---------------
14.5856344411 |
---------------
Attachments
Issue Links
- is caused by
-
MCOL-4084 Integrated release builds cause random results for some queries
- Closed