parser: something wrong with scanner with the stats_extended table

[AilinKid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> use mysql
Database changed

mysql> show create table stats_extended;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 32 near "stats_extended" 

mysql> show create table mysql.stats_extended;
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table          | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| stats_extended | CREATE TABLE `stats_extended` (
  `name` varchar(32) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `table_id` bigint(64) NOT NULL,
  `column_ids` varchar(32) NOT NULL,
  `stats` blob DEFAULT NULL,
  `version` bigint(64) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`name`,`table_id`) /*T![clustered_index] NONCLUSTERED */,
  KEY `idx_1` (`table_id`,`status`,`version`),
  KEY `idx_2` (`status`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

2. What did you expect to see? (Required)

show the result

3. What did you see instead (Required)

parser error

4. What is your TiDB version? (Required)

master

[djshow832]

Duplicate with #23396

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug Querying stats_extended reports syntax error #23396