Index: third_party/sqlite/src/test/fts3conf.test |
diff --git a/third_party/sqlite/src/test/fts3conf.test b/third_party/sqlite/src/test/fts3conf.test |
index e157c239efa0887b0bc0280057e7f93f464d556e..6766a95408ad529c3c88198d77c6bd6bc940ded2 100644 |
--- a/third_party/sqlite/src/test/fts3conf.test |
+++ b/third_party/sqlite/src/test/fts3conf.test |
@@ -211,5 +211,42 @@ do_execsql_test 4.2.2 { |
INSERT INTO t01(t01) VALUES('integrity-check'); |
} {} |
-finish_test |
+do_execsql_test 4.3.1 { |
+ CREATE VIRTUAL TABLE t02 USING fts4; |
+ INSERT INTO t01 VALUES('1 1 1'); |
+ INSERT INTO t02 VALUES('2 2 2'); |
+ BEGIN; |
+ SAVEPOINT abc; |
+ INSERT INTO t01 VALUES('a b c'); |
+ INSERT INTO t02 VALUES('a b c'); |
+ ROLLBACK TO abc; |
+ COMMIT; |
+} |
+do_execsql_test 4.3.2 { |
+ SELECT * FROM t01 WHERE t01 MATCH 'b'; |
+ INSERT INTO t01(t01) VALUES('integrity-check'); |
+} {} |
+ |
+do_execsql_test 4.4.1 { |
+ CREATE TABLE A(ID INTEGER PRIMARY KEY, AnotherID INTEGER, Notes TEXT); |
+ CREATE VIRTUAL TABLE AFTS USING FTS4 (Notes); |
+ CREATE TRIGGER A_DeleteTrigger AFTER DELETE ON A FOR EACH ROW BEGIN |
+ DELETE FROM AFTS WHERE rowid=OLD.ID; |
+ END; |
+ CREATE TABLE B(ID INTEGER PRIMARY KEY,Notes TEXT); |
+ CREATE VIRTUAL TABLE BFTS USING FTS3 (Notes); |
+ CREATE TRIGGER B_DeleteTrigger AFTER DELETE ON B FOR EACH ROW BEGIN |
+ DELETE FROM BFTS WHERE rowid=OLD.ID; |
+ END; |
+} |
+ |
+do_execsql_test 4.4.2 { |
+ BEGIN TRANSACTION; |
+ DELETE FROM A WHERE AnotherID=1; |
+ DELETE FROM B WHERE ID=1; |
+ COMMIT; |
+} |
+ |
+ |
+finish_test |