[Bug]: desc temp table is empty

[dengn]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

MO behavior:

mysql> desc temp_employees;
ERROR 1146 (HY000): no such table tenant1.temp_employees
mysql> CREATE TEMPORARY TABLE temp_employees (     employee_id INT AUTO_INCREMENT,       first_name VARCHAR(50),               last_name VARCHAR(50),                email VARCHAR(100),                   PRIMARY KEY (employee_id)         );Query OK, 0 rows affected (0.14 sec)
mysql> desc temp_employees;
Empty set (0.15 sec)

MySQL behavior:

mysql> desc temp_employees;
ERROR 1146 (42S02): Table 'tenant1.temp_employees' doesn't exist
mysql> CREATE TEMPORARY TABLE temp_employees (
    ->     employee_id INT AUTO_INCREMENT,  -- ID
    ->     first_name VARCHAR(50),          -- 
    ->     last_name VARCHAR(50),           -- 
    ->     email VARCHAR(100),              -- 
    ->     PRIMARY KEY (employee_id)        --  'employee_id' 
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> desc temp_employees;                                                                                                      
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| employee_id | int          | NO   | PRI | NULL    | auto_increment |
| first_name  | varchar(50)  | YES  |     | NULL    | NULL           |
| last_name   | varchar(50)  | YES  |     | NULL    | NULL           |
| email       | varchar(100) | YES  |     | NULL    | NULL           |
+-------------+--------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

[daviszhen]

@YANGGMM 先看下

[YANGGMM]

there is no info in mo_columns about temporary table

[YANGGMM]

have associated with @jensenojs, need waitting to rewrite

[jensenojs]

临时表的引擎用的的memoryengine不再维护已经很久了，后面需要很大的重构，0.8结束我应该就会开始干这个事情。

[jensenojs]

后面要和产品对一下要不要做

[jensenojs]

not process

[sukki37]

depend on #7889

[yangj1211]

show create table 查看临时表结构也与mysql行为不一致：

[aressu1985]

临时表的需求，优先级较低，delay到1.3.0