[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