| 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: | |
| 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: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.

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