Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

错误原因:常量、随机或者依赖时区的表达式不能作为分区函数。

解决方法:把ts列换成datetime类型，创建成功。

CREATE TABLE T_log(

 id INT(11) NOT NULL AUTO_INCREMENT,

  zoneid INT(11) NOT NULL,

  numcount INT(11) NOT NULL,

  ts DATETIME NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (id,ts)

)

PARTITION BY RANGE (YEARWEEK(ts)) (

    PARTITION p1 VALUES LESS THAN (201401),

    PARTITION p2 VALUES LESS THAN (201402),

    PARTITION p3 VALUES LESS THAN (201403),

    PARTITION p51 VALUES LESS THAN (201452),

    PARTITION p52 VALUES LESS THAN MAXVALUE));

巴特西

Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

最新文章

热门文章