MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs), Part Two – how to generate series
Inside the recursive CTE definition (the part in AS (…)), some syntax constraints must be respected […]
- a recursive SELECT mustn’t contain GROUP BY, aggregate functions
(like SUM), ORDER BY, LIMIT, DISTINCT (this rule doesn’t apply to the non-recursive/anchor/seed SELECT)
- a recursive SELECT must reference the CTE only once and only in its
FROM clause, not in any subquery.