aboutsummaryrefslogtreecommitdiff
path: root/test/fts3misc.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/fts3misc.test')
-rw-r--r--test/fts3misc.test20
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