Open mrpengxinwen opened 1 week ago
By default better-sqlite3 compiles SQLite with SQLITE_ENABLE_FTS5
.
Your code produces:
SqliteError: no such table: t_content_idx
Please provide a complete self-contained reproduction using an in-memory db.
import Database from 'better-sqlite3'
const db = new Database(':memory:');
// Your setup code
console.log(db.prepare(`SELECT * FROM t_content_idx where t_content_idx match 'a'`).all());
const st1 = db.prepare(
SELECT * FROM t_content_idx where t_content_idx match 'a'
)it return null ,why? the better-sqlit3 don't support fts5 extenssion?