On 12.11.2012 17:17, Bert Huijben wrote: > + SQLITE_ERR(sqlite3_create_function((*db)->db3, "glob", 2, SQLITE_UTF8, > + *db, glob_ucs_nfd, NULL, NULL), > + *db); > + SQLITE_ERR(sqlite3_create_function((*db)->db3, "like", 2, SQLITE_UTF8, > + *db, like_ucs_nfd, NULL, NULL), > + *db); > + SQLITE_ERR(sqlite3_create_function((*db)->db3, "like", 3, SQLITE_UTF8, > + *db, like_ucs_nfd, NULL, NULL), > + *db); > How does this affect indexes? > > The usual like and glob code can use indexes in some cases? > > Do we still use LIKE and GLOB, or did we already replace all invocations for > performance reasons? > (I know I removed a lot of them to get queries to use indexes properly)
Please don't jump up and down on a half-finished implementation. :) -- Brane -- Branko Čibej Director of Subversion | WANdisco | www.wandisco.com
