Re: [sqlite] sqliteDefaultBusyCallback and HAVE_USLEEP

> On Feb 26, 2020, at 5:53 AM, Graham Holden wrote: > > Wednesday, February 26, 2020, 11:15:14 AM, Richard Hipp > wrote: > >>> On 2/25/20, Peter Kolbus wrote: >>> I noticed that sqliteDefaultBusyCallback() seems to depend directly on the >>> OS

[sqlite] sqliteDefaultBusyCallback and HAVE_USLEEP

I noticed that sqliteDefaultBusyCallback() seems to depend directly on the OS (behave differently based on SQLITE_OS_WIN||HAVE_USLEEP). Since the underlying primitive, sqlite3OsSleep(), actually uses the VFS to sleep, and unixSleep() also has a roundup to whole seconds when HAVE_USLEEP is not

[sqlite] List of innocuous functions?

Is there any documentation showing, or an easy way to generate, the exact list of SQLite-provided functions that are innocuous? I’d like to turn on the new SQLITE_TRUSTED_SCHEMA but support a variety of applications and am hoping for something to guide analysis. Thanks -Peter

Re: [sqlite] INSERT OR IGNORE with rtree virtual tables

Any thoughts on this? Thanks, Peter Kolbus On Sat, Oct 30, 2010 at 8:27 PM, Peter Kolbus <peter.kol...@gmail.com> wrote: > Hi, > > It seems that the OR IGNORE clause is not working with an RTREE > virtual table.  The documentation (http://sqlite.org/rtree.html, >

[sqlite] INSERT OR IGNORE with rtree virtual tables

_y ) VALUES( 2, 3, 4, 5, 6 ); sqlite> INSERT OR IGNORE INTO a_rt ( _id, min_x, max_x, min_y, max_y ) VALUES( 2, 3, 4, 5, 6 ); Error: constraint failed sqlite> Is this a bug, or operating as designed? Thanks, Peter Kolbus ___ sqlite-users mailing l

Re: [sqlite] SQLite 3.7.0 coming soon....

This looks like an exciting enhancement, and I look forward to testing it out. http://www.sqlite.org/draft/c3ref/io_methods.html seems to be missing requirements for the xShm functions, though. Can you update that? Thanks, Peter Kolbus On Jun 30, 2010, at 12:21 PM, "D. Richard Hip

Re: [sqlite] Problem with sqlite3

Lukasz, I think the function you're trying to call is named sqlite3_open. Regards, Peter Kolbus On Wed, Jun 2, 2010 at 10:56 AM, lukasz aaa <zsu...@wp.pl> wrote: > Hello. Sorry for my English. > I have a problem with the SQLite library reloaded correctly (use in > project). I'm

[sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

access violation: if( rc==SQLITE_OK && pLeaf ) { Is this the correct fix? Thanks, Peter Kolbus ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users