ddl: exchange partition with temporary table should not be allowed.

[lcwangchao]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

set @@tidb_enable_exchange_partition=1;
CREATE TABLE tp (id INT) PARTITION BY RANGE (id) ( 
        PARTITION p0 VALUES LESS THAN (100),
        PARTITION p1 VALUES LESS THAN (1000)
);
create global temporary table tmp1 (id int) on commit delete rows;
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE tmp1;

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

ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE tmp1; should fail.

3. What did you see instead (Required)

mysql> ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE tmp1;
Query OK, 0 rows affected, 1 warning (2.71 sec)

4. What is your TiDB version? (Required)

master

mysql> SELECT tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v6.2.0-alpha
Edition: Community
Git Commit Hash: 09cb849c27ff8ebe255f6addbc6dfc6b240d68d5
Git Branch: heads/refs/tags/v6.2.0-alpha
UTC Build Time: 2022-08-08 14:26:07
GoVersion: go1.18.5
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)