/* Function/Procedure Setup */

DELIMITER $$

CREATE FUNCTION `f`() RETURNS INT(11)
BEGIN
	SIGNAL SQLSTATE '01234';  -- signal a warning
	RETURN 5;
END$$

CREATE PROCEDURE `p`()
BEGIN
	SIGNAL SQLSTATE '01234';
END$$

CREATE PROCEDURE `p2`()
BEGIN
	SIGNAL SQLSTATE '01234';
	SELECT RAND() INTO @unused;
END$$

DELIMITER ;

/* Queries */
SELECT f();
CALL p();
CALL p2();

/* Result Readout */
3 queries executed, 3 success, 0 errors, 1 warnings

Query: SELECT f()

1 row(s) affected

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0.001 sec
-----------------------------------------------------------

Query: CALL p()

0 row(s) affected, 1 warning(s)

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0 sec

Warning Code : 1642
Unhandled user-defined warning condition
-----------------------------------------------------------

Query: CALL p2()

1 row(s) affected

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0 sec

/* Expected Result */
3 queries executed, 3 success, 0 errors, 3 warnings

Query: SELECT f()

1 row(s) affected, 1 warning(s)

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0.001 sec

Warning Code : 1642
Unhandled user-defined warning condition
-----------------------------------------------------------

Query: CALL p()

0 row(s) affected, 1 warning(s)

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0 sec

Warning Code : 1642
Unhandled user-defined warning condition
-----------------------------------------------------------

Query: CALL p2()

1 row(s) affected, 1 warning(s)

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0 sec

Warning Code : 1642
Unhandled user-defined warning condition