Feature Request: Global Indexes for Partitioning

[fz wsc]

Now, to be a partition key, a column has to be included in PRIMARY KEY().
For instance, in the following statement, I don't really want `p1` be included in the PRIMARY KEY. Is this suggestion reasonable?

CREATE TABLE `t1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`p1` varchar(50) NOT NULL,
PRIMARY KEY (`id`,`p1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1
COLLATE utf8_general_ci
PARTITION BY LINEAR KEY(`p1`)
PARTITIONS 4;



Edited 1 time(s). Last edit at 05/29/2006 07:18PM by Edwin DeSouza.