"Invalid recursive query"
Item | Description |
---|---|
SQLCode |
-921L |
Constant |
INVALID_RECURSION |
SQLState |
42W99 |
ODBC 2 State |
37000 |
ODBC 3 State |
42000 |
Sybase Error Code |
2586 |
Severity Code |
A recursive query must consist of the UNION ALL of an initial query and an iteration query. The only set operation allowed in the iteration query is UNION ALL. A recursive reference to the name of the common table expression can only appear in the iteration query, and must not be in a SELECT that uses DISTINCT, ORDER BY, or an aggregate function. A recursive reference also cannot appear on the NULL-supplying side of an outer join, or in a subquery.