SYS_CONNECT_BY_PATH and CONNECT_BY_ROOT can lead to internal server error when used with lots of string data
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9118 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Problem
The functions SYS_CONNECT_BY_PATH and CONNECT_BY_ROOT can lead to an internal server error under rare conditions.
Preconditions for this to happen:
- the arguments are VARCHAR/CHAR data
- the amount of data to be processed is huge
Workaround
Process the data in smaller chunks if possible, e.g. use multiple queries with different filters.
