On 3/22/18, Deon Brewis <[email protected]> wrote: > > In general, is there anything dangerous that you can do in a custom function > inside an indexed expression that we need to watch out for?
Yes: the UDF must give the same answer from the same inputs every single time. If it does not (if the function is not "pure") then the index can go corrupt. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
