sqlite-html
sqlite-html copied to clipboard
usage with recent sqlite3 throws misuse of sqlite3_result_subtype()
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