On Mon, 31 Jul 2017, Peter Da Silva wrote:

Any application that depends on column names should be using “AS” anyway, might as well break them sooner.

Any unintended change in behavior should be considered to be a bug.

There are a great many existing queries which do not use AS statements for each and every column returned.

For our own applications we are often doing a wildcard select and using a feature of Python APSW to learn the available column names so we know the columns which were available. If the column names are sometimes not the same as the table definition then there will be severe problems.

Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to