ORDER BY with parenthesis crashes

Detail name	Value
Changelog Number	4769
Type	Bug
Status	Resolved
Affected Versions	EXASolution 5.0.0
Fix Versions	EXASOL 6.0.0
Resolution Date	2017-03-16

Situation

For ORDER BY clauses containing more than one expression,
the expression list may not be put into parentheses.

In EXASOL versions prior to 6.0.0, such queries will result in an Internal server error and a transaction rollback.

Examples

The following query will cause the SQL process to restart:

select * from dual order by (dummy,dummy);

This is also true for row valued expression that are given using the * wildcard.
So, this also crashes:

create table a(x int, y int);
select * from  a order by a.*;

Exemptions

ORDER BY clauses containing only a single expression are not affected by this problem.

I.e.: The following query will work as expected:

select * from dual order by (dummy);

Changed

EXASOL 6.0.0 will reject such queries with error message ORDER BY clause contains row expression.
We plan to support such sort expressions with EXASOL 6.1