MariaDB [mysql]> create function bob() returns int return 1;

MariaDB [mysql]> update proc set body='return no_such_var' where name='bob';

Query OK, 1 row affected (0.001 sec)

Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [mysql]> show create function bob;

ERROR 1327 (42000): Undeclared variable: no_such_var

MariaDB [mysql]> select bob();

ERROR 1457 (HY000): Failed to load routine mysql.bob (internal code -6). For more details, run SHOW WARNINGS

MariaDB [mysql]> show warnings;

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

| Level | Code | Message                                                                                  |

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

| Error | 1327 | Undeclared variable: no_such_var                                                         |

| Error | 1457 | Failed to load routine mysql.bob (internal code -6). For more details, run SHOW WARNINGS |

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

2 rows in set (0.000 sec)