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 1m
query:
select
o_orderpriority,
count as order_count
from
orders
where
o_orderdate >= date '1995-06-01'
and o_orderdate < date_add( '1995-06-01', interval 3 month)
and exists (
select
*
from
lineitem
where
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
)
group by
o_orderpriority
order by
o_orderpriority;
ColumnStore returned:
----------------------------+
o_orderpriority | order_count |
----------------------------+
1-URGENT | 4 |
2-HIGH | 2 |
3-MEDIUM | 1 |
4-NOT SPECIFIED | 1 |
5-LOW | 1 |
----------------------------+
InnoDB returned:
----------------------------+
o_orderpriority | order_count |
----------------------------+
1-URGENT | 12 |
2-HIGH | 18 |
3-MEDIUM | 7 |
4-NOT SPECIFIED | 8 |
5-LOW | 8 |
----------------------------+
Attachments
Issue Links
- is caused by
-
MCOL-4084 Integrated release builds cause random results for some queries
- Closed