What do you want to change?
Add FTS5 support to sqlite engine.
schema.sql
CREATE TABLE recipes (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
);
CREATE VIRTUAL TABLE recipes_fts USING FTS5 (
name,
content='recipes',
content_rowid='id'
);
-- (triggers omitted)query.sql
-- name: SearchRecipes :many
SELECT rowid, * FROM recipes_fts
WHERE recipes_fts MATCH ?;
Running sqlc generate on the above input results in the following error:
db/sqlite/query.sql:17:1: relation "recipes_fts" does not exist
What database engines need to be changed?
sqlite
What programming language backends need to be changed?
Go
What do you want to change?
Add FTS5 support to sqlite engine.
schema.sql
query.sql
Running
sqlc generateon the above input results in the following error:What database engines need to be changed?
sqlite
What programming language backends need to be changed?
Go