MySQL Forums
Forum List  »  Triggers

Server crashes
Posted by: Dennis Schaaf
Date: May 29, 2005 12:04PM

I created the following trigger:
CREATE TRIGGER update_pos BEFORE UPDATE ON pos FOR EACH ROW
BEGIN
IF NEW.quantity <> OLD.quantity
THEN
SET NEW.modified = 1;
END IF;
END
Each time I make a simple update on table pos mysql-nt crashes (restart of service neccessary). However when I modify the trigger to
CREATE TRIGGER update_pos BEFORE UPDATE ON pos FOR EACH ROW
BEGIN
SET NEW.modified = 1;
END
it works without any problems. I tried 5.0.3 and 5.0.4.

Dennis

Options: ReplyQuote


Subject
Views
Written By
Posted
Server crashes
2893
May 29, 2005 12:04PM
2085
May 29, 2005 03:08PM
2036
June 01, 2005 01:12AM
1988
June 29, 2005 12:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.