Hello, I wanted to report the BUG again with a clear description and reproduction but on trying to reproduce it with the last version 3.6.22 I've realized that it is fixed! (great!)
I send you anyway the minimal way I found to reprode it, maybe can be included in some test Best regards, Alejandro ----------------FIXED IN 3.6.22 BUG: Wrong "column not present in both tables" error message in some ways of expressing tables between parenthesis REPRODUCIBLE: Always Refer the table to reproduce it sqlite sqlite 3.3.4 3.6.21 Query ------ ------- -------------------- ok ok CREATE TABLE t1 (x); ok ok CREATE TABLE t2 (y); ok ok CREATE TABLE t3 (x, y, z); ok *FAILS! * SELECT * FROM (t1, t2), t3 USING(x,y); ok *FAILS! * SELECT * FROM (t1, t2), t3 USING(x); ok ok ! SELECT * FROM (t1, t2), t3 USING(y); ok ok ! SELECT * FROM (SELECT * FROM t1, t2), t3 USING(x,y); specifically using sqlite3 command line under windows SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t1 (x); sqlite> CREATE TABLE t2 (y); sqlite> CREATE TABLE t3 (x, y, z); sqlite> SELECT * FROM (t1, t2), t3 USING(x,y); *Error: cannot join using column x - column not present in both tables* sqlite> SELECT * FROM (t1, t2), t3 USING(x); *Error: cannot join using column x - column not present in both tables* sqlite> SELECT * FROM (t1, t2), t3 USING(y); sqlite> SELECT * FROM (SELECT * FROM t1, t2), t3 USING(x,y); sqlite> ------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
