Thanks for the bug report. Ticket: http://www.sqlite.org/src/info/c34d0557f740c45070 Fixed here: http://www.sqlite.org/src/info/5d01426ddf
On Wed, Feb 12, 2014 at 5:31 AM, Paweł Salawa <pawelsal...@gmail.com> wrote: > Hi, > > The bug affects 3.8.2 and 3.8.3.1, I haven't tested other versions. > > *Preconditions:* > > - 2 databases: A and B. > > - database A has table "test": > CREATE TABLE test (id integer PRIMARY KEY, val text) WITHOUT ROWID > > - database B has table "test2": > CREATE TABLE test2 (EID INTEGER, node1 INTEGER, node2 INTEGER) > > > *To reproduce bug:* > > - open database A and attach database B: > ATTACH 'database_b.db' AS 'attached'; > > - execute query: > select test.*, t2.ROWID from attached.test2 t2, test > > SQLite says: *no such column: t2.ROWID* > > Weird thing is that when you switch test2 and test table positions with > each other, the same query will work: > select test.*, t2.ROWID from test, attached.test2 t2 > > *^^^ this works just fine.* > > Problem occurres only if following conditions are met: > - table in local database is WITHOUT ROWID > - table in attached database is a regular table with ROWID > - query selects ROWID from the regular table > - both tables must be mentioned in the FROM clause > - the WITHOUT ROWID table must be mentioned as the second one > > Regards, > -- > Paweł Salawa > pawelsal...@gmail.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users