matrixorigin / matrixorigin/matrixone
[Bug]: whether temp table can be created as partition table?
- Dominant language
- Go
- Stars
- 1.9k
- Forks
- 311
- Avg merge
- 1d 3h
- Merged PRs (30d)
- 768
Description
### Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
### Branch Name
main
### Commit ID
afd7c53370cd67a1b21b84e2463ce60702493d06
### Other Environment Information
```Markdown
- Hardware parameters:
- OS type:
- Others:
```
### Actual Behavior
MO:
mysql> CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE TEMPORARY TABLE tmp_t1 LIKE t1;
Query OK, 0 rows affected (0.03 sec)
mysql> DROP TABLE t1;
Query OK, 0 rows affected (0.03 sec)
MYSQL:
mysql> CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TEMPORARY TABLE tmp_t1 LIKE t1;
ERROR 1562 (HY000): Cannot create temporary table with partitions
mysql> DROP TABLE t1;
Query OK, 0 rows affected (0.01 sec)
### Expected Behavior
_No response_
### Steps to Reproduce
```Markdown
CREATE TABLE t1 (a INT) PARTITION BY HASH(a);
CREATE TEMPORARY TABLE tmp_t1 LIKE t1;
DROP TABLE t1;
```
### Additional information
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.