New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support recursive CTEs #16415

Open

5 of 9 tasks

systay opened this issue Jul 17, 2024 · 0 comments

Assignees

Collaborator

systay commented Jul 17, 2024 •

edited

Loading

We want to fully support recursive CTEs. In order to do so, we need to do these things:

Support them in the semantic analysis
Disallow aggregation, ordering, grouping and distinct on the CTE queries
Plan unsharded recursive CTEs
Plan recursive CTEs that can be pushed down to a shard
Implement engine primitive to allow the recursion to happen in the vtgate
Type output columns from CTEs
Type coercion in the UNION
Merge CTEs when possible
Add @@cte_max_recursion_depth and use it to abort

systay self-assigned this

systay mentioned this issue

Support recursive CTEs #16427

Merged

5 tasks

systay mentioned this issue

Additional recursive CTE work #16616

Merged

5 tasks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment