I am having problems in my app because SQLite somehow 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, 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?

Related posts

Recent Viewed