Bug #30189 Partitions: some functions are still allowed according to the manual
Submitted: 1 Aug 2007 23:33 Modified: 20 Aug 2007 13:53
Reporter: Peter Gulutzan
Status: Closed
Category:Server: Docs Severity:S3 (Non-critical)
Version:5.1.21-beta-debug OS:Any
Assigned to: Jon Stephens Target Version:
Tags: partitioning, ASCII(), ORD(), WEEKOFYEAR(), partitioning expressions
Triage: D4 (Minor)

[1 Aug 2007 23: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
[2 Aug 2007 0:33] Miguel Solorzano 
Thank you for the bug report.
[13 Aug 2007 9: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 12:28] Jon Stephens 
Setting back to Verified status following recent email discussion with PeterG.
[20 Aug 2007 13: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.