Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
13.1
-
None
-
Can result in hang or crash
-
Q3/2026 Server Development
Description
CREATE OR REPLACE TABLE t1 (a INT) ENGINE=MyISAM; |
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p3() |
BEGIN
|
EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (9)'; |
END; |
$$
|
CREATE OR REPLACE FUNCTION f2() RETURNS INT |
BEGIN
|
CALL p3();
|
RETURN 0; |
END; |
$$
|
CREATE OR REPLACE PROCEDURE p1() |
BEGIN
|
DECLARE n INT; |
SET n= f2(); |
END; |
$$
|
DELIMITER ;
|
CALL p1;
|
ERROR 1146 (42S02): Table 'test.t1' doesn't exist
|
Attachments
Issue Links
- is caused by
-
MDEV-39518 Allow prepared statements in stored functions in assignment right hand
-
- Closed
-