Partitioning by YEAR() changes the query result: a date with a zero day or a zero month is not found

--source include/have_partition.inc

CREATE TABLE t1 (d DATE) PARTITION BY RANGE (YEAR(d)) (PARTITION p0 VALUES LESS THAN (2000), PARTITION p1 VALUES LESS THAN MAXVALUE);

INSERT INTO t1 VALUES ('2000-01-00');

--let $c= query_get_value(SELECT COUNT(*) AS c FROM t1 WHERE d < '2000-01-01', c, 1)

if ($c != 1)

{

  --die The row 2000-01-00 is not found by d < '2000-01-01' on a table partitioned by YEAR(d)

}

DROP TABLE t1;

mysqltest: At line 8: The row 2000-01-00 is not found by d < '2000-01-01' on a table partitioned by YEAR(d)