1 files changed, 17 insertions, 7 deletions

diff --git a/test/altercol.test b/test/altercol.test
index f6ead9924..d5fc8f150 100644
--- a/test/altercol.test
+++ b/test/altercol.test
@@ -125,25 +125,35 @@ do_execsql_test -db db2 2.3 { SELECT biglongname FROM t3 }
 do_execsql_test 3.0 {
   CREATE TABLE t4(x, y, z);
   CREATE TRIGGER ttt AFTER INSERT ON t4 WHEN new.y<0 BEGIN
-    SELECT 1, 2, 3, 4;
+    SELECT x, y, z FROM t4;
+    DELETE FROM t4 WHERE y=32;
+    UPDATE t4 SET x=y+1, y=0 WHERE y=32;
+    INSERT INTO t4(x, y, z) SELECT 4, 5, 6 WHERE 0;
   END;
   INSERT INTO t4 VALUES(3, 2, 1);
 }
 
+breakpoint
 do_execsql_test 3.1 {
   ALTER TABLE t4 RENAME y TO abc;
   SELECT sql FROM sqlite_master WHERE name='t4';
 } {{CREATE TABLE t4(x, abc, z)}}
 
-db close
-sqlite3 db test.db
-
 do_execsql_test 3.2 {
   SELECT * FROM t4;
 } {3 2 1}
 
 do_execsql_test 3.3 { INSERT INTO t4 VALUES(6, 5, 4); } {}
 
+do_execsql_test 3.4 { SELECT sql FROM sqlite_master WHERE type='trigger' } {
+{CREATE TRIGGER ttt AFTER INSERT ON t4 WHEN new.abc<0 BEGIN
+    SELECT x, abc, z FROM t4;
+    DELETE FROM t4 WHERE abc=32;
+    UPDATE t4 SET x=abc+1, abc=0 WHERE abc=32;
+    INSERT INTO t4(x, abc, z) SELECT 4, 5, 6 WHERE 0;
+  END}
+}
+
 #-------------------------------------------------------------------------
 #
 do_execsql_test 4.0 {
@@ -233,17 +243,17 @@ do_execsql_test 7.0 {
   END;
 }
 
-do_execsql_test 7.1 {
+do_execsql_test 7.1.1 {
   INSERT INTO t6 VALUES(0, 0, 0);
   UPDATE t6 SET "col c" = 1;
   SELECT * FROM c;
 } {1}
 
-do_execsql_test 7.2 {
+do_execsql_test 7.1.2 {
   ALTER TABLE t6 RENAME "col c" TO "col 3";
 }
 
-do_execsql_test 7.3 {
+do_execsql_test 7.1.3 {
   UPDATE t6 SET "col 3" = 0;
   SELECT * FROM c;
 } {2}