Analytic Functions: ROWID in OVER clause broken

Detail name	Value
Changelog Number	8967
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.2.0
Fix Versions	Exasol 7.0.0, Exasol 6.2.3, Exasol 7.0.0-alpha1
Resolution Date	2019-11-22

Bug

ROWID in OVER clause yields an "internal server error" unless ROWID is also selected separately.

Example

CREATE TABLE t(i INT);
SELECT
    RANK() OVER (PARTITION BY i ORDER BY ROWID)
FROM t;

Workaround

Also select the ROWID:

SELECT
    RANK() OVER (PARTITION BY i ORDER BY ROWID),
    ROWID -- workaround
FROM t;