Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2
-
None
-
2018-14
Description
in working_tpch1_compareLogOnly/tableMode/tablemode.sql, we find:
set infinidb_vtable_mode=0;
SELECT SUM( c_acctbal* (1-c_acctbal)) AS REVENUE FROM CUSTOMER, nation WHERE C_MKTSEGMENT = 'BUILDING' and c_nationkey<3 AND C_nationkey = n_nationkey GROUP BY c_custkey ORDER BY REVENUE DESC;
This breaks with:
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-3011: Non-supported item in Order By clause.
The problem appears to be an aggregate used as an ORDER BY.
This doesn't break with vtable mode = 1.
Attachments
Issue Links
- relates to
-
MCOL-1456 Query doesn't try REDO_PHASE1
- Closed