MySQL Bugs: #30189: Partitions: some functions are still allowed according to the manual

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	CPU Architecture:	Any
Tags:	ASCII(), ORD(), partitioning, partitioning expressions, WEEKOFYEAR()

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

Thank you for the bug report.

According to information previously received from Trudy and Robin, these functions are permitted in partitioning expressions.

See Bug#18198.

Setting back to Verified status following recent email discussion with PeterG.

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.