First of all thanks for reply ! I can understand your point, what confuses me is that when we query a view with "a.*" it doesn't qualify the names so I thought that was a mistake when we use individual names otherwise I would expected qualified names there too.
Cheers ! > Tue Aug 25 2015 19:45:27 CEST from "Simon Slavin" <slavins at bigfraud.org> >Subject: Re: [sqlite] Why sqlite show qualified column names when selecting >from views ? > > On 25 Aug 2015, at 6:13pm, sqlite-mail <sqlite-mail at dev.dadbiz.es> wrote: > > >>When querying views sqlite shows qualified column names if they are >>specified >> individually. >> > Sorry but this has been mentioned a few times here and won't be changed. >The SQL standard doesn't mention column names so SQL engines are free to do >what they want. > > In SQLite you can depend on column names only if you have specified them >using 'AS'. So I would expect, but haven't tested right now ... > > >>SQL: SELECT a.* FROM tbl_view AS a; >> Column 0: id >> Column 1: name >> SQL: SELECT a.id, a.name FROM tbl_view AS a; >> Column 0: a.id <<<<<<<<<<<<<<<<<<<<< only with individual fields >> Column 1: a.name <<<<<<<<<<<<<<<<<<< >> >> > SQL: SELECT a.id AS id, a.name AS name FROM tbl_view AS a; > Column 0: id > Column 1: name > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
