Syntax of creating partitions by binary column
Hi,
I created simple table under InnoDB engine:
a1 | CREATE TABLE `a1` (
`a` varbinary(16) NOT NULL DEFAULT '',
`b` varchar(20) DEFAULT NULL,
PRIMARY KEY (`a`)
ENGINE=InnoDB DEFAULT CHARSET=latin1
Now I am going to add partitions to my table using alter table statement:
mysql> alter table a1 partition by range(a) (
-> partition p0 values less than (0xba),
-> partition p1 values less than (0xcd)
-> )
-> ;
I get error
ERROR 1064 (42000): VALUES value must be of same type as partition function near '),
partition p1 values less than (0xba)
)' at line 2
Ok, I'm trying to create partitions using hash:
mysql> alter table a1 partition by hash(a)
-> partitions 16
-> ;
I get error
ERROR 1478 (HY000): The PARTITION function returns the wrong type
Where is the problem? Wrong syntax?
Thanks,
Andrey
Subject
Views
Written By
Posted
Syntax of creating partitions by binary column
3556
March 07, 2007 02:27PM
4418
March 09, 2007 12:03AM
2431
March 11, 2007 09:39AM
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.