server crashs

[seetharamakrishna kurra]

Hello techies,
I am using mysqlserver 5.0.4 beta version.
I am trying to use triggers. My trigger is

CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));

CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH ROW SET @sum = @sum + NEW.amount;

Now, when i try to insert some values into the account table

SET @sum = 0;
mysql> INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
mysql> SELECT @sum AS 'Total amount inserted';

The server crashes.

why this happens ??
Does triggers not supported in mysql 5.0.4beta version.


regards,
ramu