mercredi 15 août 2018

Error in if condition on mysql trigger

I have written a small trigger function in MySQL . This is the trigger query i have written and the condition are not checked direct default value of created_id is assigned.

CREATE TRIGGER `complain_attend_log` AFTER INSERT ON `attend_complain`
 FOR EACH ROW BEGIN
    DECLARE attend_created INT;
    DECLARE created_id INT default 5;

SET attend_created = (SELECT attend_created FROM allotments WHERE complain_id = NEW.complain_id);

IF(attend_created = 1) THEN
    SET created_id = 6;
END IF;

INSERT INTO complain_logs
VALUES(null,NEW.complain_id,NEW.allotment_id,NEW.attend_complain_id,NEW.is_closed,created_id,1,now(),1,now());
END

Aucun commentaire:

Enregistrer un commentaire