Hi all, I'm just creating my first partitioned table and have run into a bit of a snag. The table primary key is a double and I want to create partitions based on ranges of the key.
I have read the Partition Limitations section in the docs which states that the partition key must be, or resolve to an integer. I can't figure out how to cast/convert the double value into an integer that is usable by the partition calculation. This is basically what I'm trying to do: create table t1 ( id double not null, data char(32) not null, primary key (id) ) engine=innodb partition by range(cast(id as int)) ( partition p1 VALUES LESS THAN (1239257000), partition p2 VALUES LESS THAN (1239258000), partition p3 VALUES LESS THAN MAXVALUE ); What workarounds are there to partition a table keyed on a double? Note: the double value is a Perl HiRes time. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org