| Bug #84466 | Error Parsing DDL for ... | ||
|---|---|---|---|
| Submitted: | 11 Jan 2017 6:30 | Modified: | 27 Mar 2018 15:31 |
| Reporter: | Thin Siew Khim | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 6.3.8 CE (winx64) | OS: | Microsoft Windows (Windows 7) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | DELIMITER, Error Parsing DDL, stored procedure, workbench | ||
[11 Jan 2017 7:00]
MySQL Verification Team
Hello Khim Thin, Thank you for the report. Observed this on Win7 with WB 6.3.8. Thanks, Umesh
[27 Mar 2018 15:31]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0.11 release, and here's the changelog entry: Altering a stored procedure that contained double dollar-sign characters ($$) as part of a variable name produced an error parsing DDL message. Thank you for the bug report.
[9 Oct 2018 14:28]
Sam Abboushi
Am still experiencing this problem using WorkBench 8.0.12. Regression?
Description: Encounter "Error Parsing DDL for ..." when trying to alter a stored procedure that contains a variable name with double dollar sign "$$". I believe it is due to the default delimiter of MySQL Workbench is "$$" Although I have changed the delimiter to "//" at the menu "Edit->Preferences->General Editors->Non-Standard SQL Delimiter:", but still encounter the problem. This is not happen at the previous version 6.3.4.0 build 828 (64bit) How to repeat: Try to alter any stored procedure that contains any variable name with double dollar sign "$$" Example, create a sp_Test stored procedure below and try to alter with the workbench of the version reported. DELIMITER // CREATE PROCEDURE `sp_Test`() begin declare $$var1 int; set $$var1:=1; select $$var1; end// DELIMITER ;