diff options
| author | Satya B <satya.bn@sun.com> | 2009-06-29 18:33:11 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-06-29 18:33:11 +0530 |
| commit | 889b96b9c97b40b08daa6ba436eac89b98a10207 (patch) | |
| tree | d7c6fb3b532068b5fb0fc87311f1fd86d96c0ca8 /mysql-test | |
| parent | 183694ae436186ae8ecd89babbcbebf3a872e068 (diff) | |
| parent | 92ffd7e025105798886932c41e2496844f0dcb77 (diff) | |
| download | mariadb-git-889b96b9c97b40b08daa6ba436eac89b98a10207.tar.gz | |
merge to mysql-5.1-bugteam
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/innodb_bug40565.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/innodb_bug40565.test | 10 |
2 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_bug40565.result b/mysql-test/r/innodb_bug40565.result new file mode 100644 index 00000000000..21e923d9336 --- /dev/null +++ b/mysql-test/r/innodb_bug40565.result @@ -0,0 +1,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; diff --git a/mysql-test/t/innodb_bug40565.test b/mysql-test/t/innodb_bug40565.test new file mode 100644 index 00000000000..d7aa0fd514a --- /dev/null +++ b/mysql-test/t/innodb_bug40565.test @@ -0,0 +1,10 @@ +# Bug #40565 Update Query Results in "1 Row Affected" But Should Be "Zero Rows" +-- source include/have_innodb.inc + +create table bug40565(value decimal(4,2)) engine=innodb; +insert into bug40565 values (1), (null); +--enable_info +update bug40565 set value=NULL; +update bug40565 set value=NULL; +--disable_info +drop table bug40565; |