Partition using ASCII function doesn't allowed
i cannot create partition table with this function:
using 5.1.30
mysql> CREATE TABLE tk (
-> col1 INT NOT NULL,
-> col2 CHAR(5),
-> col3 DATE
-> )
-> PARTITION BY RANGE (ASCII(col1))
-> (
-> PARTITION p1 VALUES LESS THAN (128),
-> PARTITION p3 VALUES LESS THAN MAXVALUE
-> );
ERROR 1564 (HY000): This partition function is not allowed
mysql> CREATE TABLE tk (
-> col1 INT NOT NULL,
-> col2 CHAR(5),
-> col3 DATE
-> )
-> PARTITION BY HASH (ASCII(col1))
-> PARTITIONS 256;
ERROR 1564 (HY000): This partition function is not allowed
mysql> select version();
+------------------+
| version() |
+------------------+
| 5.1.30-community |
+------------------+
1 row in set (0.00 sec)
Regards,
Subject
Views
Written By
Posted
Partition using ASCII function doesn't allowed
6627
December 21, 2008 04:46AM
3210
January 01, 2009 06:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.