作者mcdowell (蔚)
看板Database
标题[SQL ] This partition function is not allowed
时间Mon Jun 15 14:43:58 2015
资料库名称：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那句话呢？
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 121.96.66.134
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Database/M.1434350642.A.254.html