SYS_CONNECT_BY_PATH results longer than 8000 characters can lead to error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7646 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.0.15, Exasol 6.1.3 |
| Resolution Date | 2019-05-22 |
The function SYS_CONNECT_BY_PATH can lead to an error under rare conditions.
A precondition for this problem is that the result of SYS_CONNECT_BY_PATH exceeds 8000 characters.
Example:
create table t(x int);
insert into t values 0,0;
select sys_connect_by_path(x, '_OOOOOOOO_')
from t
connect by
prior x = x
and level < 35;