I am have successfully implemented an FTS5 virtual table. However, I am facing an issue with the fts

I am have successfully implemented an FTS5 virtual table.
However, I am facing an issue with the fts5vocab module, which is resulting in an authorization error. I would appreciate your assistance in resolving this matter. Below are the details of the queries I have executed:

1.Successful Query:
Command:

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5 USING fts5( title, text, tokenize='trigram');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5 USING fts5( title, text, tokenize='trigram');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5 USING fts5( title, text, tokenize='trigram');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5 USING fts5( title, text, tokenize='trigram');"

2.Query Resulting in Error:
Command:

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5vocab USING fts5vocab('trigram_fts5', 'row');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5vocab USING fts5vocab('trigram_fts5', 'row');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5vocab USING fts5vocab('trigram_fts5', 'row');"

npx wrangler d1 execute staging-db-web --local --command="CREATE VIRTUAL TABLE trigram_fts5vocab USING fts5vocab('trigram_fts5', 'row');"

Error Message:

[ERROR] not authorized

[ERROR] not authorized

[ERROR] not authorized

[ERROR] not authorized

I am aware that FTS5 is supported in Cloudflare D1. However, I am uncertain about the support for the fts5vocab module.
Could you please confirm if this module is supported, or if it is yet to be implemented? Any guidance or suggestions to address this issue would be greatly appreciated.

I am have successfully implemented an FTS5 virtual table. However, I am facing an issue with the fts

Similar Threads