Bug #90568 MySQL Workbench crashes whenever typing CHANGE MASTER statement

• Submitted: 23 Apr 2018 11:01
• Modified: 24 Apr 2018 22:02
• Reporter: IGG t
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.11
• OS: Windows (10)
• CPU Architecture: Any
• Tags: crashes, editor

[23 Apr 2018 11:01] IGG t

Description:
Whenever I try and type a CHANGE MASTER STATEMENT, MySQL Workbench crashes. I have tried this with various versions of MySQL, and the result is always the same. Type a few characters, and then "MySQL Workbench has stopped working"

The exact point it crashes varies, but it is normally around about the second entry. It makes no difference which order you type the items in. 

I haven't had the problem with any other statement.  

You can work round it by typing all the options first, and then going back and adding "CHANGE MASTER TO" afterwards, or type it into a text editor and copy paste. The command itself runs fine once you have it all there.

How to repeat:
Open a SQL Editor Window, and start typing:

CHANGE MASTER TO 
MASTER_HOST = '127.0.0.1, 
MASTER_PORT = 33

and then it crashes. 

Suggested fix:
change it so that you can type a full CHANGE MASTER STATEMENT without crashing.

[23 Apr 2018 11:54] Chiranjeevi Battula

Hello IGG,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 8.0.11 version.

Thanks,
Chiranjeevi.

[23 Apr 2018 11:55] Chiranjeevi Battula

Screenshot

Attachment: Bug_90568.PNG (image/png, text), 81.08 KiB.

[24 Apr 2018 22:02] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

MySQL Workbench stopped working when the CHANGE MASTER TO statement was
typed directly into the SQL editor, followed by options.

Thank you for the bug report.