summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_basic.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/ndb_basic.test')
-rw-r--r--mysql-test/t/ndb_basic.test6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test
index 29b63a5a24a..ad5f9c652c7 100644
--- a/mysql-test/t/ndb_basic.test
+++ b/mysql-test/t/ndb_basic.test
@@ -792,7 +792,7 @@ drop table t1,t2;
# insert ignore
create table t1 (a int not null primary key, b int not null) engine=ndb;
insert into t1 values (1,10), (2,20), (3,30);
---error 1062
+--error ER_DUP_ENTRY_WITH_KEY_NAME
insert into t1 set a=1, b=100;
insert ignore into t1 set a=1, b=100;
select * from t1 order by a;
@@ -805,12 +805,12 @@ create table t1 (a int not null primary key, b int not null) engine=ndb;
create table t2 (c int not null primary key, d int not null) engine=ndb;
insert into t1 values (1,10), (2,10), (3,30), (4, 30);
insert into t2 values (1,10), (2,10), (3,30), (4, 30);
---error 1062
+--error ER_DUP_ENTRY_WITH_KEY_NAME
update t1 set a = 1 where a = 3;
select * from t1 order by a;
update t1 set b = 1 where a > 1 order by a desc limit 1;
select * from t1 order by a;
---error 1062
+--error ER_DUP_ENTRY_WITH_KEY_NAME
update t1,t2 set a = 1, c = 1 where a = 3 and c = 3;
select * from t1 order by a;
update ignore t1,t2 set a = 1, c = 1 where a = 3 and c = 3;