Skip to content
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

Jump to bottom

Support limit in CTEExec #24869

Closed
guo-shaoge opened this issue May 24, 2021 · 1 comment · Fixed by #24870
Closed

Support limit in CTEExec #24869

guo-shaoge opened this issue May 24, 2021 · 1 comment · Fixed by #24870
Labels
type/new-feature

Comments

@guo-shaoge
Copy link
Collaborator

Development Task

User can use limit to easily terminate the recursive CTE. So no need to worry infinite loop. For example:

with recursive cte1(c1) as (select 1 union select c1 + 1 from cte1 limit 5 offset 1) select * from cte1;
@guo-shaoge guo-shaoge added the type/enhancement The issue or PR belongs to an enhancement. label May 24, 2021
@guo-shaoge guo-shaoge added type/new-feature and removed type/enhancement The issue or PR belongs to an enhancement. labels May 24, 2021
@guo-shaoge guo-shaoge mentioned this issue May 24, 2021
Merged
@tisonkun
Copy link
Contributor

subtask of #17472

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/new-feature
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

executor: add limit implementation for CTEExec guo-shaoge/tidb
2 participants
@guo-shaoge @tisonkun