On 14 Dec 2018, at 10:41am, Luuk <luu...@gmail.com> wrote: > When SQLite realises it can't use that index, should it revert to a full > table scan?
That's the bigger question. My theory is that SQLite doesn't want to touch that database unless it has all the collations it will need. So it errors out the first time it notes the lack. After all, you might make a few changes to the database on tables that don't use that collation, then be trying to change another table in sync with your first changes, and only then realise you shouldn't have changed anything. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
