[MCOL-4073] DBT3 query #3 returns incorrect results Created: 2020-06-16 Updated: 2020-11-12 Resolved: 2020-06-18 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 1.5.1 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Build tested: 1.5.0-1 (drone build #120) database: dbt3 1m select l_orderkey, sum(l_extendedprice * (1 - l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem where c_mktsegment = 'HOUSEHOLD' and c_custkey = o_custkey and l_orderkey = o_orderkey and o_orderdate < '1995-03-08' and l_shipdate > '1995-03-08' group by l_orderkey, o_orderdate, o_shippriority order by revenue desc, o_orderdate LIMIT 10; ColumnStore returns: -----------
-----------
----------- InnoDB returns: -----------
-----------
----------- |
| Comments |
| Comment by Daniel Lee (Inactive) [ 2020-06-18 ] |
|
Query worked with a debug build |
| Comment by Daniel Lee (Inactive) [ 2020-06-18 ] |
|
It turned out the issue was caused by |