On 1/11/17, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Jan 2017, at 12:49am, Richard Hipp <d...@sqlite.org> wrote: > >> For years I have threatened to make it a feature of SQLite that it >> really does output the rows in some random order if you omit the ORDER >> BY clause > > SQLITE_CONFIG_RANDOMIZEWHATYOUCAN_LOL >
The "PRAGMA reverse_unordered_selects=ON" statement has long been available to do this. But it is an optional feature that has to be turned on. And I don't think anybody ever turns it on. My proposal is to make it random. Maybe it would be sufficient to initialize the reverse_unordered_selects setting to a random value (on or off) inside of sqlite3_open(). -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users