Bug #92333 Wildcards wrongly disallowed in limit to hosts matching
Submitted: 7 Sep 2018 7:44 Modified: 7 Sep 2018 13:07
Reporter: Cedric Counotte Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0, 8.0.12 OS:Microsoft Windows (10)
Assigned to: CPU Architecture:Any

[7 Sep 2018 7:44] Cedric Counotte
It's not possible to enter any hosts match like this:

When doing so, the workbench shows a white cross in a red disc and says (lol):
   % and _ wildcards may be used

Nevertheless, applying such config shows an error message:
   Invalid host specification
   The host specification "...%..." is not valid

BUT, in msql command line it just works fine.

How to repeat:
Try to enter a 'limit to hosts matching' in a user login configuration, such as: host_begin%host_end

It shows an error icon with an ok message and it fails to apply.

Suggested fix:
Show a ok icon and make apply succeed as it should.
[7 Sep 2018 13:07] MySQL Verification Team
Hello Cedric,

Thank you for the report.
Observed this on Win7 with WB 8.0.12.

[28 Jan 2020 21:22] Devin Christensen
Problem persists with WorkBench 8.0.14 running on Windows 10 64 bit.