Re: svn commit: r1408325 - /subversion/branches/wc-collate-path/subversion/libsvn_subr/sqlite.c

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