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...} |