summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/innodb_bug40565.result
blob: 21e923d93363499a665ecb115d08596884d84b71 (plain)
1
2
3
4
5
6
7
8
9
create table bug40565(value decimal(4,2)) engine=innodb;
insert into bug40565 values (1), (null);
update bug40565 set value=NULL;
affected rows: 1
info: Rows matched: 2  Changed: 1  Warnings: 0
update bug40565 set value=NULL;
affected rows: 0
info: Rows matched: 2  Changed: 0  Warnings: 0
drop table bug40565;