Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.3, 13.0, 13.1
-
None
-
Can result in unexpected behaviour
Description
CREATE TABLE t1(a INT) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1),(2); |
|
|
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE ph() BEGIN |
EXECUTE IMMEDIATE 'HANDLER t1 OPEN AS h'; |
END
|
$$
|
DELIMITER ;
|
CALL ph;
|
HANDLER h READ FIRST; |
HANDLER h CLOSE; |
CLI Out
13.1.0-dbg>CREATE TABLE t1(a INT) ENGINE=InnoDB; |
Query OK, 0 rows affected (0.035 sec) |
|
|
13.1.0-dbg>INSERT INTO t1 VALUES (1),(2); |
Query OK, 2 rows affected (0.003 sec) |
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
13.1.0-dbg>
|
13.1.0-dbg>DELIMITER $$
|
13.1.0-dbg>CREATE OR REPLACE PROCEDURE ph() BEGIN |
-> EXECUTE IMMEDIATE 'HANDLER t1 OPEN AS h'; |
-> END |
-> $$
|
Query OK, 0 rows affected (0.003 sec) |
|
|
13.1.0-dbg>DELIMITER ;
|
13.1.0-dbg>CALL ph;
|
Query OK, 0 rows affected (0.001 sec) |
|
|
13.1.0-dbg>
|
13.1.0-dbg>HANDLER h READ FIRST; |
+------+ |
| a |
|
+------+ |
| 1 |
|
+------+ |
1 row in set (0.001 sec) |
|
|
13.1.0-dbg>HANDLER h CLOSE; |
Query OK, 0 rows affected (0.000 sec) |
|
|
13.1.0-dbg>
|
Attachments
Issue Links
- relates to
-
MDEV-39518 Allow prepared statements in stored functions in assignment right hand
-
- In Testing
-