Re: Unable to create partition InnoDB

[Samad Ul Haq]

This part made me think

Each of the following statements is valid, and represents one way in which the corresponding invalid table creation statement could be made to work:
CREATE TABLE t1 (
col1 INT NOT NULL,
col2 DATE NOT NULL,
col3 INT NOT NULL,
col4 INT NOT NULL,
UNIQUE KEY (col1, col2, col3)
)
PARTITION BY HASH(col3)
PARTITIONS 4;

above table doesn't have any primary key,but has unique key. Whereas in my case i have only primary key on 'id'.

Thats why i asked such question.

Regards
Samad