Hello All: Is this a bug or am I doing something wrong?
Note: neither test.db nor t2.db exist prior to this test. $ sqlite3 test.db SQLite version 3.19.2 2017-05-25 16:50:27 Enter ".help" for usage hints. sqlite> create table account (id integer primary key, idParent integer); sqlite> attach database 't2.db' as t2; sqlite> create table t2.link (idParent int, idChild int); sqlite> create index t2.idx on t2.link (idChild,idParent); Error: near ".": syntax error sqlite> create index idx on t2.link (idChild,idParent); Error: near ".": syntax error sqlite> create index idx on link (idChild,idParent); Error: no such table: main.link sqlite> Regards, Chris Peachment _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users