"SELECT LEVEL FROM subselect WHERE FALSE CONNECT BY" causes internal server error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 26413 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.32.0 |
| Fix Versions | Exasol 2025.1.0 |
| Resolution Date | 2025-07-08 |
Description
A SELECT query causes an internal server error if all of the following conditions are met:
- The query uses CONNECT BY.
- LEVEL occurs in the select list.
- The FROM clause is a subselect.
- The WHERE clause is constant FALSE.
Example
SELECT LEVEL FROM (SELECT 0 AS a) WHERE FALSE CONNECT BY a = a;
Workaround
There is no workaround except rewriting the query so that it doesn’t meet the conditions listed above.
Fix
The query works again.
