Cursor protocol gives incorrect result with sql_mode='ALLOW_INVALID_DATES'- invalid dates are replaced with "0000-00-00" , but it is important for repeating that after inserting invalid date to set sql_mode='ansi,traditional' and insert correct date:

Testcase:

CREATE TABLE t1 (col1 date);

set @@sql_mode='STRICT_ALL_TABLES,ALLOW_INVALID_DATES';

INSERT INTO t1 VALUES ('2004-2-30');

set @@sql_mode='ansi,traditional';

INSERT IGNORE INTO t1 VALUES('2004-02-29');

select * from t1;

drop table t1;

Expected value:

col1

2004-02-30

2004-02-29

Actual value:

col1

0000-00-00

2004-02-29