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