Philip Van Hoof <s...@pvanhoof.be> wrote: > When we use our custom SQLite function function_sparql_regex (lower in > this E-mail) together with bound values for the argvs of the function, > then sqlite3_reset nor sqlite3_clear_bindings are clearning the > auxdata. > > This makes it impossible to pass the regex as a sqlite3_bind_text (the > same regex would be used even if you'd pass a new regex string).
You are supposed to handle cache invalidation yourself in the function. Store the original regex string together with its compiled form, compare the incoming regex with the cached one to see whether you can reuse the cached value or need to recompile. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
