diff options
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index faea2e791d5..daddbe5ceca 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -2098,6 +2098,25 @@ b DROP DATABASE db1; USE test; End of 5.1 tests. +create table t1 (i int); +create table t2 (i int); +flush tables; +flush status; +CREATE DEFINER=`root`@`localhost` TRIGGER trg AFTER DELETE ON t1 FOR EACH ROW BEGIN DELETE FROM t2 WHERE t2.i = OLD.i; END // +insert into t1 values (1),(2); +insert into t2 values (1),(2); +delete from t1 where i=1; +show status like 'Opened_tables'; +Variable_name Value +Opened_tables 3 +select * from t1; +i +2 +select * from t2; +i +2 +drop table t1,t2; +End of 5.2 tests. # # Bug#34453 Can't change size of file (Errcode: 1224) # @@ -2181,7 +2200,6 @@ trigger_name # Clean-up. drop temporary table t1; drop table t1; - # # Bug #12362125: SP INOUT HANDLING IS BROKEN FOR TEXT TYPE. # |