Bug #97162 Workbench locks when editing a specific query line
Submitted: 9 Oct 2019 14:57 Modified: 14 Nov 2019 17:59
Reporter: Jorge Rojas Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.17 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any

[9 Oct 2019 14:57] Jorge Rojas 
Description:
I am editing a query. Every time I add a number on a specific position it locks up with high cpu usage.

It is reproducible 100% of the time.

How to repeat:
Use the provided query on private comment and edit line 15, add "/2" after the single closing parenthesis (under the long line). It locks every time.

From:
mod(b.t2345,2)
)

To:
mod(b.t2345,2)
)/2

I have pictures step-by-step.
[9 Oct 2019 14:59] Jorge Rojas 
Step 1

Attachment: MSQL01.png (image/png, text), 39.43 KiB.
[9 Oct 2019 14:59] Jorge Rojas 
Step 2

Attachment: MSQL02.png (image/png, text), 39.94 KiB.
[9 Oct 2019 15:00] Jorge Rojas 
Step 3

Attachment: MSQL03.png (image/png, text), 38.13 KiB.
[9 Oct 2019 15:00] Jorge Rojas 
Step 4

Attachment: MSQL04.png (image/png, text), 106.40 KiB.
[9 Oct 2019 15:01] Jorge Rojas 
Bugy file

Attachment: MySql Bug.sql (application/octet-stream, text), 1.99 KiB.
[29 Oct 2019 5:20] MySQL Verification Team 
Hello Jorge Rojas,

Thank you for the bug report.
Could you please provide the table structure for reported issue? Thank you.

Regards,
Ashwini Patil
[12 Nov 2019 14:53] Jorge Rojas 
Hello,

Here I include the create statements.

Thank you!

CREATE TABLE `turno_diario_real` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dia` date NOT NULL,
  `usuario` varchar(20) NOT NULL,
  `turno` varchar(30) DEFAULT NULL,
  `observacion` varchar(100) NOT NULL,
  `supervisor` varchar(20) NOT NULL,
  `permiso` int(10) unsigned NOT NULL,
  `tipo_cambio` varchar(50) DEFAULT NULL,
  `dia_cambio` datetime DEFAULT NULL,
  `turno_cambio` varchar(30) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dia` (`dia`),
  KEY `idx_turno_diario_real_usuario` (`usuario`),
  KEY `idx_turno_diario_real_turno` (`turno`)
) ENGINE=MyISAM AUTO_INCREMENT=1481561 DEFAULT CHARSET=utf8;
CREATE TABLE `def_turnos` (
  `TURNO` varchar(30) NOT NULL,
  `JORNADA` varchar(11) NOT NULL,
  `MANANA` varchar(11) NOT NULL,
  `COLACION` varchar(11) NOT NULL,
  `TARDE` varchar(11) NOT NULL,
  `DESCANSOM` varchar(11) NOT NULL,
  `DESCANSOT` varchar(11) NOT NULL,
  `t0000` varchar(2) NOT NULL DEFAULT '??',
  `t0015` varchar(2) NOT NULL DEFAULT '??',
  `t0030` varchar(2) NOT NULL DEFAULT '??',
  `t0045` varchar(2) NOT NULL DEFAULT '??',
  `t0100` varchar(2) NOT NULL DEFAULT '??',
  `t0115` varchar(2) NOT NULL DEFAULT '??',
  `t0130` varchar(2) NOT NULL DEFAULT '??',
  `t0145` varchar(2) NOT NULL DEFAULT '??',
  `t0200` varchar(2) NOT NULL DEFAULT '??',
  `t0215` varchar(2) NOT NULL DEFAULT '??',
  `t0230` varchar(2) NOT NULL DEFAULT '??',
  `t0245` varchar(2) NOT NULL DEFAULT '??',
  `t0300` varchar(2) NOT NULL DEFAULT '??',
  `t0315` varchar(2) NOT NULL DEFAULT '??',
  `t0330` varchar(2) NOT NULL DEFAULT '??',
  `t0345` varchar(2) NOT NULL DEFAULT '??',
  `t0400` varchar(2) NOT NULL DEFAULT '??',
  `t0415` varchar(2) NOT NULL DEFAULT '??',
  `t0430` varchar(2) NOT NULL DEFAULT '??',
  `t0445` varchar(2) NOT NULL DEFAULT '??',
  `t0500` varchar(2) NOT NULL DEFAULT '??',
  `t0515` varchar(2) NOT NULL DEFAULT '??',
  `t0530` varchar(2) NOT NULL DEFAULT '??',
  `t0545` varchar(2) NOT NULL DEFAULT '??',
  `t0600` varchar(2) NOT NULL DEFAULT '??',
  `t0615` varchar(2) NOT NULL DEFAULT '??',
  `t0630` varchar(2) NOT NULL DEFAULT '??',
  `t0645` varchar(2) NOT NULL DEFAULT '??',
  `t0700` varchar(2) NOT NULL DEFAULT '??',
  `t0715` varchar(2) NOT NULL DEFAULT '??',
  `t0730` varchar(2) NOT NULL DEFAULT '??',
  `t0745` varchar(2) NOT NULL DEFAULT '??',
  `t0800` varchar(2) NOT NULL,
  `t0815` varchar(2) NOT NULL DEFAULT '??',
  `t0830` varchar(2) NOT NULL,
  `t0845` varchar(2) NOT NULL DEFAULT '??',
  `t0900` varchar(2) NOT NULL,
  `t0915` varchar(2) NOT NULL DEFAULT '??',
  `t0930` varchar(2) NOT NULL,
  `t0945` varchar(2) NOT NULL DEFAULT '??',
  `t1000` varchar(2) NOT NULL,
  `t1015` varchar(2) NOT NULL DEFAULT '??',
  `t1030` varchar(2) NOT NULL,
  `t1045` varchar(2) NOT NULL DEFAULT '??',
  `t1100` varchar(2) NOT NULL,
  `t1115` varchar(2) NOT NULL DEFAULT '??',
  `t1130` varchar(2) NOT NULL,
  `t1145` varchar(2) NOT NULL DEFAULT '??',
  `t1200` varchar(2) NOT NULL,
  `t1215` varchar(2) NOT NULL DEFAULT '??',
  `t1230` varchar(2) NOT NULL,
  `t1245` varchar(2) NOT NULL DEFAULT '??',
  `t1300` varchar(2) NOT NULL,
  `t1315` varchar(2) NOT NULL DEFAULT '??',
  `t1330` varchar(2) NOT NULL,
  `t1345` varchar(2) NOT NULL DEFAULT '??',
  `t1400` varchar(2) NOT NULL,
  `t1415` varchar(2) NOT NULL DEFAULT '??',
  `t1430` varchar(2) NOT NULL,
  `t1445` varchar(2) NOT NULL DEFAULT '??',
  `t1500` varchar(2) NOT NULL,
  `t1515` varchar(2) NOT NULL DEFAULT '??',
  `t1530` varchar(2) NOT NULL,
  `t1545` varchar(2) NOT NULL DEFAULT '??',
  `t1600` varchar(2) NOT NULL,
  `t1615` varchar(2) NOT NULL DEFAULT '??',
  `t1630` varchar(2) NOT NULL,
  `t1645` varchar(2) NOT NULL DEFAULT '??',
  `t1700` varchar(2) NOT NULL,
  `t1715` varchar(2) NOT NULL DEFAULT '??',
  `t1730` varchar(2) NOT NULL,
  `t1745` varchar(2) NOT NULL DEFAULT '??',
  `t1800` varchar(2) NOT NULL,
  `t1815` varchar(2) NOT NULL DEFAULT '??',
  `t1830` varchar(2) NOT NULL,
  `t1845` varchar(2) NOT NULL DEFAULT '??',
  `t1900` varchar(2) NOT NULL,
  `t1915` varchar(2) NOT NULL DEFAULT '??',
  `t1930` varchar(2) NOT NULL,
  `t1945` varchar(2) NOT NULL DEFAULT '??',
  `t2000` varchar(2) NOT NULL,
  `t2015` varchar(2) NOT NULL DEFAULT '??',
  `t2030` varchar(2) NOT NULL,
  `t2045` varchar(2) NOT NULL DEFAULT '??',
  `t2100` varchar(2) NOT NULL,
  `t2115` varchar(2) NOT NULL DEFAULT '??',
  `t2130` varchar(2) NOT NULL,
  `t2145` varchar(2) NOT NULL DEFAULT '??',
  `t2200` varchar(2) NOT NULL,
  `t2215` varchar(2) NOT NULL DEFAULT '??',
  `t2230` varchar(2) NOT NULL,
  `t2245` varchar(2) NOT NULL DEFAULT '??',
  `t2300` varchar(2) NOT NULL,
  `t2315` varchar(2) NOT NULL DEFAULT '??',
  `t2330` varchar(2) NOT NULL,
  `t2345` varchar(2) NOT NULL DEFAULT '??',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supervisor` varchar(20) DEFAULT NULL,
  `tipo_cambio` varchar(20) DEFAULT NULL,
  `dia_cambio` datetime DEFAULT NULL,
  PRIMARY KEY (`TURNO`,`JORNADA`,`MANANA`,`COLACION`,`TARDE`,`DESCANSOM`,`DESCANSOT`),
  KEY `Index_2` (`id`),
  KEY `idx_def_turnos_TURNO` (`TURNO`)
) ENGINE=MyISAM AUTO_INCREMENT=24704 DEFAULT CHARSET=utf8;
CREATE TABLE `ejecutivos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `usuario` varchar(20) NOT NULL,
  `Nivel` varchar(30) NOT NULL,
  `usuario_cic` varchar(20) NOT NULL,
  `Rol` varchar(20) DEFAULT NULL,
  `supervisor` varchar(30) DEFAULT NULL,
  `tipo_cambio` varchar(30) DEFAULT NULL,
  `dia_cambio` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ejecutivos_usuario` (`usuario`)
) ENGINE=MyISAM AUTO_INCREMENT=2313 DEFAULT CHARSET=utf8;
[14 Nov 2019 5:42] MySQL Verification Team 
Hello Jorge Rojas,

Thank you for the report.
IMHO this is duplicate of Bug #94094, please see  Bug #94094 but since Bug #94094 is already marked as duplicate of Bug #92015 and hence marking Bug #97162 as duplicate of Bug #92015 instead.

Regards,
Ashwini Patil
[14 Nov 2019 17:59] Jorge Rojas 
Hello Ashwini,

My problem is not about the autocomplete not working, is about the application stopping working and never coming back (a deadlock somewhere) and having to finalize the unresponsive process manually by using task manager.

Are you sure is the same issue?

Regards,

Jorge
[15 Nov 2019 4:54] MySQL Verification Team 
Hello Jorge Rojas,

Even if you feel that your issue is somewhat different, the resolution is likely to be the same.

Regards,
Ashwini Patil