On 2015-08-25 08:37 PM, Richard Hipp wrote: > 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.
I vote to change it every release... Stimulate better habits!

