MySQL Workbench crashes on 8.0.29 when running full database search

MySQL & MariaDB Percona Server for MySQL 8.0
#1

Used to be able to search all tables in the database using MySQL Workbench on 5.7 version, but now it crashes with the following error in the logs:

17:10:58 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘rows LIKE ‘%test%’ , rows, ‘’) AS rows FROM WHERE create’ at line 1
17:10:58 [ERR][ GRTDispatcher]: worker: task ‘Search’ has failed with error:.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘rows LIKE ‘%test%’ , rows, ‘’) AS rows FROM

WHERE create’ at line 1

Anyone else having this issue?

1 Like
#2

You said this used to work on MySQL 5.7, but now doesn’t. I’m guessing you upgraded to MySQL 8? Did you also upgrade to the latest Workbench? If you did, then you probably need to file a bug with MySQL regarding broken workbench software.

1 Like
#3

Hi Matt, thank you for your reply. I did upgrade to MySQL 8, you are right. I tried the latest versions of the Workbench and several previous versions (same issue). Was hoping to find out that it wasn’t a bug in workbench that went unfixed in several versions.

Thanks again

1 Like
#4

Submitted here: MySQL Bugs: #107983: MySQL Workbench crashes on 8.0.29 when running full database search

1 Like