Hi SQLite team,
please consider the attached dump of a sqlite3 database and the
following - admittedly nonsensical, don't ask - query over a restored
version of the database:
*SELECT count(*) FROM spacefavorite, album_asset, albums,
assetProfileLinks, avatarCacheReferences, cacheReferences, comment,
conflicts, coreInfo, coreMD5, errors, flags, importSource,
missingBinariesOnOz, profileRegistration, quota_exceeded,
renditionRevisions, space, space_album LIMIT 1;**
*
On iOS, MacOS and Linux this query will busy hang and never return.
Happens with the command line tool and if used as a prepared statement
in our iOS app. Changing certain aspects of the query will resolve the
problem: leaving the table "spacefavorite" out of the query, or
replacing count(*) with a just an asterisk.
I tried the following versions:
3.14.0, 3.16.2 (MacOSX Sierra), 3.13.0, 3.17.0 (Linux Fedora 24), 3.14.0
(iOS 10), always the same behavior.
Many thanks for your consideration and especially for your great tool.
Heiner
--
Jens-Heiner Rechtien <jrech...@adobe.com <mailto:aw...@adobe.com>>
Computer Scientist
Adobe Systems Engineering GmbH
Große Elbstraße 27
22767 Hamburg
Registergericht: Hamburg HRB 745 37
Geschäftsführer: Michael D. Jamrosy, Christian Keim, Thomas Mührke,
Keith San Felipe
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
