Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

On Sat, Jul 13, 2013 at 11:14:51AM +0200, Du?an Paulovi? scratched on the wall: > Hello, > we are currently facing problem with Access violation exception caused by > function sqlite3_open_v2 trying to load extensions from unloaded DLLs. > Also it would be fine to be able to load static extension

Re: [sqlite] Another 2 questions about SQLite

On Sat, 13 Jul 2013 00:09:36 -0600 "Keith Medcalf" wrote: > UPDATE WHERE CURRENT OF CURSOR has been part of SQL since about, oh, > 1969. (I assume that's dramatic license.) > Now then SQLite does not support the FOR UPDATE OF clause when > defining a cursor (ie, doing a prepare) which is int

Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

On 13 Jul 2013, at 3:33pm, Jay A. Kreibich wrote: > That would not actually solve the problem. No matter if SQLite is in > a DLL or linked statically in the app, if there is sone master copy > of SQLite you're going to have the same issues as application plugins > are loaded and unloaded.

Re: [sqlite] Possible duplicate grammar rule for expression (in documentation)

On Sat, Jul 13, 2013 at 2:39 PM, Filipe Oliveira wrote: > Hello, > > The grammar rules for an expression (http://www.sqlite.org/lang_** > expr.html ) indicate that a binary > expression can have the operators IS and IS NOT, but there is also one rule > above t

Re: [sqlite] Another 2 questions about SQLite

> Richard Hipp said on Saturday, 13 July, 2013 11:59: > > I don't know. It works entirely as expected. If I move a row (via > > update) that I have already visited into a position where it is "yet > > to be visited", then I will visit it twice -- both times exactly when > > and where expected.

[sqlite] Possible duplicate grammar rule for expression (in documentation)

Hello, The grammar rules for an expression (http://www.sqlite.org/lang_expr.html) indicate that a binary expression can have the operators IS and IS NOT, but there is also one rule above the BETWEEN expression that indicates the same. I was trying to understand if these two rules have differen

Re: [sqlite] Another 2 questions about SQLite

On Sat, Jul 13, 2013 at 1:53 PM, Keith Medcalf wrote: > > I don't know. It works entirely as expected. If I move a row (via > update) that I have already visited into a position where it is "yet to be > visited", then I will visit it twice -- both times exactly when and where > expected. > Ple

Re: [sqlite] Another 2 questions about SQLite

I don't know. It works entirely as expected. If I move a row (via update) that I have already visited into a position where it is "yet to be visited", then I will visit it twice -- both times exactly when and where expected. If there is a row I have not visited yet and I delete it before I r

Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

On Sat, Jul 13, 2013 at 11:14 AM, Dušan Paulovič wrote: > because that would uninstall also all entry points of another plugins. > So it happens, that SQlite holds entry point(s) to DLL which is unloaded. > - Now, if user executes any command from remaining DLL, it invokes > sqlite3_open_v2,

Re: [sqlite] Understanding how data is stored and the index is managed

Hi Mike, Thanks for the steps to try. I was hoping for some theoretical (implementation) insight before we do the normal battery of tests... we'll get onto that next week if there are no other inputs on how data storage is handled. On 12/7/2013 8:36 PM, Michael Black wrote: One more test

Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

On Sat, Jul 13, 2013 at 01:28:28PM +0100, Simon Slavin scratched on the wall: > > On 13 Jul 2013, at 10:14am, Dušan Paulovič wrote: > > > - These plugins can be loaded and uloaded by user. > > - Main application itself does not use SQLite, so each plugin using SQLite > > must be linked to it. >

Re: [sqlite] Another 2 questions about SQLite

On 7/13/2013 1:36 AM, Keith Medcalf wrote: Of course, the behaviour is not actually "undefined" -- it is perfectly determinable and entirely predictable and reasonable. However, if one does not understand the factors which determine the behaviour then, for you, the behaviour is undefined. In

Re: [sqlite] sqlite3_auto_extension - unloaded DLL issue

On 13 Jul 2013, at 10:14am, Dušan Paulovič wrote: > - These plugins can be loaded and uloaded by user. > - Main application itself does not use SQLite, so each plugin using SQLite > must be linked to it. This is a defect in the way plugins are implemented. The easiest cure would be to have Ben

[sqlite] sqlite3_auto_extension - unloaded DLL issue

Hello, we are currently facing problem with Access violation exception caused by function sqlite3_open_v2 trying to load extensions from unloaded DLLs. How it happens: - There are 2 (or more) plugin DLLs in main application which are linked to SQLite. - These plugins can be loaded and uloaded by u