summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <mskold/marty@mysql.com/linux.site>2006-11-29 11:53:43 +0100
committerunknown <mskold/marty@mysql.com/linux.site>2006-11-29 11:53:43 +0100
commit3d629d9f43095387b3b1bb07a36e1a73c4a96230 (patch)
treeffd2dd920ccea5d4a8e501ca6419895e0941250d /mysql-test/t
parentfb9b91f3f641a5abb175e8dc3a13ae0f763b85a0 (diff)
downloadmariadb-git-3d629d9f43095387b3b1bb07a36e1a73c4a96230.tar.gz
bug#24303 Wrong result for UPDATE IGNORE for NDB table: Added test case
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/ndb_update.test4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_update.test b/mysql-test/t/ndb_update.test
index 45e3add4639..5472dd95e9f 100644
--- a/mysql-test/t/ndb_update.test
+++ b/mysql-test/t/ndb_update.test
@@ -23,6 +23,10 @@ UPDATE t1 set b = c;
select * from t1 order by pk1;
UPDATE t1 set pk1 = 4 where pk1 = 1;
select * from t1 order by pk1;
+--error 1062
+UPDATE t1 set pk1 = 4 where pk1 = 2;
+UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
+select * from t1 order by pk1;
-- error 1062
UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
select * from t1 order by pk1;