|
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' ;
|
LPexportBug750117.xml