make partition pruning works on simple partition expr

[zhexuany]

For a table p_t with 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 ( id ) (
 PARTITION p0 VALUES LESS THAN (2),
 PARTITION p1 VALUES LESS THAN (4),
 PARTITION p2 VALUES LESS THAN (6)
)

 

select * from p_t where id < 4 and id > 3 should only access partition p1. 

 

In this Jira issue, complex partition expression such as year(purchased) where purchased is date will be discarded.