Bug #99862 Crash when using search table data function
Submitted: 12 Jun 2020 16:21 Modified: 20 Jun 2020 12:16
Reporter: psy ray Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.17 OS:Ubuntu (18.04)
Assigned to: CPU Architecture:x86 (amd64)

[12 Jun 2020 16:21] psy ray
Since upgrade to MySQL Workbench from 8.0.16 to 8.0.17 in the Schemas, when I right click on any schema and using the Search Table Data, MySQL Workbench crash instantly.

How to repeat:
Go to Schemas tab
Right click on a schema
Select Search table data
In the window select Search using like
Type anything
Select Start search
MySql Workbench is crashing

Query that works in MySQL Workbench 8.0.16 (retrieved from general log)
SELECT `key` , IF(`key` LIKE '%test%' , `key`, '') AS `key` FROM c1_cra_lr.ph68m_akeeba_common WHERE `key` LIKE '%test%' LIMIT 100

Query that crash MySQL Workbench 8.0.17 (retrieved in general log)
SELECT key , IF(key LIKE '%test%' , key, '') AS key FROM c1_cra_lr.ph68m_akeeba_common WHERE key LIKE '%test%' LIMIT 100

There is missing ` in the query that crash workbench

If you copy paste the bad query in the mysql workbench SQL editor, a syntax error is set under the SELECT word.
Error is :
"SELECT" is not valid at this position for this server version, expecting : '('

Suggested fix:
Add missing ` around the key
[13 Jun 2020 7:26] MySQL Verification Team
Thank you for the bug report. I couldn't repeat with version 8.0.20.
[13 Jun 2020 10:56] psy ray
Did MySQL Workbench underline the error if you put it in the quey editor ?
I don't understand why the key identifier is not surrounded with the `.
According to your doc key is a reserved word
[20 Jun 2020 12:16] psy ray
Could you repeat my last comment ?