On 8 Jul 2017, at 8:36pm, petern <peter.nichvolo...@gmail.com> wrote:
> Why does the choice of data value quotation mark influence the output > column name of the inline VALUES clause? I admire your set of examples, which show the behaviour well. Column names in SQLite are not dependable unless you have set them using an "AS" clause. Not only can they vary with the type of value, as you have demonstrated, but they have changed with different versions of SQLite and may change again. There are also PRAGMAs which change column names, though they are deprecated. If your code needs to depend on column names for anything other than a simple SELECT of TABLE columns, set them explicitly using "AS" for each column. > sqlite> SELECT * FROM (VALUES ("1",2),(3,4)); This is not a recommended syntax for use with SQLite. Strings should be enclosed in single quotes (apostrophes) as you did in another example. Double quotes are expected to refer to entity names, though they are rarely needed even for that. Although SQLite does not complain when you use double quotes for values in the above way, its interpretation can be inconsistent and unhelpful. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users