On 2017/09/05 10:00 PM, Stephen Chrzanowski wrote:
On behalf of Cecil, the fault in that logic is that count(*) returns the
number of rows in that table, not whether there is a hole "somewhere: Your
query will either return 1, or, 0.
Perhaps this is the opportune moment to learn. Test the theory in
SQLite, you will see that Igor is correct (and correct for all versions
of SQL, not just -lite).
sqlite-users mailing list