Partition on day of year

[Brian Wilson]

Hi,

I am having trouble understanding this scenario:

| test_jobs2 | CREATE TABLE `test_jobs2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`printer_name` varchar(100) NOT NULL,
`job_date_time` datetime NOT NULL,
`username` varchar(100) NOT NULL,
`pages_printed` int(4) NOT NULL,
PRIMARY KEY (`id`,`job_date_time`),
KEY `search` (`customer_id`,`job_date_time`,`printer_name`,`username`)
) ENGINE=MyISAM AUTO_INCREMENT=100001 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH ( TO_DAYS(`job_date_time`))
PARTITIONS 366 */ |

But when I run this explain partitions query:

mysql> explain partitions select * from test_jobs2 where job_date_time > '2011-01-01' and job_date_time < '2011-01-01 23:59:59'\G

The output shows it hitting all the partitions instead of the expected single partition.

Can someone help?