matrixorigin / matrixorigin/matrixone

[Bug]: whether temp table can be created as partition table?

Open
#18,866 1 comment 0 reactions 1 assignee Claimed by @ck89119 View on GitHub
area/partition deferred kind/bug kind/feature
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.