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
