Page 1 of 1

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION

Posted: Mon 19 Aug 2013 14:41
by 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.

Re: DECLARE CONTINUE HANDLER FOR SQLEXCEPTION

Posted: Tue 20 Aug 2013 09:46
by 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.