> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org 
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> On 24 Oct 2014, at 9:54pm, dave <d...@ziggurat29.com> wrote:
> >  Can locking be made more clever to know about aux being an alias
> > for main, and effectively translate the query shown to it's 
> functional
> > equivalent of:
> >    insert or replace into main.dest ( name, value ) values 
> ('allow',(select
> > value from main.source where name = 'allow'));
> > which does work (or both to 'aux' as well)?
> To help us consider this, please give us the following information:
> Which version of SQLite are you using ?
> What operating system are you using (including which version) ?
> What formats are the volumes those files are stored on ?
> Simon.

I've duplicated the problem in 3.8.6 and 3.8.7.
I have duplicated the problem on Windows; XP, 7, and 8.1
The file systems are all NTFS.

Later I can try on linux, but I don't have it at my fingertips just now.  I
don't mind trying with other versions of sqlite if you think it's helpful,
but I suspect it's been there forever.  Also, I can read code and step in
the debugger (which I did to find the locking issue, and how it arose, up to
this point).

Let me know!


sqlite-users mailing list

Reply via email to