SHOW CREATE TABLE result wrong for the global temporary table

[tiancaiamao]

Development Task

mysql> create global temporary table t1 (id int) on commit delete rows;
Query OK, 0 rows affected (0.00 sec)

mysql> show create table t1;
+-------+-------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                |
+-------+-------------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+-------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

The GLOBAL TEMPORARY ... ON COMMIT DELETE ROWS are missing.

Note: we have to take the replication to downstream TiDB into consideration.

[tisonkun]

ref #24169