List:General Discussion« Previous MessageNext Message »
From:xian liu Date:February 8 2007 5:23am
Subject:about partition key type
View as plain text  
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附件! 
Thread
about partition key typexian liu8 Feb
  • Re: about partition key typeDan Nelson8 Feb
    • 回复: Re: about partition key typexian liu8 Feb