Domingo Alvarez Duarte wrote: > Today I decided to see why my applications stop using index when using > my user defined "like" function
The optimization replaces the LIKE with two comparisons. Installing a user-defined function implies that your new LIKE works differently, so this optimization might no longer work. > I was looking at the documentation and didn't saw any warning/mention > to this change affecting user defined "like" functions <http://www.sqlite.org/optoverview.html#like_opt> says: | 4. The built-in functions used to implement LIKE and GLOB must not have | been overloaded Regards, Clemens
