mysql - 当我发出类似 '01%' 的信号时，我没有收到警告

Question

在这个触发器之后，如果我在 foo.x 中插入 5，我不会收到警告

\d $
CREATE TRIGGER `tri` BEFORE INSERT ON `foo` FOR EACH ROW
BEGIN
    IF NEW.bar = 5 THEN
        SIGNAL SQLSTATE '01002' SET MESSAGE_TEXT = 'MSG';
    END IF;
END$\d ;

INSERT INTO `foo` values (5);

1 row affected

Answer 1

根据 Changes in MySQL 5.5.8 (2010-12-03, General Availability) 记录:

Bugs Fixed

[ deletia ]

• Warnings raised by a trigger were not cleared upon successful completion. Now warnings are cleared if the trigger completes successfully, per the SQL standard. (Bug #55850)