Bug #83415 syntax errors where none exist ()

• Submitted: 17 Oct 2016 22:05
• Modified: 4 Nov 2016 19:16
• Reporter: Guillermo Telefonica
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 6.3.7
• OS: Windows (Server 2012 R2)
• CPU Architecture: Any
• Tags: GET DIAGNOSTICS, handler, PROCEDURE, SqlException

[17 Oct 2016 22:05] Guillermo Telefonica

Description:
Has an error highlight under GET, with a tooltip of 

Syntax error: Unexpected 'GET' (identifier).

My sintaxis:

create procedure creaProcesoSistema(
							IN IN_nombre_proceso varchar(100), IN IN_uid_proceso varchar(100),
							IN IN_servidor_ejecucion varchar(30), IN IN_usuario_ejecucion varchar(30),
							IN IN_comando_ejecucion varchar(1000), IN IN_requiere_output boolean,
							IN IN_ruta_deposito_output varchar(300)) begin

 -- Declare variables to hold diagnostics area information
  DECLARE codigo CHAR(5) DEFAULT '00000';
  DECLARE msg TEXT;
  DECLARE result TEXT;
  -- Declare exception handler for failed insert
 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
 begin
	GET DIAGNOSTICS CONDITION 1
	codigo = MYSQL_ERRNO, msg = MESSAGE_TEXT;
 end;

but same syntax in sql editor (workbench), do not have errors:

create procedure creaProcesoSistema(
							IN IN_nombre_proceso varchar(100), IN IN_uid_proceso varchar(100),
							IN IN_servidor_ejecucion varchar(30), IN IN_usuario_ejecucion varchar(30),
							IN IN_comando_ejecucion varchar(1000), IN IN_requiere_output boolean,
							IN IN_ruta_deposito_output varchar(300)) begin

 -- Declare variables to hold diagnostics area information
  DECLARE codigo CHAR(5) DEFAULT '00000';
  DECLARE msg TEXT;
  DECLARE result TEXT;
  -- Declare exception handler for failed insert
 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 
 BEGIN
	 GET CURRENT DIAGNOSTICS CONDITION 1
    codigo = MYSQL_ERRNO,
    msg = MESSAGE_TEXT;
 END;

How to repeat:
N/A

[17 Oct 2016 22:08] Guillermo Telefonica

Error in modeling

Attachment: modeling.PNG (image/png, text), 13.54 KiB.

[17 Oct 2016 22:12] Guillermo Telefonica

syntax in sql editor, without errors

Attachment: SQLEditor.PNG (image/png, text), 11.69 KiB.

[18 Oct 2016 9:24] MySQL Verification Team

Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=83395.

[18 Oct 2016 15:46] Guillermo Telefonica

Hi Miguel Solorzano, thanks very much.

I apply the solution of differents cases but my problem not fix, other idea?

regards

[18 Oct 2016 19:30] Guillermo Telefonica

The problem continues to synchronize the model

Attachment: SincModelWithErrors.PNG (image/png, text), 6.58 KiB.

[4 Nov 2016 19:16] Guillermo Telefonica

The problem fix with version 6.3.8

Regards,