Bug #30189 Partitions: some functions are still allowed according to the manual
Submitted: 1 Aug 2007 21:33 Modified: 20 Aug 2007 11:53
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.21-beta-debug OS:Any
Assigned to: Jon Stephens
Tags: ASCII(), ORD(), partitioning, partitioning expressions, WEEKOFYEAR()
Triage: D4 (Minor)

[1 Aug 2007 21:33] Peter Gulutzan
Description:
The manual still says that ASCII(), ORD(), and WEEKOFYEAR()
are supported partition functions.

How to repeat:
"Using a function like ASCII() or ORD() to convert a string value
(such as that of a CHAR or VARCHAR column) to
an integer works only when the string uses an 8-bit character set."
http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html

16.5.3.1. Functions Supported in Partitioning Expressions
"... ASCII ... ORD ... WEEKOFYEAR"
http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions-supported.html
[1 Aug 2007 22:33] Miguel Solorzano
Thank you for the bug report.
[13 Aug 2007 7:35] Jon Stephens
According to information previously received from Trudy and Robin, these functions are permitted in partitioning expressions.

See Bug#18198.
[18 Aug 2007 10:28] Jon Stephens
Setting back to Verified status following recent email discussion with PeterG.
[20 Aug 2007 11:53] 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.

Moved ASCII(), ORD(), and WEEKOFYEAR() from supported to unsupported
function listings; removed Partitioning chapter examples depending on these functions.