SQLite Forum

Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body
Login
For virtual tables that might run forever in an infinite loop (like
wholenumber can), then the cost value of the xBestIndex method of the
virtual table implementation is important for helping the query planner
choose a plan that does not try to materialize the virtual table.  What
other virtual tables are you using that might return an infinite number
of results, depending on how it is used?