What goes wrong with this recursive CTE intended to walk an org chart, and what is the usual safeguard?
WITH RECURSIVE chain AS (
SELECT id, manager_id FROM emp WHERE id = 7
UNION ALL
SELECT e.id, e.manager_id
FROM emp e JOIN chain c ON e.id = c.manager_id
)
SELECT * FROM chain;