diff options
Diffstat (limited to 'test/fts4content.test')
| -rw-r--r-- | test/fts4content.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/test/fts4content.test b/test/fts4content.test index 025b600..59c4199 100644 --- a/test/fts4content.test +++ b/test/fts4content.test @@ -43,6 +43,9 @@ ifcapable !fts3 { # exist, the FTS table can still be used for INSERT and some # SELECT statements. # +# 8.* - Test that if the content=xxx and prefix options are used together, +# the 'rebuild' command still works. +# do_execsql_test 1.1.1 { CREATE TABLE t1(a, b, c); @@ -498,4 +501,25 @@ do_catchsql_test 7.2.4 { SELECT * FROM ft9 WHERE ft9 MATCH 'N'; } {1 {SQL logic error or missing database}} +#------------------------------------------------------------------------- +# Test cases 8.* +# +do_execsql_test 8.1 { + CREATE TABLE t10(a, b); + INSERT INTO t10 VALUES( + 'abasia abasic abask', 'Abassin abastardize abatable'); + INSERT INTO t10 VALUES( + 'abate abatement abater', 'abatis abatised abaton'); + INSERT INTO t10 VALUES( + 'abator abattoir Abatua', 'abature abave abaxial'); + + CREATE VIRTUAL TABLE ft10 USING fts4(content=t10, prefix="2,4", a, b); +} + +do_execsql_test 8.2 { SELECT * FROM ft10 WHERE a MATCH 'ab*'; } +do_execsql_test 8.3 { INSERT INTO ft10(ft10) VALUES('rebuild'); } +do_execsql_test 8.4 { SELECT rowid FROM ft10 WHERE a MATCH 'ab*'; } {1 2 3} +do_execsql_test 8.5 { SELECT rowid FROM ft10 WHERE b MATCH 'abav*'; } {3} +do_execsql_test 8.6 { SELECT rowid FROM ft10 WHERE ft10 MATCH 'abas*'; } {1} + finish_test |