On 13 Jul 2014, at 9:45pm, Clemens Ladisch <clem...@ladisch.de> wrote:
> But these particular column names do not look as if they were anything > but as bug: > > sqlite> select "TestView"."id", "TestView"."data2" from TestView; > TestView TestView > ---------- ---------- > 1 Miranda I understand your problem with two identical names, but it's not a bug in SQLite. SQLite does not make any promise about column names unless you use AS. This includes having two columns with identical names. It's also not 'wrong' with regard to the SQL specification. SQL does not define any commands which retrieve the column names of a table, or the column names of the result of a SELECT, so it doesn't define anything about the names produced. Also, a note about delimited identifiers. SQLite supports them correctly. Almost nobody does these days, preferring to use only letters, digits and the underline character in identifiers. It's worth noting, however, that implementation of delimited identifiers differs in different implementations of SQL. For example, for the command CREATE TABLE "TestTable" ... some implementations of SQL consider the table name to be TestTable and will recognise future references to it without the quotes, and others consider the table name to be "TestTable" and recognise it only with the quotes. Again, since SQL does not define any way to retrieve identifier names, neither behaviour can be considered buggy. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
