mysql-test/suite/innodb/t/innodb_bug40565.test
raw| 1 | --source include/have_innodb.inc |
| 2 | # Bug #40565 Update Query Results in "1 Row Affected" But Should Be "Zero Rows" |
| 3 | |
| 4 | create table bug40565(value decimal(4,2)) engine=innodb; |
| 5 | insert into bug40565 values (1), (null); |
| 6 | --enable_info |
| 7 | update bug40565 set value=NULL; |
| 8 | update bug40565 set value=NULL; |
| 9 | --disable_info |
| 10 | drop table bug40565; |