On Fri, Nov 27, 2015 at 8:29 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > And just as you write, all the above behaviours can change in different > versions of SQLite so even if you do detailed detective work using the > current version it might all be obsolete next week. > > Simon. >
Exactly. One of the biggest advantages of not formally documenting what will be selected (even if it at some point in time this was "deterministic") is that the implementation can be more flexibly manipulated (the developers didn't sign any contract). A **warning** about this seems (to me) excessive. In the end of the day, you shouldn't be relying on these arbitrary results anyway, databases are dynamic (most of the tables are, at least) and you should be prepared to handle a different query result from time to time. -- Bernardo Sulzbach
