[SQL ] This partition function is not allowed

楼主: mcdowell (蔚)   2015-06-15 14:43:58
数据库名称:mySql
数据库版本:5.6.10
内容/问题描述:
ALTER TABLE projects PARTITION BY LIST ( MONTH(writetime) )
SUBPARTITION BY HASH( dayofmonth(writetime - INTERVAL 6 HOUR) )
SUBPARTITIONS 32(
PARTITION p0 VALUES in (0),
PARTITION p1 VALUES in (1),
PARTITION p2 VALUES in (2),
PARTITION p3 VALUES in (3),
PARTITION p4 VALUES in (4),
PARTITION p5 VALUES in (5),
PARTITION p6 VALUES in (6),
PARTITION p7 VALUES in (7),
PARTITION p8 VALUES in (8),
PARTITION p9 VALUES in (9),
PARTITION p10 VALUES in (10),
PARTITION p11 VALUES in (11),
PARTITION p12 VALUES in (12)
);
执行partition时遇到说function is not allowed问题。。。
请问这样应该如何修改subpartition那句话呢?

Links booklink

Contact Us: admin [ a t ] ucptt.com