Hello. As we all know, IGNORE "catches" some errors and turns them into
warnings. But I've noticed that it does not catch the same errors if they were
issued by a trigger (using SIGNAL).
* Is this by design?
* Is this standard SQL behaior?
Here is a trigger example to show what I mean:
CREATE TRIGGER bi_t
BEFORE INSERT
ON t
FOR EACH ROW
BEGIN
SIGNAL SQLSTATE '23000'
SET MYSQL_ERRNO = 1048;
END
Regards
Federico
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
