Bug #85808 can not execute 'desc' command in a normal string

• Submitted: 5 Apr 2017 12:31
• Modified: 6 Apr 2017 7:39
• Reporter: Hai Jiang
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.6.26, 5.6.35
• OS: Ubuntu (14.04)
• CPU Architecture: Any
• Tags: command, specific String

[5 Apr 2017 12:31] Hai Jiang

Description:
can not execute 'desc' command with 5360e4622324c4c6b7075546b9bb7708 without  '``' comma,  but ok with  5363eff22324c4c6b7075546b9bb5444. neither in 'show create table'

How to repeat:
mysql> desc `5360e4622324c4c6b7075546b9bb7708`;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+

mysql>desc 5360e4622324c4c6b7075546b9bb7708;
ERROR 1064 (42000): 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 '5360e4622324c4c6b7075546b9bb7708' at line 1

mysql> desc 5363eff22324c4c6b7075546b9bb5444;
ERROR 1146 (42S02): Table 'test.5363eff22324c4c6b7075546b9bb5444' doesn't exist

[6 Apr 2017 7:39] MySQL Verification Team

Hello Hai Jiang,

Thanks you for the report.

Thanks,
Umesh