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

Bug #39882	Nested function calls still allowed in partitioning
Submitted:	6 Oct 2008 15:56	Modified:	24 Oct 2008 18:02
Reporter:	Scott Noyes
Status:	Closed
Category:	Server: Docs	Severity:	S3 (Non-critical)
Version:	5.1+	OS:	Any
Assigned to:	Jon Stephens	Target Version:
Tags:	partitioning expressions, limitations, partitioning
Triage:	Needs Triage: D2 (Serious)

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.