Connect by with join crashes for some hierarchical query operatiors

Detail name	Value
Changelog Number	2002
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, EXASolution 5.0.0
Fix Versions	EXASOL 6.0.0, EXASolution 5.0.21
Resolution Date	2017-03-16

Using of CONNECT BY in combination with a JOIN and
with hierarchical query operators (e.g. CONNECT_BY_ISLEAF, LEVEL)
leads to an internal server error.

Reproducibility:

CREATE SCHEMA TEST;
CREATE OR REPLACE TABLE T0(C0 VARCHAR(10));
CREATE OR REPLACE TABLE T1(C1 VARCHAR(10));

SELECT T1.CONNECT_BY_ISLEAF
FROM
T1 INNER JOIN T0 ON T1.C1 = T0.C0
CONNECT BY PRIOR C1 = C0;

Error:

[40005] Successfully reconnected after internal server error, transaction was rolled back.

Workaround:
Use of a subselect for the join.

SELECT TMP.CONNECT_BY_ISLEAF
FROM
(SELECT * FROM T1 INNER JOIN T0 ON T1.C1 = T0.C0) TMP
CONNECT BY PRIOR C1 = C0;

How to identify:
Using CONNECT BY, JOIN and a hierarchical query operation leads to an
internal server error.