cannot recognize virtual table when attach another database

[includewins0ck2]

Details

When two databases are attached, if one of them has a VIRTUAL table, then it will report an error that the virtual table cannot be recognized.

for example,I have two database
test1:CREATE TABLE t1 (
phone TEXT
);
CREATE VIRTUAL TABLE v USING fts5(src TEXT);
test2:
REATE TABLE t2 (
name TEXT
);
Now,When I attach test1 in test2,If I query select t2.* from t2,test1.t1; then returns normal,But if I query select t2.* from t2,test1.v, it will report an error, can't recognize the table : test1.v, while in the sqlite3.exe command line tool inside, is able to run normally

[pawelsalawa]

Yeah. The problem here is that the "Smart Execution" (which handles transparent database attaching) fails, because virtual table support there is incomplete.

As a fallback, the "Simple Execution" method is used, but it does not attach referenced databases automatically. It will be fixed ither in 3.4.x line or if it turns out to be more complicated, then in 3.5.0.

A workaround for now is to do it the same way as you do in the sqlite3.exe - i.e. attach the database explicitly with ATTACH statement. Then the "Simple" method will be able to see attached database.