Bug #92329 Query syntax checker causes hang with large queries

• Submitted: 6 Sep 2018 22:48
• Modified: 11 Sep 2018 7:41
• Reporter: S R
• Status: Won't Fix
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.12, 8.0.27
• OS: MacOS (10.13.6)
• CPU Architecture: x86 (2.9 GHz Intel Core i9)

[6 Sep 2018 22:48] S R

Description:
I've got a large query open in a query tab. This one has 3 joins and a complex boolean WHERE clause of 90 lines (once prettified).

Any edits much over 20 lines into the WHERE clause cause a lock up that gets significantly worse the further down in the query I'm working. Even adding a comment down at the bottom causes this top-of-the-line brand new macbook to spike to 100% on the processor and mysql to never return from the pinwheel of doom. Force quit is my only option.

How to repeat:
Try to modify a very large, complex query, especially near the bottom, with code completion enabled.

Suggested fix:
Code completion should not kill workbench when working on a large query.

Workaround is, of course, to disable code completion.

[11 Sep 2018 7:41] MySQL Verification Team

Hello!

Thank you for the report!
This is even observed on Win7 instance.

regards,
Umesh

[2 Nov 2018 5:27] Ian Kemp

This issue occurs on all platforms (I'm on Windows 10). It has been around since at least 8.0.11.

[19 Nov 2018 8:15] MySQL Verification Team

https://bugs.mysql.com/bug.php?id=93062 marked as duplicate of this one.

[4 Mar 2022 6:39] MySQL Verification Team

Bug #106579 marked as duplicate of this one.

[14 Sep 18:04] Omer Barnir

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.