ext/jni/src/tests/900-001-fts.test

/*
** SCRIPT_MODULE_NAME:      fts5-sanity-checks
** xREQUIRED_PROPERTIES:     FTS5
**
*/

--testcase 1.0
CREATE VIRTUAL TABLE email USING fts5(sender, title, body);
insert into email values('fred','Help!','Dear Sir...');
insert into email values('barney','Assistance','Dear Madam...');
select * from email where email match 'assistance';
--result barney Assistance {Dear Madam...}