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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.12, 8.0.27 OS:MacOS (10.13.6)
Assigned to: CPU Architecture:x86 (2.9 GHz Intel Core i9)

[6 Sep 2018 22:48] S R
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

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

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