Bug #39891 Manual incorrectly permits any expression for partitioning function
Submitted: 6 Oct 2008 19:20 Modified: 7 Oct 2008 12:58
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

[6 Oct 2008 19:20] Scott Noyes
Description:
The HASH Partitioning page contains the following:

"You may use any function or other expression for expr that is valid in MySQL, so long as it returns a non-constant, non-random integer value."

which isn't true anymore - only a limited set of functions are permitted, at the moment anyway.

How to repeat:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-hash.html

Suggested fix:
Edit the sentence to refer to the limitations at http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html
[7 Oct 2008 12:58] 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.