Re: [sqlite] Column headers include subselect alias if column is from a subselect

> I would expect a column header of a for all of these queries, and all> other > databases I've tested with use a column header of a.  Is this a> bug in > SQLite? Column name in the result set is undefined unless you define alias in the query. So SQLite can name it whatever it wants. Pavel

[sqlite] Column headers include subselect alias if column is from a subselect

I'm not sure if this is expected/desired behavior, but I think it is incorrect: $ sqlite3 SQLite version 3.7.8 2011-09-19 14:49:19 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .headers ON sqlite> CREATE TABLE b (a integer); sqlite> INSERT INTO b VALUES (1);