But after I remove the assert(), I cannot reproduce your problem. I always
get four result rows, respectively: x2, x3, x4, and x5. I've tried this
with 3.7.15, 3.7.16, 3.7.16.2, 3.7.17, and the latest trunk. And I've
tried it using your original database and after dropping the SQLITE_STAT1
table. Do you have any further clues for me?
This is *really* strange.
I've created a dump of my test database, and just appended the SQL query
to the end of that dump (inspired by your debugging example).
When I now pipe that whole file into SQLite3, the query works. But when
I run the same query again on that (now existing) database, there are
*no* results any more. Maybe we have a timing problem with the journal here?
Here are two files, one containing the schema and one with the query:
http://download.liveconfig.com/tmp/test.schema
(SHA1: f0e6f024d5f0d4dbcbfef9bb1c92b12042fd8cd2)
http://download.liveconfig.com/tmp/test.sql
(SHA1: f56970e0343a7418ed2a89ab3ffa4e8c30986bae)
To reproduce:
cat test.schema test.sql | ./sqlite3 tmp.db
=> returns the expected 4 result rows (x2/x3/x4/x5)
cat test.sql | ./sqlite3 tmp.db
=> returns nothing
Tested right now with 3.7.17-trunk and 3.7.16.2
Meanwhile, one of our users sent us another bug report concerning an
"empty" query (another query, retuning no results even after executing
ANALYZE command). I'll check this too, and will try to simplify the
scheme by removing some columns.
Best regards
-Klaus
--
______________________________________________________________________
Keppler IT GmbH - Die Hostingexperten.
Dipl.-Inf. Klaus Keppler Tel. (09131) 691-480
Geschäftsführer Fax: (09131) 691-489
Am Weichselgarten 7 UStID.-Nr. DE259788698
91058 Erlangen Amtsgericht Fürth, HRB 11477
www.keppler-it.de Sitz d. Gesellschaft: Erlangen
______________________________________________________________________
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
