Index: third_party/sqlite/src/test/tkt3838.test |
diff --git a/third_party/sqlite/src/test/tkt3838.test b/third_party/sqlite/src/test/tkt3838.test |
index 4fb5c55a8a24be3d2eae8314f415cb43bf9d4f67..fa937acdf4ea2f5b7024443ff2eafb9f29a8bea3 100644 |
--- a/third_party/sqlite/src/test/tkt3838.test |
+++ b/third_party/sqlite/src/test/tkt3838.test |
@@ -25,7 +25,7 @@ ifcapable !altertable { |
return |
} |
-do_test tkt3838-1.1 { |
+do_realnum_test tkt3838-1.1 { |
db eval { |
PRAGMA encoding=UTF16; |
CREATE TABLE t1(x); |
@@ -38,4 +38,21 @@ do_test tkt3838-1.1 { |
} |
} {2 999 9e+99 xyzzy} |
+ifcapable trigger { |
+ do_test tkt3838-1.2 { |
+ db eval { |
+ CREATE TABLE log(y); |
+ CREATE TRIGGER r1 AFTER INSERT ON T1 BEGIN |
+ INSERT INTO log VALUES(new.x); |
+ END; |
+ INSERT INTO t1(x) VALUES(123); |
+ ALTER TABLE T1 RENAME TO XYZ2; |
+ INSERT INTO xyz2(x) VALUES(456); |
+ ALTER TABLE xyz2 RENAME TO pqr3; |
+ INSERT INTO pqr3(x) VALUES(789); |
+ SELECT * FROM log; |
+ } |
+ } {123 456 789} |
+} |
+ |
finish_test |