> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Friday, October 24, 2014 4:45 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] quasi-bug related to locking,and
> attached databases....
...
>
> Not gonna ask for this since you've now given enough info for
> someone to reproduce and test the issue. They might come
> back asking for further information but I'll leave that up to
> the experts.
>
> Simon.
Alas, but I'm going to offer it, haha. OK, it happens on Linux, too:
login as: person
person@192.168.173.137's password:
Access denied
person@192.168.173.137's password:
Last login: Thu Oct 23 22:24:23 2014
[person@localhost ~]$ which sqlite3
/usr/bin/sqlite3
[person@localhost ~]$ sqlite3 db1.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> create table dest ( name text, value text );
sqlite> create table source ( name text, value text );
sqlite> insert into source ( name, value ) values ( 'allow', 'yes' );
sqlite> .exit
[person@localhost ~]$ sqlite3 db1.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> attach database 'db1.db' as aux;
sqlite> .databases
seq name file
--- ---------------
----------------------------------------------------------
0 main /home/person/db1.db
2 aux /home/person/db1.db
sqlite> insert or replace into main.dest ( name, value ) values
...> ('allow',(select value from aux.source where name = 'allow'));
SQL error: database is locked
sqlite>
Looking forward to hearing back from folks. Maybe I should have put this
thread on 'dev', too, so I am dong so now. (Dev q.v. thread on users for
context -- it's short)
-dave
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
