Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.3, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
-
None
Description
I create a number of stored functions as follow:
DROP FUNCTION IF EXISTS f1a; |
DROP FUNCTION IF EXISTS f1b; |
DROP FUNCTION IF EXISTS f2; |
DELIMITER $$
|
CREATE FUNCTION f1a() RETURNS TEXT |
BEGIN
|
RETURN f2(); |
END; |
$$
|
CREATE FUNCTION f1b() RETURNS TEXT |
BEGIN
|
DO f2();
|
RETURN ''; |
END; |
$$
|
CREATE FUNCTION f2() RETURNS TEXT |
BEGIN
|
DO unknown_function_name();
|
RETURN ''; |
END; |
$$
|
DELIMITER ;
|
Now I run:
SELECT f1a(); |
It correctly returns the error:
ERROR 1305 (42000): FUNCTION test.unknown_function_name does not exist
|
Now I run:
SELECT f1b(); |
It returns a result without errors:
+-------+
|
| f1b() |
|
+-------+
|
| |
|
+-------+
|
The second SELECT query should return the same error with the first SELECT query.
Now I run this script:
DO f1a();
|
SHOW WARNINGS;
|
It works without errors and return a warning:
+-------+------+----------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+----------------------------------------------------+
|
| Error | 1305 | FUNCTION test.unknown_function_name does not exist |
|
+-------+------+----------------------------------------------------+
|
This script should return FUNCTION test.unknown_function_name does not exist.
Now I run:
DO f1b();
|
It returns without errors and without warnings.
It should return FUNCTION test.unknown_function_name does not exist.