Details
-
Bug
-
Status: In Testing (View Workflow)
-
Major
-
Resolution: Unresolved
-
13.0
-
None
-
Q1/2026 Server Development
Description
Some data types allow non-relevant attributes in variable declarations.
The following scripts work without problems. The expected behavior would be to raise an error.
RECORD
SET sql_mode=ORACLE; |
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p1 AS |
TYPE rec0_t IS RECORD (a INT); |
r00 rec0_t (10);
|
r01 rec0_t (10,2);
|
r2 rec0_t REF_SYSTEM_ID=101;
|
BEGIN
|
NULL; |
END; |
$$
|
DELIMITER ;
|
Associative arrays
SET sql_mode=ORACLE; |
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p1 AS |
TYPE assoc0_t IS TABLE OF INT INDEX BY INT; |
r00 assoc0_t (10);
|
r01 assoc0_t (10,2);
|
r2 assoc0_t REF_SYSTEM_ID=101;
|
BEGIN
|
NULL; |
END; |
$$
|
DELIMITER ;
|
SYS_REFCURSOR
SET sql_mode=ORACLE; |
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p1 AS |
r00 SYS_REFCURSOR (10);
|
r01 SYS_REFCURSOR (10,2);
|
r2 SYS_REFCURSOR REF_SYSTEM_ID=101;
|
BEGIN
|
NULL; |
END; |
$$
|
DELIMITER ;
|
Attachments
Issue Links
- blocks
-
MDEV-10152 Add support for TYPE .. IS REF CURSOR
-
- In Testing
-
- relates to
-
MDEV-38768 RECORD in routine parameters and function RETURN
-
- In Testing
-