GROUP BY ROLLUP/CUBE crash when given a single expression
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6474 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.beta1 |
| Fix Versions | Exasol 6.1.0, Exasol 6.1.rc1 |
| Resolution Date | 2018-07-25 |
Description
Queries using GROUP BY ROLLUP(...) or GROUP BY CUBE(...) with only a single ROLLUP or CUBE expression crash.
How to reproduce:
create table t1(a int); select sum(a) from t1 group by rollup(a);
Workaround
The only workaround is to not use the ROLLUP or CUBE feature here, but to rewrite the query using explicit GROUPING SETS.
