Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
I am not sure if this a bug or an intended limitation.
But this is not documented and this is certainly an issue. We cannot run a lot of queries in TPC-DS because of this.
create table _t1 (a int, b int, c int); |
 |
explain
|
select |
a,b,c
|
from |
_t1
|
group by |
a,b,c with rollup |
order by |
a,b,c;
|
Gives this error:
ERROR 1221 (HY000): Incorrect usage of CUBE/ROLLUP and ORDER BY
|
Attachments
Issue Links
- relates to
-
MDEV-17802 Check how optimizer behaves for TPC-DS queries
- Stalled