On 22 Dec 2017, at 09:57, Hick Gunter <[email protected]> wrote: > The problem lies in your reliance on unspecified behaviour. Unspecified > behaviour is allowed to change. > > I am sure you have read (and ignored) the following guarantee taken from > http://sqlite.org/c3ref/column_name.html :
My questions are these: 1) That the name without AS is documented as being unspecified, is that the case with all/most SQL systems or is it SQLite specific? 2) I don't see this issue mentioned when I read the PHP documentation about their SQLite interface, nor do I see it in the Xojo docs about *their* interface either. I assume their interfaces are not rewriting SELECT statements to include AS for every column selected, so should they be warning their users about it? -- Cheers -- Tim _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
