You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT *
FROM documents
WHERE id IN (
SELECT document_id as id FROM documents_fts
WHERE documents_fts MATCH ?
ORDER BY rank
)
LIMIT ?
OFFSET ?;
queries.sql:6:11: column "documents_fts" does not exist
I want MATCH on every columns of the virtual fts5 table. I can't find a way to do this.
Activity
[-]Add sqlite support for FTS5[/-][+]Add FTS5 support to sqlite[/+]lvignoli commentedon May 19, 2023
Hello!
Any plan to implement this feature? :)
feat(sqlite): virtual tables and fts5 supported
feat(sqlite): virtual tables and fts5 supported
feat(sqlite): virtual tables and fts5 supported (#2531)
lvignoli commentedon Jul 26, 2023
🎉🎉🎉
Thanks !
yanc0 commentedon Dec 5, 2023
@mcdoker18 @lvignoli I can't figure out how to use this.
I want MATCH on every columns of the virtual fts5 table. I can't find a way to do this.
mcdoker18 commentedon Jan 3, 2024
@yanc0 Hi, sorry for the late response. This was not implemented in my commit.
feat(sqlite): virtual tables and fts5 supported (sqlc-dev#2531)
core: model the hidden columns of sqlite fts5 tables (#4579)