# Bug #40565 Update Query Results in "1 Row Affected" But Should Be "Zero Rows"--sourceinclude/have_innodb.inccreatetablebug40565(valuedecimal(4,2))engine=innodb;insertintobug40565values(1),(null);--enable_infoupdatebug40565setvalue=NULL;updatebug40565setvalue=NULL;--disable_infodroptablebug40565;