maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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