[sqlite] The LIKE optimization breaks user defined like functions

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

[sqlite] The LIKE optimization breaks user defined like functions

Hello ! Today I decided to see why my applications stop using index when using my user defined "like" function and it seems that during the creation of the "LIKE" optimization sqlite3 made some special settings to the builtin "like" function but didn't exposed it to third party developers. I