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 Pechnik
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
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
Am 09.12.2009 um 13:42 schrieb Alexey Pechnikov:
> 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
4 matches
Mail list logo