Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6.4, 10.3(EOL), 10.4(EOL), 10.5, 10.7(EOL), 10.8(EOL)
-
None
-
10.6.4-1-MariaDB-enterprise-log
Description
A dump was taken on a system that has PL/SQL packages with the below version and command.
-- MariaDB dump 10.19 Distrib 10.6.4-1-MariaDB, for Linux (x86_64) |
mysqldump my_schema_name -R -e --triggers --single-transaction
|
The dump contains the following line:
/*!50003 DROP PACKAGE IF EXISTS `SomePackageName` */; |
Loading the dump into a blank schema on another MariaDB server of the same version and default config (incl. default SQL mode) fails:
ERROR 1064 (42000) at line 5745: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PACKAGE IF EXISTS `SomePackageName` */' at line 1
|
The dump seems to set up the proper mode for most of what is does, like CREATE PACKAGE statements - but it fails on the above comment. Here is a line form the dump which sets the SQL mode to include Oracle (found multiple times inside the dump).
/*!50003 SET sql_mode = 'PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT' */ ; |