Bug #70232 "Search table data" function fails
Submitted: 3 Sep 2013 21:28 Modified: 11 Feb 2014 2:28
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.0.6 OS:Any
Assigned to: Marcin Szalowicz CPU Architecture:Any

[3 Sep 2013 21:28] Todd Farmer
While trying to search table data across multiple schemas, I receive the following 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'table = 'host+cache', table, ''_ AS table, IF(bucketingSql = 'host_cach', bu' at line 1.

How to repeat:
Select multiple schemas, right-click, select "Search Table Data", enter search term.

Suggested fix:
No error.
[7 Feb 2014 21:27] Rafael Antonio Bedoy Torres
Posted by developer:
Fixed, checked using
[11 Feb 2014 2:28] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

The "Search Table Data" tool would fail to function when used to search
multiple schemas.

Thank you for the bug report.