Skip navigation links

MySQL Forums :: Triggers :: Server crashes


Advanced Search

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 2356 Dennis Schaaf 05/29/2005 12:04PM
Re: Server crashes 1762 Andrew Gilfrin 05/29/2005 03:08PM
Re: Server crashes 1770 Dmitri Lenev 06/01/2005 01:12AM
Re: Server crashes 1724 Paul McArdle 06/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.