Re: [sqlite] Inconsistent behavior - perhaps a bug?

[Pavel Ivanov]

According to http://www.sqlite.org/lang_select.html and
http://www.sqlite.org/lang_expr.html one can use in select statement
as a result column one of the following:
- *
- table_name.* (I assume that instead of table_name one can use table alias too)
- any expression

Expression can consist of the single column in the form
[[database_name.]table_name.]column_name

So nobody says that database_name.table_name.* should work and
behavior is as intended and documented. Though from the point of view
of outside user it seems logical for this to work of course.


Pavel

On Fri, Sep 25, 2009 at 2:01 PM, Schrum, Allan
 wrote:
> $ bin/sqlite3
> SQLite version 3.6.17
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> create table t(a integer);
> sqlite> select main.t.* from t;
> SQL error: near "*": syntax error
> sqlite> select main.t.* from main.t;
> SQL error: near "*": syntax error
> sqlite> select t.* from t;
> sqlite> select t.* from main.t;
> sqlite> select main.t.* from main.t;
> SQL error: near "*": syntax error
> sqlite> select main.t.a from main.t;
> sqlite> select main.t.a from t;
> sqlite> .quit
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Inconsistent behavior - perhaps a bug?

[Schrum, Allan]

$ bin/sqlite3
SQLite version 3.6.17
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t(a integer);
sqlite> select main.t.* from t;
SQL error: near "*": syntax error
sqlite> select main.t.* from main.t;
SQL error: near "*": syntax error
sqlite> select t.* from t;
sqlite> select t.* from main.t;
sqlite> select main.t.* from main.t;
SQL error: near "*": syntax error
sqlite> select main.t.a from main.t;
sqlite> select main.t.a from t;
sqlite> .quit

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users