Hello! On Wednesday 09 December 2009 15:07:16 Pavel Ivanov wrote: > It's been said in this list not once already: unless you're using "as > ..." to name the column it's not guaranteed to have any particular > name you expect it to. So it's not a bug.
This is bug becouse the column with alias will be renamed. As example: sqlite> create table test (id INTEGER PRIMARY KEY, a text); sqlite> insert into test (a) values ('test'); sqlite> create view view_test as select rowid,a as id from test; sqlite> .header on sqlite> select * from view_test; id|id:1 1|test The result is wrong becouse fileld "id" must be equal to 'test'. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users