maria-discuss team mailing list archive
Mailing list archive
INSERT IGNORE and triggers
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
FOR EACH ROW
SIGNAL SQLSTATE '23000'
SET MYSQL_ERRNO = 1048;