On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Infinite looping
12. Mind infinity
Processing trees with recursive CTEs
Processing graphs with recursive ctes


Great job! With this kind of looping query, it's important to always have a termination check that will end the query at some point. Let's see what happens if we forget about that.


Look at the template. It's essentially the first example query from the previous section, but we removed the termination check. Try to run the query and find out for yourself what happens when the recursion never stops.

Click I'm done. Next exercise when you finish the exercise.