Internal server error when using columns from a values clause in group by in combination with order by and limit
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7228 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.0.14, Exasol 6.1.2 |
| Resolution Date | 2019-01-11 |
Description
When using a column from a values clause in a GROUP BY clause an internal server error is caused if the select with the GROUP BY also contains ORDER BY and LIMIT clauses.
Example
with tvalues (x) as (values 1,2,3) select count(*) cnt from tvalues group by tvalues.x order by cnt limit 10;
