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;