Bug #92605 Error en "GET DIAGNOSTICS CONDITION"
Submitted: 30 Sep 2018 6:09 Modified: 30 Sep 2018 8:56
Reporter: Branny Gonzales Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2.4 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Other (x64)
Tags: WBBugReporter

[30 Sep 2018 6:09] Branny Gonzales
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\branlap\AppData\Roaming\MySQL\Workbench\log\wb.log]

Cuando programo un Stored Procedure y coloco "GET DIAGNOSTICS CONDITION" sale un error con la palabra "CONDITION"

How to repeat:
Este es mi Stored Procedure de prueba:

CREATE PROCEDURE `SP_PRUEBA`()
BEGIN
	DECLARE V_NOMBRE_SP TEXT DEFAULT 'SP_PRUEBA';
    DECLARE V_NUM_CONDITION INT;
    DECLARE V_COD_ERROR CHAR(5);
    DECLARE V_NUM_ERROR INT;
    DECLARE V_MSJ_ERROR TEXT;
    DECLARE V_TIPO_ERROR VARCHAR(45);
    
    DECLARE CONTINUE HANDLER FOR NOT FOUND
    BEGIN
		GET DIAGNOSTICS V_NUM_CONDITION = NUMBER;
        GET DIAGNOSTICS CONDITION V_NUM_CONDITION 
			V_COD_ERROR = RETURNED_SQLSTATE, V_NUM_ERROR = MYSQL_ERRNO, 
			V_MSJ_ERROR = MESSAGE_TEXT;
		
        SET V_TIPO_ERROR = 'NOTFOUND';
        
        CALL SP_REGISTRAR_AUDITORIA(SYSDATE(), V_NOMBRE_SP, V_TIPO_ERROR, V_COD_ERROR, 
        V_NUM_ERROR, V_MSJ_ERROR);
    END;
    
    select ID_USUARIO, LOGIN from usuario;
END
[30 Sep 2018 6:10] Branny Gonzales
Log File

Attachment: wb.log (application/octet-stream, text), 93.14 KiB.

[30 Sep 2018 6:12] Branny Gonzales
Error Image

Attachment: errorCondition.jpg (image/jpeg, text), 183.37 KiB.

[30 Sep 2018 6:24] Branny Gonzales
.
[30 Sep 2018 8:55] MySQL Verification Team
Not error

Attachment: 92605.png (image/png, text), 128.76 KiB.

[30 Sep 2018 8:56] MySQL Verification Team
Thank you for the bug report, not repeatable with version 8.0.12.