* Jon Olav Hauglid <Jon.Hauglid@stripped> [09/06/02 13:41]:
> 2791 Jon Olav Hauglid 2009-06-02
> Bug #34453 Can't change size of file (Errcode: 1224)
OK to push.
> === 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)
> +#
Suggest to use --echo # here as well,
so that comments make it into the result
file.
> +
> +--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;
Dropping a table drops its triggers. You don't have to change this
test case, just for your information.
> +DROP TEMPORARY TABLE t2;
--
