1932
MariaDBERRORNotableDDLHIGH confidence
For LIST COLUMNS and RANGE COLUMNS partitioning, the column list must not be empty
Production Risk
Low — DDL is rejected; no data is affected.
What this means
RANGE COLUMNS or LIST COLUMNS partitioning was specified without listing any columns, which is not allowed.
Why it happens
- 1CREATE TABLE ... PARTITION BY RANGE COLUMNS() with an empty column list.
- 2Typo or misuse of COLUMNS partitioning syntax.
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (id INT) PARTITION BY RANGE COLUMNS() (PARTITION p0 VALUES LESS THAN (100));
expected output
ERROR 1932 (HY000): For LIST COLUMNS and RANGE COLUMNS partitioning, the column list must not be empty.
Fix
Specify at least one column in the COLUMNS list
Specify at least one column in the COLUMNS list
CREATE TABLE t (id INT) PARTITION BY RANGE COLUMNS(id) (PARTITION p0 VALUES LESS THAN (100));
Why this works
RANGE COLUMNS and LIST COLUMNS require one or more column references.
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1932 ER_PARTITION_COLUMN_LIST_ERROR2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev