INVALID_RECURSIVE_REFERENCE error condition
Invalid recursive reference found inside WITH RECURSIVE
clause.
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 and in aggregates.