On 16 Sep 2012, at 2:16am, Roger Binns <rog...@rogerbinns.com> wrote:
> It would be *really* helpful if there was some way to put SQLite into a > mode by which developers using it can test and improve their own apps. If > their app worked in that lint/test mode they would know that the chances > of changes like this one breaking their app would be tiny. > > For the ordering case, and implicit "ORDER BY random()" could be added to > every query that doesn't specify an order. There is already "PRAGMA reverse_unordered_selects;": <http://www.sqlite.org/pragma.html#pragma_reverse_unordered_selects> perhaps one could add a "PRAGMA reverse_unordered_selects=RANDOM". But it might be interesting to replace it with PRAGMA lint_mode=ON or PRAGMA do_everything_weirdly=ON for SQLite4 which did all sorts of things in a whacky but still compliant manner. It might help in the testing suite too. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
