So there is a way to have a callback that intercept pragmas ?  

Because if we make a piece of derived/composed software that can be used by
third party how to maintain our overloads/overwrites ?  

Cheers !  
>  Thu Apr 14 2016 01:21:08 PM CEST from "Richard Hipp" <drh at sqlite.org> 
>Subject: Re: [sqlite] Why pragma case_sensitive_like do not return
>theactualsetting ?
>
>  On 4/14/16, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote:
>  
>>Also I'm noticing that when the "pragma case_sensitive_like" is executed
>> there is two internal functions
>> "sqlite3RegisterLikeFunctions/setLikeOptFlag"
>> been called to swap the built-in LIKE and GLOB functions.
>> 
>> What this mean for user installed collates/functions overloading ?
>> 

>  From the docs: "This pragma uses sqlite3_create_function() to
> overload the LIKE and GLOB functions, which may override previous
> implementations of LIKE and GLOB registered by the application."
> 
> So if you register your own LIKE and GLOB functions and then invoke the
> "case_sensitive_like" pragma, your private LIKE and GLOB functions are
> replaced by one of the built-in LIKE or GLOB implementations.
> 
> 
> -- 
> D. Richard Hipp
> drh at sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
>
>  



?

Reply via email to