Bug #67921 Trigger user defined warnings aint checked
Submitted: 17 Dec 2012 10:25 Modified: 18 Dec 2012 6:28
Reporter: Rami Jamleh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.5.28, 5.5.30, 5.7.1 OS:Any (MS Windows 7 SP1, Linux)
Assigned to: Jon Olav Hauglid CPU Architecture:Any
Tags: mysql sqlstate

[17 Dec 2012 10:25] Rami Jamleh 
Description:
the problem is that i don't get warning on this 

\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

select @@warning_count 
-- ouput 0

How to repeat:
by inserting data
[17 Dec 2012 14:22] Rami Jamleh 
I think the row show be inserted but a warning should be counted as received as well
[17 Dec 2012 21:48] Sveta Smirnova 
Thank you for the report.

Verified as described. Only states which produce warnings are affected: error returned just fine.
[18 Dec 2012 6:28] Jon Olav Hauglid 
Hello!

This is not a bug, but standard behaviour.
See Bug#55850 for an explanation.