mysql - mysql 分区查询语法错误

Question

我正在尝试对表进行分区。分区基于gap_id 和profile_code。但是我收到以下错误:

Inconsistency in usage of column lists for partitioning near '), ('S00') ), PARTITION p1 VALUES IN ( (1), ('S01') ), PARTITION p2 VALU' at line 8

我不知道我做错了什么，有人可以给我提示吗？

    CREATE TABLE test_partitioning (
    gap_id INT,
    profile_code VARCHAR(25),
    val INT,
    date_timestamp DATE
)

    PARTITION BY LIST COLUMNS(gap_id,profile_code) (
        PARTITION p0 VALUES IN ( (1), ('S00') ),
        PARTITION p1 VALUES IN ( (1), ('S01') ),
        PARTITION p2 VALUES IN ( (2), ('S00') ),
        PARTITION p3 VALUES IN ( (2), ('S01') )
    );

Answer 1

您需要使列表中的每个元组具有与分区列列表相同的列数:

PARTITION BY LIST COLUMNS(gap_id,profile_code) (
    PARTITION p0 VALUES IN ( (1, 'S00') ),
    PARTITION p1 VALUES IN ( (1, 'S01') ),
    PARTITION p2 VALUES IN ( (2, 'S00') ),
    PARTITION p3 VALUES IN ( (2, 'S01') )
);