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.