Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.1
-
None
-
Not for Release Notes
-
Q3/2026 Server Development
Description
SET sql_mode=ORACLE; |
|
|
DELIMITER $$
|
CREATE PACKAGE pkg AS TYPE rec IS RECORD (a INT); END; |
$$
|
DELIMITER ;
|
mariadb-dump restore error
-- an EVENT using the package TYPE is accepted:
|
DELIMITER $$
|
CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO DECLARE v pkg.rec; BEGIN NULL; END; |
$$
|
DELIMITER ;restore error info
|
--------------
|
/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`localhost`*/ /*!50106 EVENT `ev` ON SCHEDULE EVERY 1 HOUR STARTS '2026-08-07 16:44:08' ON COMPLETION NOT PRESERVE ENABLE DO DECLARE v pkg.rec; BEGIN NULL; END |
*/
|
--------------
|
|
|
ERROR 4161 (HY000) at line 43 in file: 'i10.sql': Unknown data type: '`pkg`.`rec`' |
Query OK, 0 rows affected (0.000 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-39587 Package-wide TYPE for variable declarations
-
- Stalled
-