mysql5.1,5.5,5.6做partition时支持的函数

mysql5.1支持的partition函数(http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html) ABS() CEILING() (seeCEILING() and FLOOR()) DAY() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DATEDIFF() EXTRACT() (seeEXTRACT() function w

mysql5.1支持的partition函数 (http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html)

ABS()	CEILING() (see CEILING() and FLOOR())	DAY()
DAYOFMONTH()	DAYOFWEEK()	DAYOFYEAR()
DATEDIFF()	EXTRACT() (see EXTRACT() function with WEEK specifier)	FLOOR() (seeCEILING() and FLOOR())
HOUR()	MICROSECOND()	MINUTE()
MOD()	MONTH()	QUARTER()
SECOND()	TIME_TO_SEC()	TO_DAYS()
UNIX_TIMESTAMP() (permitted in MySQL 5.1.43 and later, with TIMESTAMP columns)	WEEKDAY()	YEAR()
	YEARWEEK()

mysql5.5支持的partition函数(http://dev.mysql.com/doc/refman/5.5/en/partitioning-limitations-functions.html)

ABS()	CEILING() (see CEILING() and FLOOR())	DAY()
DAYOFMONTH()	DAYOFWEEK()	DAYOFYEAR()
DATEDIFF()	EXTRACT() (see EXTRACT() function with WEEK specifier)	FLOOR() (seeCEILING() and FLOOR())
HOUR()	MICROSECOND()	MINUTE()
MOD()	MONTH()	QUARTER()
SECOND()	TIME_TO_SEC()	TO_DAYS()
TO_SECONDS()(implemented in MySQL 5.5.0)	UNIX_TIMESTAMP() (permitted beginning with MySQL 5.5.1 and fully supported beginning with MySQL 5.5.15, with TIMESTAMPcolumns)	WEEKDAY()
YEAR()		YEARWEEK()

mysql5.6支持的partition函数(http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations-functions.html)

ABS()	CEILING() (see CEILING() and FLOOR())	DAY()
DAYOFMONTH()	DAYOFWEEK()	DAYOFYEAR()
DATEDIFF()	EXTRACT() (see EXTRACT() function with WEEK specifier)	FLOOR() (seeCEILING() and FLOOR())
HOUR()	MICROSECOND()	MINUTE()
MOD()	MONTH()	QUARTER()
SECOND()	TIME_TO_SEC()	TO_DAYS()
TO_SECONDS()	UNIX_TIMESTAMP() (permitted beginning with MySQL 5.6.1 and fully supported beginning with MySQL 5.6.3, with TIMESTAMP columns)	WEEKDAY()
YEAR()		YEARWEEK()

创建partition表时，如果用了非支持函数，会出现“This partition function is not allowed”的错误提示