Steps to reproduce. 1. Create two tables in two databases:
DocketLiga.db3 CREATE TABLE [MAIN] ( [NUM_DEC] integer PRIMARY KEY UNIQUE, [DATE_DEC] DATE, [ID_FORM_DEC] integer); DocketTXT.db3 CREATE VIRTUAL TABLE TXT_1 using fts3(UA); 2. Fill tables by some correct values. 3. Open first database DocketLiga.db3 4. Attach second database. attach 'DocketTXT.db3' as tx 5. Try to execute statement select m.num_dec from tx.txt_1 t inner join main m on t.docid = m.num_dec where t.ua match 'word*' and m.num_dec in (1214, 1283, 1451); On SQLite 3.6.17 all works fine. On 3.6.18 and later message 'SQL error or missing database' appear -- With best regards, Serge. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
