Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.0.8
-
None
Description
In the following example error 1370 is ok, but I'm trying to handle it, and this seems to be impossible.
MariaDB [test]> CREATE USER u2; |
Query OK, 0 rows affected (0.00 sec) |
|
MariaDB [test]> DELIMITER ||
|
MariaDB [test]> CREATE DEFINER = u2 PROCEDURE p() |
-> SQL SECURITY DEFINER
|
-> BEGIN |
-> DECLARE EXIT HANDLER |
-> FOR 1370 |
-> SELECT 1370 AS `ERROR`; |
-> DECLARE EXIT HANDLER |
-> FOR SQLSTATE '42000' |
-> SELECT '42000' AS `ERROR`; |
-> SHOW PROCESSLIST;
|
-> SELECT 'OK'; |
-> END; |
-> ||
|
Query OK, 0 rows affected (0.03 sec) |
|
MariaDB [test]> DELIMITER ;
|
MariaDB [test]> CALL p();
|
ERROR 1370 (42000): execute command denied to user 'u2'@'%' for routine 'test.p' |