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
Tags: limitations, partitioning, partitioning expressions
Triage: Needs Triage: D2 (Serious)

[6 Oct 2008 13:56] Scott Noyes
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.
[23 Oct 2008 19:39] Jon Stephens
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.
[24 Oct 2008 16:02] Jon Stephens
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.