sqlite-html icon indicating copy to clipboard operation
sqlite-html copied to clipboard

usage with recent sqlite3 throws misuse of sqlite3_result_subtype()

Open baikal opened this issue 11 months ago • 0 comments

having used this clever extension previously, I run into the following problem using a recent sqlite-cli:

sqlite> select html('<p><a href="https://google.com">Google');
Runtime error: misuse of sqlite3_result_subtype() by html()

According to https://sqlite.org/c3ref/result_subtype.html, the SQLITE_RESULT_SUBTYPE flag should be used when registering a function that uses this. Which might be hidden somewhere in the api.CreateFunction call ...

Temporary workaround is to compile sqlite-cli disabling SQLITE_STRICT_SUBTYPE which is set be default since 2023-12-16 respectively since version 3.45.0

baikal avatar Jan 31 '25 10:01 baikal