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.
