On 14 Dec 2018, at 10:15am, Luuk <luu...@gmail.com> wrote: > why do i get 'no collation sequence' with this statement: > > sqlite> select Folder_Path from Folder; > Error: no such collation sequence: NoCaseUnicode
There's a UNIQUE index for Folder_Path COLLATE NoCaseUnicode. Iterating through that index would involve processing less data than reading the entire table. So SQLite decides that using that index to complete your SELECT command is a good strategy. But that collation is not included in the default compilation of SQLite so SQLite realises it can't use that index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
