Bug #110488 pound sign can not included in qb_name hint
Submitted: 24 Mar 2023 7:52 Modified: 24 Mar 2023 8:46
Reporter: yi liu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Parser Severity:S3 (Non-critical)
Version:all, 8.0 OS:CentOS (7.x)
Assigned to: CPU Architecture:x86 (64bit)
Tags: pound sign can not included in qb_name hint

[24 Mar 2023 7:52] yi liu 
Description:
pound sign can not included in qb_name hint in mysql client 

and prompt syntax error

How to repeat:
any time
[24 Mar 2023 7:58] yi liu 
Query block names are identifiers and follow the usual rules about what names are valid and how to quote them (see Section 9.2, “Schema Object Names”). For example, a query block name that contains spaces must be quoted, which can be done using backticks ....

But,

create table `t#1`(c1 int);     -- succeed;
select /*+ qb_name(`t#1`)*/1;   -- failed
[24 Mar 2023 8:46] MySQL Verification Team 
Hello yi liu,

Thank you for the report and test case.

regards,
Umesh