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/t/trigger.test | |
| 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/t/trigger.test')
| -rw-r--r-- | mysql-test/t/trigger.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test index aa6cb2bf025..825f1fec6b9 100644 --- a/mysql-test/t/trigger.test +++ b/mysql-test/t/trigger.test @@ -1505,6 +1505,31 @@ update t1 set i= i+ 10 where j > 2; select * from t1; drop table t1; +# +# Bug#23556 TRUNCATE TABLE still maps to DELETE +# +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'; +SELECT COUNT(*) FROM t2; + +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'; +SELECT COUNT(*) FROM t2; + +DROP TRIGGER trg_t1; +DROP TABLE t1,t2; # # Bug #23651 "Server crashes when trigger which uses stored function |