diff options
| author | Satya B <satya.bn@sun.com> | 2009-06-11 18:42:25 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-06-11 18:42:25 +0530 |
| commit | 92ffd7e025105798886932c41e2496844f0dcb77 (patch) | |
| tree | 09e67eec381e9eb131d5a116fd6869ec01b102a7 /mysql-test/r/innodb_bug40565.result | |
| parent | 03bd6f025bbecd8f1694dd090d0eb68ef10d28e2 (diff) | |
| download | mariadb-git-92ffd7e025105798886932c41e2496844f0dcb77.tar.gz | |
Applying InnoDB snashot 5.1-ss5282, Add TestCase for BUG#40565
Merge the test case from 5.0 to 5.1 for BUG#40565
Detailed revision comments:
r5233 | marko | 2009-06-03 15:12:44 +0300 (Wed, 03 Jun 2009) | 11 lines
branches/5.1: Merge the test case from r5232 from branches/5.0:
------------------------------------------------------------------------
r5232 | marko | 2009-06-03 14:31:04 +0300 (Wed, 03 Jun 2009) | 21 lines
branches/5.0: Merge r3590 from branches/5.1 in order to fix Bug #40565
(Update Query Results in "1 Row Affected" But Should Be "Zero Rows").
Also, add a test case for Bug #40565.
rb://128 approved by Heikki Tuuri
------------------------------------------------------------------------
Diffstat (limited to 'mysql-test/r/innodb_bug40565.result')
| -rw-r--r-- | mysql-test/r/innodb_bug40565.result | 9 |
1 files changed, 9 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; |