diff options
| author | Jan Mercl <0xjnml@gmail.com> | 2020-08-26 23:31:54 +0200 |
|---|---|---|
| committer | Jan Mercl <0xjnml@gmail.com> | 2020-08-26 23:31:54 +0200 |
| commit | e662a135d139be00d9539517df0976318adbdfa1 (patch) | |
| tree | a3f39f3ad0b653020dbd24f23ca5e32ac86fce3b /testdata/tcl/altertab3.test | |
| parent | 43c865ce5d35eb463e4a05f65e8e388364480711 (diff) | |
release 1.4.0v1.4.0
Diffstat (limited to 'testdata/tcl/altertab3.test')
| -rw-r--r-- | testdata/tcl/altertab3.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/testdata/tcl/altertab3.test b/testdata/tcl/altertab3.test index b390655..005a0ee 100644 --- a/testdata/tcl/altertab3.test +++ b/testdata/tcl/altertab3.test @@ -586,5 +586,19 @@ do_execsql_test 24.4 { DELETE FROM v2; END}} +#------------------------------------------------------------------------ +# +reset_db +do_execsql_test 25.1 { + CREATE TABLE t1(a, b, c); + CREATE TABLE t2(a, b, c); + CREATE TRIGGER ttt AFTER INSERT ON t1 BEGIN + UPDATE t1 SET a=t2.a FROM t2 WHERE t1.a=t2.a; + END; +} +#do_execsql_test 25.2 { +# ALTER TABLE t2 RENAME COLUMN a TO aaa; +#} + finish_test |