#At file:///export/home/z/mysql-azalea-bugfixing-bug34453/ based on revid:magne.mahre@stripped
2791 Jon Olav Hauglid 2009-06-02
Bug #34453 Can't change size of file (Errcode: 1224)
Unable to reproduce error on current version of mysql azalea.
Test case based on the bug report added to trigger.test.
modified:
mysql-test/r/trigger.result
mysql-test/t/trigger.test
=== modified file 'mysql-test/r/trigger.result'
--- a/mysql-test/r/trigger.result 2009-03-27 13:03:00 +0000
+++ b/mysql-test/r/trigger.result 2009-06-02 09:19:55 +0000
@@ -2121,4 +2121,30 @@ Warning 1265 Data truncated for column '
DROP TRIGGER trg1;
DROP TRIGGER trg2;
DROP TABLE t1;
+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 TRIGGER t1_bi;
+DROP TRIGGER t1_bd;
+DROP TABLE t1;
+DROP TEMPORARY TABLE t2;
End of 6.0 tests.
=== modified file 'mysql-test/t/trigger.test'
--- a/mysql-test/t/trigger.test 2009-03-27 13:03:00 +0000
+++ b/mysql-test/t/trigger.test 2009-06-02 09:19:55 +0000
@@ -2435,4 +2435,33 @@ DROP TRIGGER trg1;
DROP TRIGGER trg2;
DROP TABLE t1;
+#
+# Bug#34453 Can't change size of file (Errcode: 1224)
+#
+
+--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 TRIGGER t1_bi;
+DROP TRIGGER t1_bd;
+DROP TABLE t1;
+DROP TEMPORARY TABLE t2;
+
--echo End of 6.0 tests.
Attachment: [text/bzr-bundle] bzr/jon.hauglid@sun.com-20090602091955-fsip7s5ip4x2w1w6.bundle
