The new fts3tokenize virtual table calls the fts3_tokenizer() SQL function 
internally to retrieve the pointer to the tokenizer implementation for a FTS 
table:

http://www.sqlite.org/src/artifact/a29f126b9e6c6a6f1021a8f7440bf125e68af1f9?ln=74-100

However, this call is rejected if, for security reasons, the fts3_tokenizer() 
function is blocked by an authorizer callback:

"SECURITY WARNING: If the fts3/4 extension is used in an environment where 
potentially malicious users may execute arbitrary SQL, they should be prevented 
from invoking the fts3_tokenizer() function, possibly using the authorization 
callback." (http://www.sqlite.org/fts3.html#section_8_1).

So the problem is that with the authorizer block in place, the fts3tokneize 
virtual table does not work. One would have to compromise functionality for 
security.

Is there no other way to retrieve the tokenizer besides calling 
fts3_tokenizer()?

Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to