Debian Codegraph @

mysql-test/suite/engines/funcs/t/up_multi_db_table.test

raw
1 --disable_warnings
2 DROP DATABASE IF EXISTS d1;
3 DROP DATABASE IF EXISTS d2;
4 DROP DATABASE IF EXISTS d3;
5 --enable_warnings
6 CREATE DATABASE d1;
7 CREATE DATABASE d2;
8 CREATE DATABASE d3;
9 CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
10 CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
11 CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
12 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
13 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
14 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
15 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
16 SELECT * FROM d1.t1 ORDER BY c1;
17 SELECT * FROM d2.t2 ORDER BY c1;
18 SELECT * FROM d3.t3 ORDER BY c1;
19 DROP DATABASE d1;
20 DROP DATABASE d2;
21 DROP DATABASE d3;
22 CREATE DATABASE d1;
23 CREATE DATABASE d2;
24 CREATE DATABASE d3;
25 CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
26 CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
27 CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
28 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
29 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
30 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
31 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
32 SELECT * FROM d1.t1 ORDER BY c1;
33 SELECT * FROM d2.t2 ORDER BY c1;
34 SELECT * FROM d3.t3 ORDER BY c1;
35 DROP DATABASE d1;
36 DROP DATABASE d2;
37 DROP DATABASE d3;
38 CREATE DATABASE d1;
39 CREATE DATABASE d2;
40 CREATE DATABASE d3;
41 CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
42 CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
43 CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
44 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
45 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
46 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
47 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
48 SELECT * FROM d1.t1 ORDER BY c1;
49 SELECT * FROM d2.t2 ORDER BY c1;
50 SELECT * FROM d3.t3 ORDER BY c1;
51 DROP DATABASE d1;
52 DROP DATABASE d2;
53 DROP DATABASE d3;
54 CREATE DATABASE d1;
55 CREATE DATABASE d2;
56 CREATE DATABASE d3;
57 CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
58 CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
59 CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
60 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
61 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
62 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
63 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
64 SELECT * FROM d1.t1 ORDER BY c1;
65 SELECT * FROM d2.t2 ORDER BY c1;
66 SELECT * FROM d3.t3 ORDER BY c1;
67 DROP DATABASE d1;
68 DROP DATABASE d2;
69 DROP DATABASE d3;
70 CREATE DATABASE d1;
71 CREATE DATABASE d2;
72 CREATE DATABASE d3;
73 CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
74 CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
75 CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
76 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
77 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
78 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
79 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
80 SELECT * FROM d1.t1 ORDER BY c1;
81 SELECT * FROM d2.t2 ORDER BY c1;
82 SELECT * FROM d3.t3 ORDER BY c1;
83 DROP DATABASE d1;
84 DROP DATABASE d2;
85 DROP DATABASE d3;
86 CREATE DATABASE d1;
87 CREATE DATABASE d2;
88 CREATE DATABASE d3;
89 CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
90 CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
91 CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
92 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
93 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
94 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
95 UPDATE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
96 SELECT * FROM d1.t1 ORDER BY c1;
97 SELECT * FROM d2.t2 ORDER BY c1;
98 SELECT * FROM d3.t3 ORDER BY c1;
99 DROP DATABASE d1;
100 DROP DATABASE d2;
101 DROP DATABASE d3;
102 CREATE DATABASE d1;
103 CREATE DATABASE d2;
104 CREATE DATABASE d3;
105 CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
106 CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
107 CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
108 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
109 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
110 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
111 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
112 SELECT * FROM d1.t1 ORDER BY c1;
113 SELECT * FROM d2.t2 ORDER BY c1;
114 SELECT * FROM d3.t3 ORDER BY c1;
115 DROP DATABASE d1;
116 DROP DATABASE d2;
117 DROP DATABASE d3;
118 CREATE DATABASE d1;
119 CREATE DATABASE d2;
120 CREATE DATABASE d3;
121 CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
122 CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
123 CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
124 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
125 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
126 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
127 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
128 SELECT * FROM d1.t1 ORDER BY c1;
129 SELECT * FROM d2.t2 ORDER BY c1;
130 SELECT * FROM d3.t3 ORDER BY c1;
131 DROP DATABASE d1;
132 DROP DATABASE d2;
133 DROP DATABASE d3;
134 CREATE DATABASE d1;
135 CREATE DATABASE d2;
136 CREATE DATABASE d3;
137 CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
138 CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
139 CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
140 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
141 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
142 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
143 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
144 SELECT * FROM d1.t1 ORDER BY c1;
145 SELECT * FROM d2.t2 ORDER BY c1;
146 SELECT * FROM d3.t3 ORDER BY c1;
147 DROP DATABASE d1;
148 DROP DATABASE d2;
149 DROP DATABASE d3;
150 CREATE DATABASE d1;
151 CREATE DATABASE d2;
152 CREATE DATABASE d3;
153 CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
154 CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
155 CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
156 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
157 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
158 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
159 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
160 SELECT * FROM d1.t1 ORDER BY c1;
161 SELECT * FROM d2.t2 ORDER BY c1;
162 SELECT * FROM d3.t3 ORDER BY c1;
163 DROP DATABASE d1;
164 DROP DATABASE d2;
165 DROP DATABASE d3;
166 CREATE DATABASE d1;
167 CREATE DATABASE d2;
168 CREATE DATABASE d3;
169 CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
170 CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
171 CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
172 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
173 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
174 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
175 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
176 SELECT * FROM d1.t1 ORDER BY c1;
177 SELECT * FROM d2.t2 ORDER BY c1;
178 SELECT * FROM d3.t3 ORDER BY c1;
179 DROP DATABASE d1;
180 DROP DATABASE d2;
181 DROP DATABASE d3;
182 CREATE DATABASE d1;
183 CREATE DATABASE d2;
184 CREATE DATABASE d3;
185 CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
186 CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
187 CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
188 INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
189 INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
190 INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
191 UPDATE IGNORE d1.t1, d2.t2, d3.t3 SET d1.t1.c2=30, d2.t2.c2=40, d3.t3.c2=50 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2;
192 SELECT * FROM d1.t1 ORDER BY c1;
193 SELECT * FROM d2.t2 ORDER BY c1;
194 SELECT * FROM d3.t3 ORDER BY c1;
195 DROP DATABASE d1;
196 DROP DATABASE d2;
197 DROP DATABASE d3;
198