> 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
On
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);
sql
2 matches
Mail list logo