Are you multi-threaded?
It sounds like the database is being changed during your run...how is that being done? Inside your program? Are any deletes being done? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: [email protected] [[email protected]] on behalf of Dennis Volodomanov [[email protected]] Sent: Thursday, June 21, 2012 8:44 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] EXT : An interesting (strange) issue with selects Michael, Thanks for the reply. I know, it's usually the user :) On 21/06/2012 11:31 PM, Black, Michael (IS) wrote: > > You don't show where you inserted your data. > > Are you postiive ColC is an integer and you didn't insert it as a string? > > You don't show a dump of your table which would be handy. > > What does "bomb" mean? Your program gets a seg fault or such? > > What are you programming in, on what OS? > > I can tell you now if there isn't a simple answer you need to make a > complete example so somebody else can reproduce the problem and see > what you're doing wrong (in all likelihood it's probably you). > > I'm using SQLite in C++ code (Windows, MSVC2008, amalgamation). The data is inserted using sqlite3_bind_int64()/sqlite3_bind_int(). What I mean by "bomb out" is that it executes this pair of statements tens of thousands of times (count, then get one row) and works (e.g. "count" returns more than one and "select" returns one row) and then, once in a while, count returns more than one, but select doesn't get anything. Dennis _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
