Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.25
-
None
-
Ubuntu focal
mariadb-client-10.3: /usr/bin/mysqldump
kgn@mysql1:~$ apt-cache policy mariadb-client-10.3
mariadb-client-10.3:
Installed: 1:10.3.25+maria~focal
Candidate: 1:10.3.25+maria~focal
Version table:
*** 1:10.3.25+maria~focal 100
100 /var/lib/dpkg/status
Description
Hi,
When dumping a database with triggers for a customer I got the current output:
DELIMITER ;;
|
/*!50003 CREATE*/ /*!50017 DEFINER=`mydb`@`%` */ /*!50003 TRIGGER trigger_LabelsUsers_insert_before BEFORE INSERT ON LabelsUsers FOR EACH ROW SET NEW.LabelsUsersID2 = MD5(CONCAT(NOW(),RAND())); */;; |
DELIMITER ;
|
When restoring or running it manually I get:
ERROR 1064 (42000): 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 '*/' at line 1
|
If I remove the last ; so the query looks like this:
/*!50003 CREATE*/ /*!50017 DEFINER=`mydb`@`%` */ /*!50003 TRIGGER trigger_LabelsUsers_insert_before BEFORE INSERT ON LabelsUsers FOR EACH ROW SET NEW.LabelsUsersID2 = MD5(CONCAT(NOW(),RAND())) */;; |
then it works.