MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Jon Olav Hauglid Date:October 12 2009 11:00am
Subject:bzr push into mysql-5.5.0-next-mr-runtime branch (jon.hauglid:2908 to 2909)
Bug#34453
View as plain text  
 2909 Jon Olav Hauglid	2009-10-12
      Bug #34453 Can't change size of file (Errcode: 1224)
           
      Unable to reproduce error on current version of the 5.5.0
      codebase. Test case based on the bug report added to trigger.test.
      
      Backport of revno: 2617.52.11.

    modified:
      mysql-test/r/trigger.result
      mysql-test/t/trigger.test
 2908 Alexander Nozdrin	2009-10-11
      Post-backporting (Bug#28299) fix for fixing results of ndb_views.test.

    modified:
      mysql-test/suite/funcs_1/r/ndb_views.result
=== modified file 'mysql-test/r/trigger.result'
--- a/mysql-test/r/trigger.result	2009-09-10 09:18:29 +0000
+++ b/mysql-test/r/trigger.result	2009-10-12 10:59:55 +0000
@@ -2088,3 +2088,30 @@ SELECT * FROM t2;
 a	b
 DROP TABLE t1, t2;
 End of 5.1 tests.
+#
+# Bug#34453 Can't change size of file (Errcode: 1224)
+#
+DROP TRIGGER IF EXISTS t1_bi;
+DROP TRIGGER IF EXISTS t1_bd;
+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
+# Reported to give ERROR 14 (HY000): 
+# Can't change size of file (Errcode: 1224)
+# on Windows 
+DELETE FROM t1;
+DROP TABLE t1;
+DROP TEMPORARY TABLE t2;

=== modified file 'mysql-test/t/trigger.test'
--- a/mysql-test/t/trigger.test	2009-06-22 12:51:33 +0000
+++ b/mysql-test/t/trigger.test	2009-10-12 10:59:55 +0000
@@ -2397,3 +2397,31 @@ SELECT * FROM t2;
 DROP TABLE t1, t2;
 
 --echo End of 5.1 tests.
+
+
+--echo #
+--echo # Bug#34453 Can't change size of file (Errcode: 1224)
+--echo #
+
+--disable_warnings
+DROP TRIGGER IF EXISTS t1_bi;
+DROP TRIGGER IF EXISTS t1_bd;
+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;
+-- echo # Reported to give ERROR 14 (HY000): 
+-- echo # Can't change size of file (Errcode: 1224)
+-- echo # on Windows 
+DELETE FROM t1;
+
+DROP TABLE t1;
+DROP TEMPORARY TABLE t2;


Attachment: [text/bzr-bundle] bzr/jon.hauglid@sun.com-20091012105955-vcftfhks6ikoycjw.bundle
Thread
bzr push into mysql-5.5.0-next-mr-runtime branch (jon.hauglid:2908 to 2909)Bug#34453Jon Olav Hauglid12 Oct