Re: Partitioning and PK

[Scott Noyes]

Erhan,

I think the limitation you're running into is that the primary or unique key must contain any columns used in the partition expression. Hence this is illegal:

CREATE TABLE t1 (id int, d date, PRIMARY KEY (id)) PARTITION BY RANGE(YEAR(d));

But this makes it legal:

CREATE TABLE t1 (id int, d date, PRIMARY KEY (id, d)) PARTITION BY RANGE(YEAR(d));