Bogus warning (data corruption?) with aggregate and datetime column in 5.1-micro

[Philip Stoev]

Not repeatable with mysql-5.1. The following query:

SELECT MIN( f1 ) FROM t1 WHERE f1 >= '2006-05-25 07:00:20' AND f1 BETWEEN '2003-11-23 10:00:09' AND '2010-01-01 01:01:01' AND f1 > '2001-01-01 01:01:01' ;

returns the following warning:

| Warning | 1292 | Incorrect datetime value: '72025063209000000' for column 'f1' at row 1 |

The warning goes away if MIN() is removed and if the >= is replaced by >

test case:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 ( f1 datetime, KEY (f1) );
INSERT INTO t1 VALUES ('2000-03-09 15:56:59'),('2000-05-05 23:24:28'),('2000-06-13 13:12:06');
SELECT MIN( f1 ) FROM t1 WHERE f1 >= '2006-05-25 07:00:20' AND f1 BETWEEN '2003-11-23 10:00:09' AND '2010-01-01 01:01:01' AND f1 > '2001-01-01 01:01:01' ;