Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40686

Event using a package-defined type is silently lost during mariadb-dump / restore

    XMLWordPrintable

Details

    • 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

          Activity

            People

              bar Alexander Barkov
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 4h 32m Original Estimate - 4h 32m
                  4h 32m
                  Remaining:
                  Time Spent - 0.5h Remaining Estimate - 4h 32m
                  4h 32m
                  Logged:
                  Time Spent - 0.5h Remaining Estimate - 4h 32m
                  0.5h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.