Bug #64869 Workbench don't put quotes for numeric only schema
Submitted: 4 Apr 2012 15:34 Modified: 13 Jun 2013 20:05
Reporter: pedro oriani Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.3.38 OS:Any
Assigned to: CPU Architecture:Any

[4 Apr 2012 15:34] pedro oriani
Select on Object Browser don't put quotes in schema name

How to repeat:
With a given schema with numeric only name like 123,
if with right mouse click on object browser I choose "Select"
Workbench generates a query like
SELECT * FROM 123.mytable
instead of

SELECT * FROM "123".mytable
[4 Apr 2012 15:48] Valeriy Kravchuk
Thank you for the bug report. Verified on Mac OS X 10.5.x.
[13 Jun 2013 20:05] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

The quoting logic was updated to also consider that digit only identifiers
should be quoted.

Thank you for the bug report.