Bug #116194 COMMENTS AT THE END OF A STORED PROCEDURE CAUSE FAILURE

• Submitted: 21 Sep 2024 14:22
• Modified: 22 Sep 2024 15:08
• Reporter: ERICK RINGOT
• Status: Verified
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 8.0, 8.0.38
• OS: Any
• CPU Architecture: Any
• Tags: comments, Stored pocedures

[21 Sep 2024 14:22] ERICK RINGOT

Description:
When adding a comment at the end of a stored procedure some trocky things appear:

- If you use Workbench to edit this procedure, a message "unlnown ddl ..." pops up and the procedure is suddenly removed from the database.

- If you did a backup and try to restore a databas containing a procedure with a final comment, the restoration fails.

How to repeat:
For instance:

This fails:
  CREATE DEFINER=`root`@`%` PROCEDURE `myproc`( arg INT ) READS SQL DATA
  BEGIN
  ... your SQL code
  END; -- end of myproc

This works:
  CREATE DEFINER=`root`@`%` PROCEDURE `myproc`( arg INT ) READS SQL DATA
  myproc:BEGIN
  ... your SQL code
  END myproc;

[22 Sep 2024 15:08] MySQL Verification Team

Hello ERICK RINGOT,

Thank you for the report and feedback.
Verified as described. 

regards,
Umesh