Index: third_party/sqlite/src/test/fts3b.test |
diff --git a/third_party/sqlite/src/test/fts3b.test b/third_party/sqlite/src/test/fts3b.test |
index 17ee0da85ac46b571ac0d2f0a5d610c3c4b78c9d..9bde3a254c2885f361824b86f28e95f21b8befb0 100644 |
--- a/third_party/sqlite/src/test/fts3b.test |
+++ b/third_party/sqlite/src/test/fts3b.test |
@@ -208,11 +208,23 @@ do_test fts3b-4.8 { |
} |
} {1 {SQL logic error or missing database}} |
-# Don't allow update of docid, to match rowid behaviour. |
do_test fts3b-4.9 { |
- catchsql { |
+ execsql { SELECT docid FROM t4 WHERE t4 MATCH 'testing' } |
+} {12} |
+do_test fts3b-4.10 { |
+ execsql { |
UPDATE t4 SET docid = 14 WHERE docid = 12; |
+ SELECT docid FROM t4 WHERE t4 MATCH 'testing'; |
} |
-} {1 {SQL logic error or missing database}} |
+} {14} |
+do_test fts3b-4.11 { |
+ execsql { SELECT * FROM t4 WHERE rowid = 14; } |
+} {{still testing}} |
+do_test fts3b-4.12 { |
+ execsql { SELECT * FROM t4 WHERE rowid = 12; } |
+} {} |
+do_test fts3b-4.13 { |
+ execsql { SELECT docid FROM t4 WHERE t4 MATCH 'still'; } |
+} {14} |
finish_test |