Skip to main content

INVALID_RECURSIVE_REFERENCE error condition

SQLSTATE: 42836

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.