INVALID_RECURSIVE_REFERENCE error condition
Invalid recursive reference found inside WITH RECURSIVE
clause.
NUMBER
Multiple self-references to one recursive CTE are not allowed.
PLACE
Recursive references cannot be used on the right side of left outer/semi/anti joins, on the left side of right outer joins, in full outer joins, in aggregates, and in subquery expressions.