diff options
Diffstat (limited to 'src/pl/tcl/sql/pltcl_queries.sql')
| -rw-r--r-- | src/pl/tcl/sql/pltcl_queries.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/pl/tcl/sql/pltcl_queries.sql b/src/pl/tcl/sql/pltcl_queries.sql index 3a99132ae4..ee711d5170 100644 --- a/src/pl/tcl/sql/pltcl_queries.sql +++ b/src/pl/tcl/sql/pltcl_queries.sql @@ -73,8 +73,12 @@ select 100 @< 4; select * from T_pkey1 order by key1 using @<, key2; select * from T_pkey2 order by key1 using @<, key2; - -- show dump of trigger data insert into trigger_test values(1,'insert'); + +insert into trigger_test_view values(2,'insert'); +update trigger_test_view set v = 'update' where i=1; +delete from trigger_test_view; + update trigger_test set v = 'update' where i = 1; delete from trigger_test; |
