mardi 24 mars 2015

Does SQLite have a parameter where I could set the default sort order back to ROWID?

I am having problems in my app because SQLite has changed the behavior of the default sort order.


Until SQLite 3.7.5 (at least) when a query does not have an "ORDER BY" clause, the results were sorted by rowid. Now with SQLite 3.8.6 they come ordered by the primary key.


SQLite 3.7.5:



select rowid, id, name from users;

rowid id name
--------------------
1 10 John
2 15 Peter
3 11 Mary
4 14 Sam


SQLite 3.8.6:



select rowid, id, name from users;

rowid id name
-------------------
1 10 John
3 11 Mary
4 14 Sam
2 15 Peter


I have uncountable queries to change (+1000), where I have just to add "ORDER BY ROWID".


Does SQLite have a parameter where I could set the default sort order back to ROWID?


Aucun commentaire:

Enregistrer un commentaire