MySQL Forums
Forum List  »  Partitioning

Partition using ASCII function doesn't allowed
Posted by: Mohammad Lahlouh
Date: December 21, 2008 04:46AM

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,

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition using ASCII function doesn't allowed
6627
December 21, 2008 04:46AM


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.