Thank you for your help. I find the following statement from "Partitioning---->Restrictions and Limitations on Partitioning" section in the MySQL-5.1 reference manual: A partitioning key must be either an integer column or an expression that resolves to an integer. The column or expression value may also be NULL. (See Section 17.2.6, “How MySQL Partitioning Handles NULL Values”.) The one exception to this restriction occurs when partitioning by [LINEAR] KEY ― where it is possible to use columns of other types types as partitioning keys ― because MySQL's internal key-hashing functions produce the correct datatype from these types. For example, the following CREATE TABLE statement is valid:
CREATE TABLE tkc (c1 CHAR) PARTITION BY KEY(c1) PARTITIONS 4; This exception does not apply to BLOB or TEXT column types Dan Nelson <[EMAIL PROTECTED]> 写道: In the last episode (Feb 08), xian liu said: > 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!! I can't see it docummentioned in the documentation, but the code looks like it only accepts integer expressions for ranges. sql_yacc.yy, line 3939: else if (part_expr->result_type() != INT_RESULT && !part_expr->null_value) { yyerror(ER(ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR)); YYABORT; } In your case, changing your id column to a BIGINT type should work. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] @@@^_^@@@ --------------------------------- Mp3疯狂搜-新歌热歌高速下