Re: Server crashes

[Paul McArdle]

works ok for me on 5.0.7-beta
red hat 9

create table a ( a int(4), b varchar(4) );
Query OK, 0 rows affected (0.00 sec)

delimiter //
mysql> create trigger a_bfu before update on a FOR EACH ROW
-> begin
-> if new.a <> OLD.a THEN
-> set NEW.b = 'c';
-> end if;
-> end
-> //
Query OK, 0 rows affected (0.03 sec)

insert into a values( 1, 'a');
-> //
Query OK, 1 row affected (0.00 sec)

mysql> select * from a //
+------+------+
| a | b |
+------+------+
| 1 | a |
+------+------+
1 row in set (0.00 sec)

mysql> update a set a = 2 where a = 1//
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from a //
+------+------+
| a | b |
+------+------+
| 2 | c |
+------+------+
1 row in set (0.00 sec)

mysql> select version()//
+---------------------+
| version() |
+---------------------+
| 5.0.7-beta-standard |
+---------------------+