Server crashes
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
Subject
Views
Written By
Posted
Server crashes
3474
May 29, 2005 12:04PM
2454
May 29, 2005 03:08PM
2358
June 01, 2005 01:12AM
2325
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.