MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs), Part Two – how to generate series
Here is the second in a series of posts about CTEs, a new feature of MySQL 8.0, available in this Labs release. The first post ended with:
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.
