All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231)

FossilOrigin-Name: a6b862a9db6d409a53cc13e7008b27d4848b5509

1 files changed, 21 insertions, 0 deletions

diff --git a/test/trigger1.test b/test/trigger1.test
index 25087476e..afdfeda1b 100644
--- a/test/trigger1.test
+++ b/test/trigger1.test
@@ -392,4 +392,25 @@ do_test trigger-8.6 {
   }
 } {}
 
+# Make sure REPLACE works inside of triggers.
+#
+do_test trigger-9.1 {
+  execsql {
+    CREATE TABLE t3(a,b);
+    CREATE TABLE t4(x UNIQUE, b);
+    CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
+      REPLACE INTO t4 VALUES(new.a,new.b);
+    END;
+    INSERT INTO t3 VALUES(1,2);
+    SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4;
+  }
+} {1 2 99 99 1 2}
+do_test trigger-9.2 {
+  execsql {
+    INSERT INTO t3 VALUES(1,3);
+    SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4;
+  }
+} {1 2 1 3 99 99 1 3}
+
+
 finish_test