I assume D1 is already pre-compiled with FTS5 but when I tried to create a virtual table with the statement below, I could not:
CREATE VIRTUAL TABLE myTable USING FTS5(columnOne, columnTwo);
My question is: Does or will D1 support virtual table for FULL-TEXT search.
Although there’s no documentation about FTS on D1 docs but the D1 home page says it supports FTS. Also I tried the following in the D1 console input box and it worked:
CREATE VIRTUAL TABLE files_fts USING fts5(name, publisher);
Thanks for the response.
It looks like the FTS5 is case sensitive on D1. On Sqlite3 it is not.
When I tried with the lower case (fts5), it works on D1. With upper case is says not authorized.
Once again. Thanks.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.