CONNECT BY LEVEL: Using START WITH and LEVEL may cause internal server error

Details

Detail name Value
Changelog Number 11693
Type Bug
Status Resolved
Affected Versions Exasol 6.2.0, Exasol 7.0.0
Fix Versions Exasol 7.1.0
Resolution Date 2021-08-03

Description

A query that meets the following conditions will return an internal server error:

  • The query contains a CONNECT BY LEVEL clause
  • The CONNECT BY clause contains a START WITH clause
  • The START WITH clause contains LEVEL

Example:

select *
from dual
connect by level < 10
start with level >= 0;

The above query raises an internal server error.
The expected result is 9 rows containing NULL.

Workaround

There is no workaround

Fix

The query returns the expected number of rows.