On 2/15/2017 1:53 PM, Jens-Heiner Rechtien wrote:
Please try the following with the restored database:
The query
*select * from albums, album_asset, cacheReferences, coreInfo, space
limit 1;*
will hang as well.
Ah, interesting. space is empty, which is what makes the difference. In
the query plan, it ends up in the innermost loop. SQLite then goes
through the full cross join of all the other tables, only to get to the
inner loop and discover that there isn't going to be a row after all.
"LIMIT 1" doesn't help any as the query is never going to produce a row.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
