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:
None 
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 6:30] Thin Siew Khim
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 ;
[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?