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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.6.26, 5.6.35 OS:Ubuntu (14.04)
Assigned to: 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] Umesh Shastry
Hello Hai Jiang,

Thanks you for the report.

Thanks,
Umesh