I just converted to MariaDB from MySQL where this trigger worked fine.
DELIMITER ;;
CREATE TRIGGER `email_uuid_before_insert`
BEFORE INSERT ON `email` FOR EACH ROW
BEGIN
IF new.id_email IS NULL THEN
SET new.id_email = uuid();
END IF;
END;;
DELIMITER ;;
In MariaDB, it creates with no errors but when adding a row, I get an error
1062 : Duplicate entry '' for key 'PRIMARY'
It’s caused because the last row that inserted wasn’t populated with that UUID
– meaning the trigger failed.
What would cause this to fail?
Thank you,
Steffan Cline
[email protected]<mailto:[email protected]>
602-793-0014
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
