MySQL Bugs: #39882: Nested function calls still allowed in partitioning

Bug #39882	Nested function calls still allowed in partitioning
Submitted:	6 Oct 2008 13:56	Modified:	24 Oct 2008 16:02
Reporter:	Scott Noyes	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1+	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any
Tags:	limitations, partitioning, partitioning expressions

Description:
Nested function calls have been disallowed since 5.1.21, per bugs Bug#26082, Bug#18198 and Bug#29308

Yet the example illegal nested call from the manual is still allowed.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html

How to repeat:
mysql> SELECT VERSION();
+-------------------------+
| VERSION()               |
+-------------------------+
| 5.1.28-rc-community-log |
+-------------------------+
1 row in set (0.00 sec)

mysql> CREATE TABLE t1 (d date) PARTITION BY HASH(MOD(TO_DAYS(d), 7));
Query OK, 0 rows affected (0.09 sec)

Suggested fix:
Either the nested functions really are allowed in certain cases, and the documentation needs updating, or they shouldn't be accepted at all.

Per discussion today with Trudy, it's been decided to remove the limitation from the documentation. Changed category/status/Priority to Docs/Verified/P2, assigned to myself, set Stefan as lead.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.