Skip to content
CodeWiki
Practice
Paths
Tracks
Cheatsheets
Playground
Glossary
AI era
Search
⌘K
English
English
Chinese
Practice
Paths
Tracks
Cheatsheets
Playground
Glossary
AI era
English
English
Chinese
Practice
/
Quiz
/
Data and databases
/
Advanced SQL
What does a depth limit alone guarantee in a recursive CTE over data that may contain cyc…
from Advanced SQL
SQLite 3.45.1
intermediate
1 min
What does a depth limit alone guarantee in a recursive CTE over data that may contain cycles?
The returned hierarchy is complete and contains each node once.
Expansion is bounded, but the result may be truncated and repeated nodes may remain.
The database repairs cycles before evaluating the query.
Check
Ask AI about this kata
Report an error
previous kata
What rows does this SQLite query print?
Predict the output
next kata
Review generated tenant order query
Review AI code
A new version is available
Reload