> -----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.
Sure; 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! -dave _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users