Skip to main content

INVALID_RECURSIVE_REFERENCE error condition

SQLSTATE: 42836

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.