mysql> create table t1 (num int(10) not null, id char(18) not null)
partition by range(id) (
partition id1 values less than('111111111111111112'),
partition id2 values less than('222222222222222223'),
partition id3 values less than('333333333333333334'),
partition id4 values less than('444444444444444445')
);
ERROR 1064 (42000): VALUES value must be of same type as partition function
near '), partition id2 values less than('222222222222222223'), partition id3
values ' at line 1
what's the meaning of this error??
does't it support partition key is column of char type in MySQL-5.1.14-beta
version?
Anyone advice ? thanks a lot!!
Best Regards,
Liu Xian
2007-02-08
@@@^_^@@@
---------------------------------
抢注雅虎免费邮箱-3.5G容量，20M附件！
