Re: [sqlite] EXT : An interesting (strange) issue with selects

2012-06-21 Thread Simon Slavin
On 21 Jun 2012, at 2:55pm, Dennis Volodomanov wrote: > On 21/06/2012 11:47 PM, Simon Slavin wrote: >> Are you examining the result code returned by the SELECT commands ? I bet >> in the cases where the select gets zero rows, it isn't returning SQLITE_OK >> but it's instead returning some sort

Re: [sqlite] EXT : An interesting (strange) issue with selects

2012-06-21 Thread Dennis Volodomanov
On 21/06/2012 11:47 PM, Simon Slavin wrote: Are you examining the result code returned by the SELECT commands ? I bet in the cases where the select gets zero rows, it isn't returning SQLITE_OK but it's instead returning some sort of error code. Simon. Hi Simon, Yes, I do examine those and

Re: [sqlite] EXT : An interesting (strange) issue with selects

2012-06-21 Thread Simon Slavin
On 21 Jun 2012, at 2:44pm, Dennis Volodomanov wrote: > 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 > (co

Re: [sqlite] EXT : An interesting (strange) issue with selects

2012-06-21 Thread Dennis Volodomanov
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.

Re: [sqlite] EXT : An interesting (strange) issue with selects

2012-06-21 Thread Black, Michael (IS)
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