On Thu, Jun 21, 2012 at 11:02 AM, Dennis Volodomanov <i...@psunrise.com> wrote: > On 22/06/2012 12:57 AM, Pavel Ivanov wrote: >> >> OK. And now when you execute the original statements (SELECT COUNT(...) >> and SELECT ... WHERE ColC = 0) in SQLiteStudio and sqlite3 shell you still >> get the same results? 1 in the first statement and no rows in the second >> one? Pavel > > > No, I get correct results in sqlite3 shell now (haven't tried the SS). > > What I also failed to mention and which may have something to do with it, is > that there's another SELECT COUNT() being executed from a different thread, > which kicks in from time to time. Could that potentially cause any issues? > So, I have one thread doing SELECT COUNT() and SELECT ... and another thread > doing just a SELECT COUNT().
Do you have mutex surrounding statement execution in these threads? You should use it or compile with SQLITE_THREADSAFE=1. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users