delimiter $$

CREATE PROCEDURE p1() BEGIN  DROP TABLE whichdoesnotexist; END $$

CREATE PROCEDURE p2() BEGIN  CALL p1(); END  $$

CREATE PROCEDURE p3() BEGIN  CALL p2(); END  $$

delimiter ;

SET @@max_error_count=2;

CALL  p3();

SELECT @@warning_count;

+-----------------+

| @@warning_count |

+-----------------+

|               3 |

+-----------------+

SHOW WARNINGS;

+-------+------+----------------------------------------+

| Level | Code | Message                                |

+-------+------+----------------------------------------+

| Error | 1051 | Unknown table 'test.whichdoesnotexist' |

| Note  | 4094 | At line 2 in test.p1                   |

+-------+------+----------------------------------------+

set @@max_error_count=4;

call p3();

select @@warning_count;

+-----------------+

| @@warning_count |

+-----------------+

|               4 |

+-----------------+

show warnings;

+-------+------+----------------------------------------+

| Level | Code | Message                                |

+-------+------+----------------------------------------+

| Error | 1051 | Unknown table 'test.whichdoesnotexist' |

| Note  | 4094 | At line 2 in test.p1                   |

| Note  | 4094 | At line 2 in test.p2                   |

| Note  | 4094 | At line 2 in test.p3                   |

+-------+------+----------------------------------------+