Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
13.0, 13.1
-
None
-
Can result in unexpected behaviour
-
Q3/2026 Server Maintenance
Description
13.1.0-opt>SET sql_mode=ORACLE; |
Query OK, 0 rows affected (0.000 sec) |
|
|
13.1.0-opt>CREATE TABLE t (id INT, name VARCHAR(100)); |
Query OK, 0 rows affected (0.008 sec) |
|
|
13.1.0-opt>INSERT INTO t VALUES (1,'Test'); |
Query OK, 1 row affected (0.001 sec)
|
|
|
13.1.0-opt>
|
13.1.0-opt>DELIMITER $$
|
13.1.0-opt>CREATE PACKAGE pc AS TYPE wc IS REF CURSOR; END; |
-> $$
|
Query OK, 0 rows affected (0.002 sec) |
|
|
13.1.0-opt>CREATE PROCEDURE pdyn AS c pc.wc; vi INT; vn VARCHAR(100); |
-> BEGIN |
-> OPEN c FOR 'SELECT id, name FROM t'; |
-> FETCH c INTO vi, vn; |
-> SELECT vi, vn; |
-> CLOSE c; |
-> END; |
-> $$
|
ERROR 1221 (HY000): Incorrect usage of c and OPEN..FOR <dynamic string> |
13.1.0-opt>
|
MTR test
DELIMITER $$;
|
CREATE PACKAGE pc AS TYPE wc IS REF CURSOR; END; |
$$
|
CREATE PROCEDURE pdyn AS c pc.wc; vi INT; vn VARCHAR(100); |
BEGIN
|
OPEN c FOR 'SELECT id, name FROM t'; |
FETCH c INTO vi, vn; |
SELECT vi, vn; |
CLOSE c; |
END; |
$$
|
|
|
DELIMITER ;$$
|
Attachments
Issue Links
- blocks
-
MDEV-39587 Package-wide TYPE for variable declarations
-
- Closed
-
- is caused by
-
MDEV-10152 Add support for TYPE .. IS REF CURSOR
-
- Closed
-