Return "Can't get table tt" when create TEMPORARY table using select clause

[zimulala]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table tt,t1;
CREATE TABLE t1 (i INT);

BEGIN;
CREATE TEMPORARY TABLE tt (
    `i` int DEFAULT NULL
    );
INSERT INTO tt SELECT * FROM t1;

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

mysql> INSERT INTO tt SELECT * FROM t1;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

3. What did you see instead (Required)

tidb> INSERT INTO tt SELECT * FROM t1;
ERROR 1105 (HY000): Can't get table tt

4. What is your TiDB version? (Required)

Release Version: v6.2.0-alpha-122-ga5d6db20d
Edition: Community
Git Commit Hash: a5d6db20d7982cff4a8fc963c198c0fad864a05e
Git Branch: master