Bogdan Ureche wrote: > Allan, > > Thank you very much for the reply. You are correct when stating that, > according to SQLite documentation this SQL syntax is not expected to work. > Therefore, it is not a bug. Perhaps it should be added to the list of SQL92 > features unsupported by SQLite.
IMHO it's a bug (or oversight): C:\Users\John\Documents>sqlite3 test.db3 SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table foo (id integer, value varchar); sqlite> .q C:\Users\John\Documents>sqlite3 SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> attach database "test.db3" as myfoo; sqlite> insert into myfoo.foo values (1, "hello"); sqlite> select r.* from myfoo.foo r; 1|hello sqlite> select myfoo.foo.* from myfoo.foo r; Error: near "*": syntax error sqlite> I cannot think of a good reason why: select myfoo.foo.* from myfoo.foo; would be expected to produce different results than: select r.* from myfoo.foo r; If the former is invalid, then the latter should be also and vis versa. My own opinion, but there it is. FWIW, John Elrick <cid:[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
