LEVEL (CONNECT BY) on virtual table crashes

Details

Detail name Value
Changelog Number 7083
Type Bug
Status Resolved
Affected Versions Exasol 6.1.0, Exasol 6.0.12
Fix Versions Exasol 6.0.14, Exasol 6.1.1
Resolution Date 2018-11-28

Problem

If you use the special column LEVEL in a connect by query on a virtual table, the query crashes.

Example: 

SELECT level FROM virtual_schema.t connect by level < 3;

Workaround

Use a subquery for the virtual table:

SELECT level FROM (select * from virtual_schema.t) connect by level < 3;