On 3/22/18, Deon Brewis <de...@outlook.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
