Bug #91901 MySQL Workbench hangs while copying text from Chrome confirm();

• Submitted: 5 Aug 2018 16:53
• Modified: 6 Aug 2018 12:38
• Reporter: Moshe Lampert
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.12
• OS: Windows (10)
• CPU Architecture: Any
• Tags: copy/paste, workbench

[5 Aug 2018 16:53] Moshe Lampert

Description:
long SQL queries with autocomplete and text copied from Chrome make the WB and  Chrome to hang.

How to repeat:
write a long SQL query on MySQL Query Editor 
for example:

create view  prepaid_clients_active as 
select prepaid_clients.*, datediff(c_lastdate + interval p_days_type day, now()) as days, datediff(c_lastdate + interval p_days_type day, now()) >0 as active  from prepaid_clients,  prepaid_programs where c_lastprogram=p_id and c_ /* this to wait to autocomplete*/

open Chrome, Hit F12

paste on console: prompt(1,"asdasd");

copy the text from the textbox on the message

try to paste (or just type) on WB, when the autocomplete is in use.

WB crashed.

[5 Aug 2018 18:22] MySQL Verification Team

Thank you for the bug report. I couldn't repeat or misunderstood something from your instructions, please attach screenshot using the Files tab of each step. Thanks in advance.

[5 Aug 2018 20:00] Moshe Lampert

call stack from Visual Studio debugger (without PDF files):

>	antlr4-runtime.dll!00007fff6b34da80()	Unknown
 	antlr4-runtime.dll!00007fff6b394ffe()	Unknown
 	antlr4-runtime.dll!00007fff6b3934db()	Unknown
 	antlr4-runtime.dll!00007fff6b3606cd()	Unknown
 	parsers.dll!00007fff4c6e5a21()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e1acd()	Unknown
 	parsers.dll!00007fff4c6f2fbb()	Unknown
 	parsers.dll!00007fff4c6f77b3()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7065d()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7075e()	Unknown
 	wbpublic.be.dll!00007fff598ad1f0()	Unknown
 	wbpublic.be.dll!00007fff598a9d36()	Unknown
 	wbpublic.be.dll!00007fff59782a2b()	Unknown
 	wbpublic.be.dll!00007fff597c40aa()	Unknown
 	wbpublic.be.dll!00007fff597c2ff3()	Unknown
 	wbpublic.be.dll!00007fff597be9e4()	Unknown
 	wbpublic.be.dll!00007fff59802158()	Unknown
 	wbprivate.be.dll!00007fff585cecbe()	Unknown

play, and pause again:

>	parsers.dll!00007fff4c81efed()	Unknown
 	parsers.dll!00007fff4c78f124()	Unknown
 	parsers.dll!00007fff4c6e04bf()	Unknown
 	parsers.dll!00007fff4c6def01()	Unknown
 	parsers.dll!00007fff4c6dceb2()	Unknown
 	parsers.dll!00007fff4c6e57d4()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e1acd()	Unknown
 	parsers.dll!00007fff4c6f2fbb()	Unknown
 	parsers.dll!00007fff4c6f77b3()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7065d()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7075e()	Unknown
 	wbpublic.be.dll!00007fff598ad1f0()	Unknown
 	wbpublic.be.dll!00007fff598a9d36()	Unknown
 	wbpublic.be.dll!00007fff59782a2b()	Unknown
 	wbpublic.be.dll!00007fff597c40aa()	Unknown
 	wbpublic.be.dll!00007fff597c2ff3()	Unknown
 	wbpublic.be.dll!00007fff597be9e4()	Unknown
 	wbpublic.be.dll!00007fff59802158()	Unknown
 	wbprivate.be.dll!00007fff585cecbe()	Unknown

[5 Aug 2018 20:00] Moshe Lampert

call stack from Visual Studio debugger (without PDF files):

>	antlr4-runtime.dll!00007fff6b34da80()	Unknown
 	antlr4-runtime.dll!00007fff6b394ffe()	Unknown
 	antlr4-runtime.dll!00007fff6b3934db()	Unknown
 	antlr4-runtime.dll!00007fff6b3606cd()	Unknown
 	parsers.dll!00007fff4c6e5a21()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e1acd()	Unknown
 	parsers.dll!00007fff4c6f2fbb()	Unknown
 	parsers.dll!00007fff4c6f77b3()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7065d()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7075e()	Unknown
 	wbpublic.be.dll!00007fff598ad1f0()	Unknown
 	wbpublic.be.dll!00007fff598a9d36()	Unknown
 	wbpublic.be.dll!00007fff59782a2b()	Unknown
 	wbpublic.be.dll!00007fff597c40aa()	Unknown
 	wbpublic.be.dll!00007fff597c2ff3()	Unknown
 	wbpublic.be.dll!00007fff597be9e4()	Unknown
 	wbpublic.be.dll!00007fff59802158()	Unknown
 	wbprivate.be.dll!00007fff585cecbe()	Unknown

play, and pause again:

>	parsers.dll!00007fff4c81efed()	Unknown
 	parsers.dll!00007fff4c78f124()	Unknown
 	parsers.dll!00007fff4c6e04bf()	Unknown
 	parsers.dll!00007fff4c6def01()	Unknown
 	parsers.dll!00007fff4c6dceb2()	Unknown
 	parsers.dll!00007fff4c6e57d4()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e5f9f()	Unknown
 	parsers.dll!00007fff4c6e1acd()	Unknown
 	parsers.dll!00007fff4c6f2fbb()	Unknown
 	parsers.dll!00007fff4c6f77b3()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7065d()	Unknown
 	db.mysql.parser.grt.dll!00007fff5bd7075e()	Unknown
 	wbpublic.be.dll!00007fff598ad1f0()	Unknown
 	wbpublic.be.dll!00007fff598a9d36()	Unknown
 	wbpublic.be.dll!00007fff59782a2b()	Unknown
 	wbpublic.be.dll!00007fff597c40aa()	Unknown
 	wbpublic.be.dll!00007fff597c2ff3()	Unknown
 	wbpublic.be.dll!00007fff597be9e4()	Unknown
 	wbpublic.be.dll!00007fff59802158()	Unknown
 	wbprivate.be.dll!00007fff585cecbe()	Unknown

[6 Aug 2018 12:38] Chiranjeevi Battula

Hello Moshe Lampert,

Thank you for the feedback.
I could not repeat the issue at our end using with MySQL Workbench 8.0.12 version on Windows 10.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.