diff options
Diffstat (limited to 'test/tkt3838.test')
-rw-r--r-- | test/tkt3838.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/test/tkt3838.test b/test/tkt3838.test index 5dfc2b8..fa937ac 100644 --- a/test/tkt3838.test +++ b/test/tkt3838.test @@ -38,4 +38,21 @@ do_realnum_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 |