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: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Dennis Volodomanov [i...@psunrise.com]
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
