On 6/23/2014 11:16 PM, Jerry Krinock wrote:
How can it be that adding a WHERE clause to a successful query causes ‘database disk image is malformed’?
One possibility: the query with WHERE clause attempts to use some index, while the query without doesn't. The data corruption happens to affect the area of the file where this index is stored.
Try this query: SELECT * FROM itemTable WHERE +key = 'profileName' ; Note the + sign - this suppresses the use of index. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
