bk commit into 6.0 tree (anozdrin:1.2599) BUG#25393

[Alexander Nozdrin]

Below is the list of changes that have just been committed into a local
6.0 repository of anozdrin.  When anozdrin does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2008-03-12 18:24:49+03:00, anozdrin@quad. +2 -0
  A test case for Bug#25393: Falcon: TRUNCATE causes activation of
  DELETE trigger.

  mysql-test/suite/falcon/r/falcon_bug_25393.result@stripped, 2008-03-12 18:24:48+03:00, anozdrin@quad. +22 -0
    A test case for Bug#25393: Falcon: TRUNCATE causes activation of
    DELETE trigger.

  mysql-test/suite/falcon/r/falcon_bug_25393.result@stripped, 2008-03-12 18:24:48+03:00, anozdrin@quad. +0 -0

  mysql-test/suite/falcon/t/falcon_bug_25393.test@stripped, 2008-03-12 18:24:48+03:00, anozdrin@quad. +32 -0
    Result file.

  mysql-test/suite/falcon/t/falcon_bug_25393.test@stripped, 2008-03-12 18:24:48+03:00, anozdrin@quad. +0 -0

diff -Nrup a/mysql-test/suite/falcon/r/falcon_bug_25393.result b/mysql-test/suite/falcon/r/falcon_bug_25393.result
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/falcon/r/falcon_bug_25393.result	2008-03-12 18:24:48 +03:00
@@ -0,0 +1,22 @@
+SET @@storage_engine = Falcon;
+
+#
+# Bug#25393: Falcon: TRUNCATE causes activation of DELETE trigger
+#
+
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+
+CREATE TABLE t1 (c1 INT) ENGINE=falcon;
+CREATE TABLE t2 (c1 INT) ENGINE=falcon;
+
+CREATE TRIGGER t1_ad AFTER DELETE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1);
+
+INSERT INTO t1 VALUES (1);
+
+TRUNCATE TABLE t1;
+
+SELECT * FROM t2;
+c1
+
+DROP TABLE t1, t2;
diff -Nrup a/mysql-test/suite/falcon/t/falcon_bug_25393.test b/mysql-test/suite/falcon/t/falcon_bug_25393.test
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/falcon/t/falcon_bug_25393.test	2008-03-12 18:24:48 +03:00
@@ -0,0 +1,32 @@
+--source include/have_falcon.inc
+SET @@storage_engine = Falcon;
+
+--echo
+--echo #
+--echo # Bug#25393: Falcon: TRUNCATE causes activation of DELETE trigger
+--echo #
+
+--echo
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+--enable_warnings
+
+--echo
+CREATE TABLE t1 (c1 INT) ENGINE=falcon;
+CREATE TABLE t2 (c1 INT) ENGINE=falcon;
+
+--echo
+CREATE TRIGGER t1_ad AFTER DELETE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1);
+
+--echo
+INSERT INTO t1 VALUES (1);
+
+--echo
+TRUNCATE TABLE t1;
+
+--echo
+SELECT * FROM t2;
+
+--echo
+DROP TABLE t1, t2;