MySQL Bugs: #99862: Crash when using search table data function

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:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.17	OS:	Ubuntu (18.04)
Assigned to:		CPU Architecture:	x86 (amd64)

Description:
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

Thank you for the bug report. I couldn't repeat with version 8.0.20.

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
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-K

Could you repeat my last comment ?