1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 DROP TABLE IF EXISTS t3;
5 pk1 INT NOT NULL PRIMARY KEY,
9 INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2);
11 select * from t1 order by pk1;
16 UPDATE t1 set pk1 = 4 where pk1 = 1;
17 select * from t1 order by pk1;
22 UPDATE t1 set pk1 = 4 where pk1 = 2;
23 ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
24 UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
25 select * from t1 order by pk1;
30 UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
31 ERROR 23000: Duplicate entry '2' for key 'c'
32 UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4;
33 select * from t1 order by pk1;
38 UPDATE t1 set pk1 = pk1 + 10;
39 select * from t1 order by pk1;
44 create unique index ib on t1(b);
45 update t1 set c = 4 where pk1 = 12;
46 update ignore t1 set b = 55 where pk1 = 14;
47 select * from t1 order by pk1;
52 DROP TABLE IF EXISTS t1;
53 CREATE TABLE t1 (a int, b int, KEY (a, b)) ENGINE=ndbcluster;
54 CREATE TABLE t2 (a int, b int, UNIQUE KEY (a, b)) ENGINE=ndbcluster;
55 CREATE TABLE t3 (a int, b int, PRIMARY KEY (a, b)) ENGINE=ndbcluster;
56 INSERT INTO t1 VALUES (1, 2);
57 INSERT INTO t1 VALUES (2, 2);
58 INSERT INTO t2 VALUES (1, 2);
59 INSERT INTO t2 VALUES (2, 2);
60 INSERT INTO t3 VALUES (1, 2);
61 INSERT INTO t3 VALUES (2, 2);
63 UPDATE t1 SET a = 1 ORDER BY a;
65 ERROR 23000: Duplicate entry '1-2' for key 'a'
66 UPDATE t2 SET a = 1 ORDER BY a;
67 ERROR 23000: Duplicate entry '1-2' for key 'a'
69 ERROR 23000: Duplicate entry '1-2' for key 'PRIMARY'
70 UPDATE t3 SET a = 1 ORDER BY a;
71 ERROR 23000: Duplicate entry '1-2' for key 'PRIMARY'
72 SELECT count(*) FROM t1;
75 SELECT count(*) FROM t2;
78 SELECT count(*) FROM t3;
81 SELECT * FROM t1 ORDER by a;
85 SELECT * FROM t2 ORDER by a;
89 SELECT * FROM t3 ORDER by a;
93 DROP TABLE IF EXISTS t1;
94 DROP TABLE IF EXISTS t2;
95 DROP TABLE IF EXISTS t3;