= SQL RECURSIVE prevent infinite recursion
{c}
Example under: \a[nodejs/sequelize/raw/tree.js]
* https://stackoverflow.com/questions/31739150/to-find-infinite-recursive-loop-in-cte Canon.
* <PostgreSQL>
* https://stackoverflow.com/questions/26671612/prevent-and-or-detect-cycles-in-postgres?noredirect=1&lq=1
* https://stackoverflow.com/questions/39555616/detect-cycles-using-sql
* <SQLite>:
* https://dba.stackexchange.com/questions/310874/check-a-record-exists-already-and-stop-the-loop-in-a-recursive-query
* https://stackoverflow.com/questions/66866542/sqlite-avoiding-cycles-in-depth-limited-recursive-cte
* <SQL Server>:
* https://stackoverflow.com/questions/58326847/sql-recursion-cte-infinite-loop
* https://dba.stackexchange.com/questions/215426/simple-recursive-cte-stuck-in-infinite-loop
* https://stackoverflow.com/questions/13718168/infinite-loop-in-cte-when-parsing-self-referencing-table
Back to article page