List:Commits« Previous MessageNext Message »
From:konstantin Date:July 18 2007 10:42am
Subject:bk commit into 5.0 tree (kostja:1.2530) BUG#27248
View as plain text  
Below is the list of changes that have just been committed into a local
5.0 repository of kostja. When kostja 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, 2007-07-18 14:42:06+04:00, kostja@bodhi.(none) +2 -0
  Add a test case for Bug#27248 Triggers: error if insert affects temporary 
  table.
  The bug itself is yet another manifestation of Bug 26141.

  mysql-test/r/trigger.result@stripped, 2007-07-18 14:42:03+04:00, kostja@bodhi.(none) +28 -0
    Update results.

  mysql-test/t/trigger.test@stripped, 2007-07-18 14:42:03+04:00, kostja@bodhi.(none) +23 -0
    Add a test case for Bug#27248 Triggers: error if insert affects temporary
    table

diff -Nrup a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result
--- a/mysql-test/r/trigger.result	2007-07-12 22:26:38 +04:00
+++ b/mysql-test/r/trigger.result	2007-07-18 14:42:03 +04:00
@@ -1933,4 +1933,32 @@ Before UPDATE, new=multi-UPDATE, SET for
 After UPDATE, new=multi-UPDATE, SET for t2, but the trigger is fired, old=multi-UPDATE
 drop view v1;
 drop table t1, t2, t1_op_log;
+
+Bug#27248 Triggers: error if insert affects temporary table
+
+The bug was fixed by the fix for Bug#26141
+
+drop table if exists t1;
+drop temporary table if exists t2;
+create table t1 (s1 int);
+create temporary table t2 (s1 int);
+create trigger t1_bi before insert on t1 for each row insert into t2 values (0);
+create trigger t1_bd before delete on t1 for each row delete from t2;
+insert into t1 values (0);
+insert into t1 values (0);
+select * from t1;
+s1
+0
+0
+select * from t2;
+s1
+0
+0
+delete from t1;
+select * from t1;
+s1
+select * from t2;
+s1
+drop table t1;
+drop temporary table t2;
 End of 5.0 tests
diff -Nrup a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test
--- a/mysql-test/t/trigger.test	2007-07-12 22:26:38 +04:00
+++ b/mysql-test/t/trigger.test	2007-07-18 14:42:03 +04:00
@@ -2194,4 +2194,27 @@ drop table t1, t2, t1_op_log;
 
 #
 # TODO: test LOAD DATA INFILE
+#
+--echo
+--echo Bug#27248 Triggers: error if insert affects temporary table
+--echo
+--echo The bug was fixed by the fix for Bug#26141
+--echo
+--disable_warnings
+drop table if exists t1;
+drop temporary table if exists t2;
+--enable_warnings
+create table t1 (s1 int);
+create temporary table t2 (s1 int);
+create trigger t1_bi before insert on t1 for each row insert into t2 values (0);
+create trigger t1_bd before delete on t1 for each row delete from t2;
+insert into t1 values (0);
+insert into t1 values (0);
+select * from t1;
+select * from t2;
+delete from t1;
+select * from t1;
+select * from t2;
+drop table t1;
+drop temporary table t2;
 --echo End of 5.0 tests
Thread
bk commit into 5.0 tree (kostja:1.2530) BUG#27248konstantin18 Jul