Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value.

FossilOrigin-Name: f5d0ce80792d58ef424300f973f8876d835ed4ad

1 files changed, 16 insertions, 0 deletions

diff --git a/test/trigger1.test b/test/trigger1.test
index 1ebe12c89..a190efd46 100644
--- a/test/trigger1.test
+++ b/test/trigger1.test
@@ -712,4 +712,20 @@ do_test trigger1-16.7 {
   }
 } {1 {the INDEXED BY clause is not allowed on UPDATE or DELETE statements within triggers}}
 
+#-------------------------------------------------------------------------
+# Test that bug [34cd55d68e0e6e7c] has been fixed.
+#
+do_execsql_test trigger1-17.0 {
+  CREATE TABLE t17a(ii INT);
+  CREATE TABLE t17b(tt TEXT PRIMARY KEY, ss);
+  CREATE TRIGGER t17a_ai AFTER INSERT ON t17a BEGIN
+    INSERT INTO t17b(tt) VALUES(new.ii);
+  END;
+  CREATE TRIGGER t17b_ai AFTER INSERT ON t17b BEGIN
+    UPDATE t17b SET ss = 4;
+  END;
+  INSERT INTO t17a(ii) VALUES('1');
+  PRAGMA integrity_check;
+} {ok}
+
 finish_test