Cecil Westerhof wrote:
> I see that in certain older queries I use:
> LIMIT (SELECT COUNT(*) FROM TABLE)
> It looks like this has no use (limiting the selected records to the
> number of records there are). Anyone an idea what could be a reason for
Trying to put some table data into the cache?
Reading into a fixed-sized array, and protecting against concurrent
inserts (from inside the same transaction)?
Needing the LIMIT clause for some reason (disabling subquery flattening?)
but not knowing about "LIMIT -1"?
sqlite-users mailing list