I've a database into which I use triggers to compute some fields values when
inserting or updating a record.
Until version 7.5.00.11, everything works fine. But in 7.5.00.14, the
trigger crashes the database instance. It crashes when executing the update
statement.
CREATE TRIGGER TABLE1_UPDATE FOR TABLE1 AFTER UPDATE EXECUTE
(
VAR V_ROUND INTEGER;
V_DELTA FLOAT;
BEGIN
DECLARE C1 CURSOR FOR SELECT PAR_VALUE FROM PARAMETRES WHERE
PAR_NAME='TROUND';
FETCH C1 INTO :V_ROUND;
V_DELTA= (HOUR(TIMEDIFF(NEW.FLD_H_FIN,NEW.FLD_H_DEB)) +
(MINUTE(TIMEDIFF(NEW.FLD_H_FIN,NEW.FLD_H_DEB)) / 60) +
(SECOND(TIMEDIFF(NEW.FLD_H_FIN,NEW.FLD_H_DEB)) /3600));
UPDATE TABLE1 SET FLD_DUREE = :V_DELTA WHERE FLD_ID=:OLD.FLD_ID;
END;
)
Does anyone has an idea ?
Also I don't know how to trace into this trigger and debug it ?
TIA
Jean-Yves
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
