DECLARE CONTINUE HANDLER FOR SQLEXCEPTION

[Farkas]

Hi,

A heve a dbForge for MySQL 6.0.128, and have a problem when compile procedure for debug with the code place: in last version 6.0.399, have a same error.

something compile a procedure via generete script drop and create, but not debug this.

Code: Select all

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    BEGIN
      GET DIAGNOSTICS CONDITION 1
      @SQLError = MYSQL_ERRNO,
      @SQLMessage = MESSAGE_TEXT,
      @SQLState = RETURNED_SQLSTATE;
      ROLLBACK;
      SELECT @SQLMessage AS sql_message, @SQLError AS sql_error, @SQLState AS slq_state;
    END;

Thanks in advance.

[alexa]

We were able to reproduce this issue and will fix it in one of the next builds of dbForge Studio for MySQL. We will notify you once it's available for downloading.