Bug #56781 Illegal partitioning functions in examples
Submitted: 14 Sep 2010 22:39 Modified: 14 Sep 2010 23:27
Reporter: Scott Noyes Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[14 Sep 2010 22:39] Scott Noyes 
Description:
The first "working" example shows partitioning using CAST and DATE_FORMAT, neither of which are permitted as of 5.1.12.

How to repeat:
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning_with_dates.html
[14 Sep 2010 23:21] MySQL Verification Team 
Thank you for the bug report.
[15 Sep 2010 5:06] Jon Stephens 
Please bear in mind that the examples shown in the article worked as shown *at the time the article was written, and the article itself speaks of MySQL 5.1 as "beta software"*. This is really all that you need to tell this customer.

I think you'll find this is by no means the only DevZone article that was not future-proofed prior to publication.

You should bring this up with Marketing, and tell them they need to review all of the current articles on the DevZone for lack of future-proof-ness and to vet and new ones for this before publishing them.