Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.4
-
Fix Version/s: 10.0.6
-
Component/s: None
-
Labels:None
Description
Including SHUTDOWN in events or procedures results in a parse error:
MariaDB [(none)]> DELIMITER ||
MariaDB [(none)]> DROP EVENT IF EXISTS `test`.`evt_shutdown`;
-> CREATE EVENT `test`.`evt_shutdown`
-> ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 20 SECOND
-> ON COMPLETION PRESERVE
-> ENABLE
-> DO BEGIN
-> SHUTDOWN;
-> END;
-> ||
Query OK, 0 rows affected, 1 warning (0.06 sec)
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 ';
END' at line 6
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> SHUTDOWN;
-> ||
Query OK, 0 rows affected (4.68 sec)
Currently, KB doesn't say that shutdown can't be used in stored programs:
https://kb.askmonty.org/en/shutdown/
That's why i suppose it is a bug - sorry if it isn't
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
