Bug #17540 Partitioning by range doesn't work with dates

Description:
Partitioning by RANGE doesn't work with DATE fields or DATETIME fields.

How to repeat:
CREATE TABLE t (
  d DATE NOT NULL
)
PARTITION BY RANGE(d) (
  PARTITION p0 VALUES LESS THAN ('2005-06-02')
);

Produces the following error:

ERROR 1064 (42000) at line 1: VALUES value must be of same type as partition function near ')
)' at line 5

Thank you for the bug report.

miguel@hegel:~/dbs/5.1> bin/mysql -uroot db1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.8-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE TABLE t (
    ->   d DATE NOT NULL
    -> )
    -> PARTITION BY RANGE(d) (
    ->   PARTITION p0 VALUES LESS THAN ('2005-06-02')
    -> );
ERROR 1064 (42000): VALUES value must be of same type as partition function near ')
)' at line 5

This is an example of what was reported in
Bug#13436 Partitions: most data types don't work,
which is marked "To be fixed later".
The version-5.1 MySQL Reference Manual currently says,
in section 17.5. Restrictions and Limitations on Partitioning:
"A partitioning key must be either an integer column or an
 expression that resolves to an integer."