MSCEWI3065

The NOCYCLE property in a hierarchical clause is not supported in Snowflake.

Severity

Medium

Description

Snowflake does not have an equivalent for option NOCYCLE of the Oracle Connect By clause.

Example Code

Input Code:

SELECT UNIQUE A.* FROM TABLE1 A WHERE A.X = A.C CONNECT BY NOCYCLE A.C = 0 START WITH A.B = 1 HAVING X = 1 GROUP BY A.C;

Output Code:

SELECT DISTINCT A.* FROM PUBLIC.TABLITA A 
WHERE A.X = A.C 
GROUP BY A.C 
HAVING X = 1 
/*** MSC-ERROR - MSCEWI3063 - NOCYCLE property in a hierarchical clause is not supported in Snowflake ***/ 
CONNECT BY A.C = 0 START WITH A.B = 1;

Recommendations