This was brought up before by me here: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2009-September/015484.html
The response was: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2009-September/015486.html Which said: 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. --- So perhaps this is a feature request? -Allan > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Bogdan Ureche > Sent: Tuesday, November 17, 2009 2:51 PM > To: [email protected] > Subject: Re: [sqlite] is ticket 4037 not a bug? > > > > > > > > > I can imagine query generators tend to use more, possibly > > redundant, qualifiers than a human programmer would. > > -- > > ( Kees Nuyt > > ) > > c[_] > > > > > That may be true but sometimes the qualifiers are needed to avoid > ambiguity, > in which case they are not redundant. > > Bogdan > > > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
