[sqlite] bug in proxyGetHostID()

2010-01-16 Thread Thomas Stüfe
Greetings, I think I found a small bug in sqlite 3.6.22 in the function proxyGetHostID(). There, pread() and pwrite() are used to read a host id file. Return value of these functions is assigned to a size_t variable. size_t is unsigned. Should pread fail for any reason (IO Error or whatever) a

Re: [sqlite] sqlite3_step()

2010-01-16 Thread Max Vlasov
Mike, as the docs on the page http://www.sqlite.org/c3ref/stmt.html says: 1. sqlite3_prepare_v2() 2. sqlite3_bind_*() 3. sqlite3_step() one or more times 4. sqlite3_reset() 5. goto 2 or sqlite3_finalize(). As you may know sqlite3_prepare_* compiles your SQL query into a VDBE micro-program with in

Re: [sqlite] sqlite3_step()

2010-01-16 Thread Simon Davies
2010/1/16 Mike Johnston : > Using sqlite 3.6.22.  Here's my sql > SELECT sno, lname, fname FROM addressbook where sno>? > Suppose your stepping through a 100 row result set.  I'm calling > sqlite3_step(), getting my values all good.  If I were to call > sqlite3_bind_int() function with a new valu

[sqlite] sqlite3_step()

2010-01-16 Thread Mike Johnston
Using sqlite 3.6.22.  Here's my sql SELECT sno, lname, fname FROM addressbook where sno>? Suppose your stepping through a 100 row result set.  I'm calling sqlite3_step(), getting my values all good.  If I were to call sqlite3_bind_int() function with a new value for my where clause at row 50, do