On 8/25/15, Simon Slavin <slavins at bigfraud.org> wrote: > > "If there is no AS clause then the name of the column is unspecified and may > change from one release of SQLite to the next." >
Heed this warning!!! And yet, there are countless tens of thousands of applications in circulation that have ignored this warning and depend on the (unsupported) behavior of whatever version of SQLite they were originally developed on. So the reality is that we are extremely careful not to change the result column naming algorithms, for fear of breaking billions of cellphone apps. -- D. Richard Hipp drh at sqlite.org
