Bug #115621 SQL with LIKE containing % at begin and end results in a crash of workbench
Submitted: 17 Jul 2024 8:19 Modified: 17 Aug 2024 12:48
Reporter: Stefan Scheid Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.31 OS:MacOS (Sonoma 14.5)
Assigned to: MySQL Verification Team CPU Architecture:ARM
Tags: WBBugReporter

[17 Jul 2024 8:19] Stefan Scheid 
Description:
SQL with LIKE containing % at begin and end results in a crash of workbench

How to repeat:
run statement with like wildcard having "%" both at begining and end 
crash "works" :-D with any VARCHAR field on any table

[2, 10:07:22] SELECT * FROM amadeedev.databasechangelog
where description like '%localeSelector%'
LIMIT 0, 50000
: Running...
[17 Jul 2024 12:48] MySQL Verification Team 
Hello Stefan,

Thank you for the bug report.
Which OS are you using? The attached log file says "OS detection failed, skipping OS support check. OS string: 'unknown'"

Also, MySQL Workbench 8.0.31 is quite an old version. Please upgrade to latest version and report us back if issue persist even in latest version along with log file. Thank you.

Regards,
Ashwini Patil
[18 Aug 2024 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".