🪲 CTEs cannot contain references to other CTEs

[joocer]

trafficstars

Prevent cyclic references, but allow recursive.

WITH RECURSIVE factorial_cte(n, factorial) AS (
  SELECT 0, 1
  UNION ALL
  SELECT n + 1, (n + 1) * factorial
  FROM factorial_cte
  WHERE n < 9
)
SELECT factorial FROM factorial_cte;