On Sun, 13 Jul 2014 22:45:27 +0200 Clemens Ladisch <clem...@ladisch.de> wrote:
> > There is no contract of which column names should be returned, no > > "incorrect" headers and no guarantee, and no obligation from the > > standard or any other requirement. > > 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 Seems to have been recently introduced. With SQLite version 3.7.13 2012-06-11 02:05:22 I get: $ sqlite3 < sql id data2 ---------- ---------- 1 Miranda TestView.id TestView.data2 ----------- -------------- 1 Miranda "TestView"."id" "TestView"."data2" --------------- ------------------ 1 Miranda [TestView].[id] [TestView].[data2] --------------- ------------------ 1 Miranda id data ---------- ---------- 1 Fred id data ---------- ---------- 1 Fred id data ---------- ---------- 1 Fred id data ---------- ---------- 1 Fred --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users