SQLite Forum

cycle detection in CHECK constraint with recursive CTE
Login
FWIW, `WHERE EXISTS` often uses a `SELECT 1 FROM ... WHERE ...` query, because it does not matter what you select,  
it's the mere fact a single row exists that matters.  So selecting anything else is just *wasting cycles* :).  
Not that it matters performance-wise, most likely, so just an FYI.