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/[email protected]
