diff options
| author | unknown <gkodinov/kgeorge@rakia.gmz> | 2007-02-01 11:07:17 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@rakia.gmz> | 2007-02-01 11:07:17 +0200 |
| commit | 020e82c6505ff22415145fb86c70a2fae9a5d2a4 (patch) | |
| tree | b2ddab9d0574cc747dd55917cdef2cb989b43fd0 /mysql-test/r/trigger.result | |
| parent | c15b2e4152854f48ba3f43ace52103010bca603d (diff) | |
| parent | 1a0e1f1328c933d63e0bb0d99b9011058abd82cd (diff) | |
| download | mariadb-git-020e82c6505ff22415145fb86c70a2fae9a5d2a4.tar.gz | |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into rakia.gmz:/home/kgeorge/mysql/autopush/B23556-5.0-opt
mysql-test/t/trigger.test:
Auto merged
sql/sql_delete.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index 3d40a2d05df..340b775cb85 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -1310,4 +1310,29 @@ SELECT fubar_id FROM t2; fubar_id 1 DROP TABLE t1,t2; +CREATE TABLE t1 (a INT PRIMARY KEY); +CREATE TABLE t2 (a INT PRIMARY KEY); +INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8); +CREATE TRIGGER trg_t1 BEFORE DELETE on t1 FOR EACH ROW +INSERT INTO t2 VALUES (OLD.a); +FLUSH STATUS; +TRUNCATE t1; +SHOW STATUS LIKE 'handler_delete'; +Variable_name Value +Handler_delete 0 +SELECT COUNT(*) FROM t2; +COUNT(*) +0 +INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8); +DELETE FROM t2; +FLUSH STATUS; +DELETE FROM t1; +SHOW STATUS LIKE 'handler_delete'; +Variable_name Value +Handler_delete 8 +SELECT COUNT(*) FROM t2; +COUNT(*) +8 +DROP TRIGGER trg_t1; +DROP TABLE t1,t2; End of 5.0 tests |