make partition pruning support complex partition expression

[zhexuany]

Say, we have a schema

 

CREATE TABLE `p_t` (
 `id` int(11) DEFAULT NULL,
 `name` varchar(50) DEFAULT NULL,
 `y` date DEFAULT NULL,
 index `idx_y`(`y`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
PARTITION BY RANGE ( year(y) ) (
 PARTITION p0 VALUES LESS THAN (1992),
 PARTITION p1 VALUES LESS THAN (1995),
 PARTITION p2 VALUES LESS THAN (1998)
)

 

select * from p_t where y > '1995-10-10' and y < '1997-10-10' should only access p1.