Partitioning problem

[martin mouterde]

Hello.

I get a mysql backup that I try to restore.
Some errors happen and I do not know why, and consequenlty how to solve my problem !

Here is an instruction from the infoschema file which produce an error :

CREATE TABLE `maTable` (
`NumberId` int(11) NOT NULL AUTO_INCREMENT,
`StateOfResource` BINARY(1) DEFAULT NULL,
`destinationNumber` BINARY(10) NOT NULL,
PRIMARY KEY USING HASH (`NumberId`),
UNIQUE KEY `MyDestinationNumber` USING HASH (`destinationNumber`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COLLATE=latin1_bin
PARTITION BY KEY (NumberId) ;

Here is what I get :
ERROR 1503 (HY000): A UNIQUE INDEX must include all columns in the table's partitioning function

thanks

PS : I use Mysql cluster 5.1.30 under fedora. My backup come from mysql cluster 5.2.2.