No pruning with year() function in where clause

[Jonathan Krier]

Hi,

According to the official documentation (18.4. Partition Pruning), with a range partitionning of years, this kind of query should benefit of pruning :

SELECT * FROM t2 WHERE YEAR(dob) IN (1979, 1980, 1983, 1985, 1986, 1988);

However, when I use something like "WHERE YEAR(myDateField) = xxx", every partition is checked.

Is it a current limitation ?


Regards
Jonathan