1391
MySQLerrorddlhigh confidence
Cannot use temporary table with partitions
Production Risk
Low — DDL fails; no data affected.
What this means
An attempt was made to create a TEMPORARY table with a PARTITION BY clause, which is not supported.
Why it happens
- 1CREATE TEMPORARY TABLE with PARTITION BY clause
How to reproduce
trigger — this will error
trigger — this will error
CREATE TEMPORARY TABLE t (id INT) PARTITION BY HASH(id) PARTITIONS 4;
expected output
ERROR 1391 (HY000): Cannot use temporary table with partitions
Fix
Remove TEMPORARY or remove PARTITION BY
Why this works
MySQL does not support partitioned temporary tables; choose one or the other.
Sources
Official documentation ↗
MySQL 8.0 — 1391 ER_PARTITION_NO_TEMPORARY
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev