Debian Codegraph @

mysql-test/suite/ndb/r/ndb_update.result

raw
1 CREATE TABLE t1 (
2 pk1 INT NOT NULL PRIMARY KEY,
3 b INT NOT NULL,
4 c INT NOT NULL UNIQUE
5 ) ENGINE=ndbcluster;
6 INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2);
7 UPDATE t1 set b = c;
8 select * from t1 order by pk1;
9 pk1 b c
10 0 0 0
11 1 1 1
12 2 2 2
13 UPDATE t1 set pk1 = 4 where pk1 = 1;
14 select * from t1 order by pk1;
15 pk1 b c
16 0 0 0
17 2 2 2
18 4 1 1
19 UPDATE t1 set pk1 = 4 where pk1 = 2;
20 ERROR 23000: Duplicate entry '4' for key 't1.PRIMARY'
21 UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
22 Warnings:
23 Warning 1062 Duplicate entry '4' for key 't1.PRIMARY'
24 select * from t1 order by pk1;
25 pk1 b c
26 0 0 0
27 2 2 2
28 4 1 1
29 UPDATE t1 set pk1 = 2 where pk1 = 2;
30 affected rows: 0
31 info: Rows matched: 1 Changed: 0 Warnings: 0
32 UPDATE t1 set c = 1 WHERE b IN(0,1,2,3,4);
33 ERROR 23000: Duplicate entry '1' for key 't1.c'
34 UPDATE IGNORE t1 set c = 1 WHERE b IN(0,1,2,3,4);
35 Warnings:
36 Warning 1062 Duplicate entry '1' for key 't1.c'
37 Warning 1062 Duplicate entry '1' for key 't1.c'
38 UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
39 ERROR 23000: Duplicate entry '2' for key 't1.c'
40 UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4;
41 Warnings:
42 Warning 1062 Duplicate entry '2' for key 't1.c'
43 select * from t1 order by pk1;
44 pk1 b c
45 0 0 0
46 2 2 2
47 4 1 1
48 UPDATE t1 set pk1 = pk1 + 10;
49 select * from t1 order by pk1;
50 pk1 b c
51 10 0 0
52 12 2 2
53 14 1 1
54 create unique index ib on t1(b);
55 update t1 set c = 4 where pk1 = 12;
56 update ignore t1 set b = 55 where pk1 = 14;
57 select * from t1 order by pk1;
58 pk1 b c
59 10 0 0
60 12 2 4
61 14 55 1
62 DROP TABLE IF EXISTS t1;
63 CREATE TABLE t1 (a int, b int, KEY (a, b)) ENGINE=ndbcluster;
64 CREATE TABLE t2 (a int, b int, UNIQUE KEY (a, b)) ENGINE=ndbcluster;
65 CREATE TABLE t3 (a int, b int, PRIMARY KEY (a, b)) ENGINE=ndbcluster;
66 INSERT INTO t1 VALUES (1, 2);
67 INSERT INTO t1 VALUES (2, 2);
68 INSERT INTO t2 VALUES (1, 2);
69 INSERT INTO t2 VALUES (2, 2);
70 INSERT INTO t3 VALUES (1, 2);
71 INSERT INTO t3 VALUES (2, 2);
72 UPDATE t1 SET a = 1;
73 UPDATE t1 SET a = 1 ORDER BY a;
74 UPDATE t2 SET a = 1;
75 ERROR 23000: Duplicate entry '1-2' for key 't2.a'
76 UPDATE t2 SET a = 1 ORDER BY a;
77 ERROR 23000: Duplicate entry '1-2' for key 't2.a'
78 UPDATE t3 SET a = 1;
79 ERROR 23000: Duplicate entry '1-2' for key 't3.PRIMARY'
80 UPDATE t3 SET a = 1 ORDER BY a;
81 ERROR 23000: Duplicate entry '1-2' for key 't3.PRIMARY'
82 SELECT count(*) FROM t1;
83 count(*)
84 2
85 SELECT count(*) FROM t2;
86 count(*)
87 2
88 SELECT count(*) FROM t3;
89 count(*)
90 2
91 SELECT * FROM t1 ORDER by a;
92 a b
93 1 2
94 1 2
95 SELECT * FROM t2 ORDER by a;
96 a b
97 1 2
98 2 2
99 SELECT * FROM t3 ORDER by a;
100 a b
101 1 2
102 2 2
103 DROP TABLE IF EXISTS t1;
104 DROP TABLE IF EXISTS t2;
105 DROP TABLE IF EXISTS t3;
106 CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT,
107 mytext CHAR(30) DEFAULT NULL,
108 PRIMARY KEY (`id`) ) ENGINE=ndbcluster;
109 insert into t1 values(NULL,"hello"),(NULL,"world"),(NULL,"hello"),(NULL,"world");
110 select * from t1 order by id;
111 id mytext
112 1 hello
113 2 world
114 3 hello
115 4 world
116 update t1 set mytext = "goodbye" where mytext = "world" order by mytext;
117 select * from t1 order by id;
118 id mytext
119 1 hello
120 2 goodbye
121 3 hello
122 4 goodbye
123 DROP TABLE IF EXISTS t1;
124 End of 5.1 tests
125 CREATE TABLE t1 (
126 a INT PRIMARY KEY,
127 b INT,
128 UNIQUE (b)
129 ) ENGINE NDB;
130 INSERT INTO t1 VALUES (1,1);
131 INSERT INTO t1 SELECT a+1, b+1 FROM t1;
132 INSERT INTO t1 SELECT a+2, b+2 FROM t1;
133 INSERT INTO t1 SELECT a+4, b+4 FROM t1;
134 INSERT INTO t1 SELECT a+8, b+8 FROM t1;
135 INSERT INTO t1 SELECT a+16, b+16 FROM t1;
136 INSERT INTO t1 SELECT a+32, b+32 FROM t1;
137 BEGIN;
138 UPDATE t1 SET b=b+10;
139 ERROR 23000: Duplicate entry '<duplicate entry>' for key 't1.b'
140 BEGIN;
141 UPDATE t1 SET b=b+10 LIMIT 20;
142 ERROR 23000: Duplicate entry '<duplicate entry>' for key 't1.b'
143 DROP TABLE t1;