MySQL Bugs: #107735: Select Rows feature does not handle table names starting with number err 1064

Bug #107735	Select Rows feature does not handle table names starting with number err 1064
Submitted:	2 Jul 2022 13:13	Modified:	3 Jul 2022 7:49
Reporter:	Julian Noble	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0, 8.0.29	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	1064, quoting, SQL Syntax, tablename

Description:
Right clicking on a table and selecting 'Select Rows' generates a SELECT query which does not quote the table name - but for tables named such as 1etc
the query window displays Error Code: 1064 stating there is an error in the SQL syntax

The tooltip on hovering over the SQL says
".1" is not valid at this position, expecting EOF, ";"

How to repeat:
Create a table named such that it starts with a number
e.g
1etc
0_data

Right click on table name and 'Select Rows'

Generated query is not usable without editing

(note that some products e.g frontaccounting generate tables named with numeric prefixes 0_  1_ etc)

Suggested fix:
Manually quoting the table name works - but MySQL workbench should either do this automatically - or else not mark it as an error(?)

According to the MySQL reference manual:
"Identifiers may begin with a digit but unless quoted may not consist solely of digits."

Tables such as 1etc should theoretically not require quoting - so the 1064 error is unexpected.

This was tested on version 5.x and 8.x MySQL servers.

Hello Julian Noble,

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.