aboutsummaryrefslogtreecommitdiff
path: root/test/altertab.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/altertab.test')
-rw-r--r--test/altertab.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/test/altertab.test b/test/altertab.test
index d8dd98741..576d391ce 100644
--- a/test/altertab.test
+++ b/test/altertab.test
@@ -768,4 +768,35 @@ do_execsql_test 26.1 {
SELECT * FROM t1x;
} {2 1}
+#-------------------------------------------------------------------------
+reset_db
+
+do_execsql_test 27.1 {
+
+ create table t_sa (
+ c_muyat INTEGER NOT NULL,
+ c_d4u TEXT
+ );
+
+ create table t2 ( abc );
+
+ CREATE TRIGGER trig AFTER DELETE ON t_sa
+ BEGIN
+ DELETE FROM t_sa WHERE (
+ SELECT 123 FROM t2
+ WINDOW oamat7fzf AS ( PARTITION BY t_sa.c_d4u )
+ );
+ END;
+}
+
+
+breakpoint
+do_execsql_test 27.2 {
+ alter table t_sa rename column c_muyat to c_dg;
+}
+
+
+
+
+
finish_test