diff options
Diffstat (limited to 'test/fts3misc.test')
-rw-r--r-- | test/fts3misc.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/test/fts3misc.test b/test/fts3misc.test index 4532a79f0..92b93d033 100644 --- a/test/fts3misc.test +++ b/test/fts3misc.test @@ -283,4 +283,24 @@ do_execsql_test 8.3 { INSERT INTO vt0(vt0) VALUES('integrity-check'); } +#------------------------------------------------------------------------- +# +reset_db +do_execsql_test 9.0 { + CREATE VIRTUAL TABLE t1 using fts4(mailcontent); + insert into t1(rowid, mailcontent) values + (-4764623217061966105, 'we are going to upgrade'), + (8324454597464624651, 'we are going to upgrade'); +} + +do_execsql_test 9.1 { + INSERT INTO t1(t1) VALUES('integrity-check'); +} + +do_execsql_test 9.2 { + SELECT rowid FROM t1 WHERE t1 MATCH 'upgrade'; +} { + -4764623217061966105 8324454597464624651 +} + finish_test |