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.
Also: sqlite> create table test (id INTEGER PRIMARY KEY, a text); sqlite> insert into test (a) values (1); sqlite> .h on sqlite> select rowid, a from test; id|a 1|1 sqlite> select rowid as rowid, a from test; rowid|a 1|1 Pavel On Wed, Dec 9, 2009 at 6:47 AM, Alexey Pechnikov <[email protected]> wrote: > Hello! > > $ sqlite3 > SQLite version 3.6.20 > > sqlite> create table test (id INTEGER PRIMARY KEY, a text); > sqlite> insert into test (a) values (1); > sqlite> create view view_test as select rowid,* from test; > sqlite> .header on > sqlite> select * from view_test; > id|id:1|a > 1|1|1 > > > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > 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
