Bug #79247 Faulty syntax with "-" in schema name and table starting with number

• Submitted: 12 Nov 2015 9:42
• Modified: 9 Dec 2015 7:13
• Reporter: uğur mirza zeyrek
• Status: Closed
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 6.3.5
• OS: Any
• CPU Architecture: Any

[12 Nov 2015 9:42] uğur mirza zeyrek

Description:
SELECT * FROM lazyoracleportal.0UU60c51_abb_blog_likes; 

there is a error warning but works

SELECT * FROM `lazy-oracleportal`.0UU60c51_abb_blog_likes; 

Both warning and not working! It has to be something like this:

SELECT * FROM `lazy-oracleportal`.'0UU60c51_abb_blog_likes'; 

How to repeat:
Create a schema contains dash "-".

Create a table which has a name starting with number like "0".

Click on the select 100 rows. 

Suggested fix:
SELECT * FROM `lazy-oracleportal`.'0UU60c51_abb_blog_likes';

[12 Nov 2015 9:43] uğur mirza zeyrek

Bug confirmed on Mac OS and Windows 10

[12 Nov 2015 10:38] MySQL Verification Team

Thank you for the bug report. Verified as described.

[13 Nov 2015 10:04] Mike Lischke

SELECT * FROM `lazy-oracleportal`.'0UU60c51_abb_blog_likes';

cannot work, as strings are not allowed as identifiers. Both parts must use back ticks to make it work.

Identifiers can have a leading digit, but are discuraged. You should consider using identifiers that start with a letter.

[13 Nov 2015 10:05] Mike Lischke

Forgot to mention: the dash in the schema name has nothing to do with the bug, which is that WB does not recognize an identifier with a leading digit if it is preceded by a dot. Just add a space char after the dot to see it work as expected.

[9 Dec 2015 4:30] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.6 release, and here's the changelog entry:

Workbench did not recognize identifiers with a leading digit if it was
preceded by a dot.

Thank you for the bug report.

[9 Dec 2015 7:13] uğur mirza zeyrek

Thanks for the quick fix.