Debian Codegraph @

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

raw
1 /*
2 ** SCRIPT_MODULE_NAME: fts5-sanity-checks
3 ** xREQUIRED_PROPERTIES: FTS5
4 **
5 */
6
7 --testcase 1.0
8 CREATE VIRTUAL TABLE email USING fts5(sender, title, body);
9 insert into email values('fred','Help!','Dear Sir...');
10 insert into email values('barney','Assistance','Dear Madam...');
11 select * from email where email match 'assistance';
12 --result barney Assistance {Dear Madam...}