2
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6;
4
CREATE TABLE t1 (c1 TINYINT NOT NULL);
5
CREATE TABLE t2 (c1 TINYINT NOT NULL);
6
CREATE TABLE t3 (c1 TINYINT NOT NULL);
7
CREATE TABLE t4 (c1 TINYINT NOT NULL);
8
CREATE TABLE t5 (c1 TINYINT NOT NULL);
9
CREATE TABLE t6 (c1 TINYINT NOT NULL);
10
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
11
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
12
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
13
INSERT INTO t4 (c1) VALUES(10);
14
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
15
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
16
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
17
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
18
DROP TABLE t1,t2,t3,t4,t5,t6;
19
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
20
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
21
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
22
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
23
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
24
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
25
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
26
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
27
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
28
INSERT INTO t4 (c1) VALUES(10);
29
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
30
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
31
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
32
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
33
DROP TABLE t1,t2,t3,t4,t5,t6;
34
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
35
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
36
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
37
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
38
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
39
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
40
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
41
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
42
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
43
INSERT INTO t4 (c1) VALUES(10);
44
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
45
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
46
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
47
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
48
DROP TABLE t1,t2,t3,t4,t5,t6;
49
CREATE TABLE t1 (c1 INT NOT NULL);
50
CREATE TABLE t2 (c1 INT NOT NULL);
51
CREATE TABLE t3 (c1 INT NOT NULL);
52
CREATE TABLE t4 (c1 INT NOT NULL);
53
CREATE TABLE t5 (c1 INT NOT NULL);
54
CREATE TABLE t6 (c1 INT NOT NULL);
55
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
56
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
57
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
58
INSERT INTO t4 (c1) VALUES(10);
59
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
60
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
61
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
62
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
63
DROP TABLE t1,t2,t3,t4,t5,t6;
64
CREATE TABLE t1 (c1 INTEGER NOT NULL);
65
CREATE TABLE t2 (c1 INTEGER NOT NULL);
66
CREATE TABLE t3 (c1 INTEGER NOT NULL);
67
CREATE TABLE t4 (c1 INTEGER NOT NULL);
68
CREATE TABLE t5 (c1 INTEGER NOT NULL);
69
CREATE TABLE t6 (c1 INTEGER NOT NULL);
70
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
71
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
72
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
73
INSERT INTO t4 (c1) VALUES(10);
74
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
75
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
76
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
77
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
78
DROP TABLE t1,t2,t3,t4,t5,t6;
79
CREATE TABLE t1 (c1 BIGINT NOT NULL);
80
CREATE TABLE t2 (c1 BIGINT NOT NULL);
81
CREATE TABLE t3 (c1 BIGINT NOT NULL);
82
CREATE TABLE t4 (c1 BIGINT NOT NULL);
83
CREATE TABLE t5 (c1 BIGINT NOT NULL);
84
CREATE TABLE t6 (c1 BIGINT NOT NULL);
85
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
86
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
87
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
88
INSERT INTO t4 (c1) VALUES(10);
89
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
90
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
91
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
92
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 < 5;
93
DROP TABLE t1,t2,t3,t4,t5,t6;
94
CREATE TABLE t1 (c1 TINYINT NOT NULL);
95
CREATE TABLE t2 (c1 TINYINT NOT NULL);
96
CREATE TABLE t3 (c1 TINYINT NOT NULL);
97
CREATE TABLE t4 (c1 TINYINT NOT NULL);
98
CREATE TABLE t5 (c1 TINYINT NOT NULL);
99
CREATE TABLE t6 (c1 TINYINT NOT NULL);
100
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
101
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
102
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
103
INSERT INTO t4 (c1) VALUES(10);
104
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
105
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
106
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
107
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
108
DROP TABLE t1,t2,t3,t4,t5,t6;
109
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
110
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
111
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
112
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
113
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
114
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
115
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
116
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
117
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
118
INSERT INTO t4 (c1) VALUES(10);
119
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
120
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
121
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
122
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
123
DROP TABLE t1,t2,t3,t4,t5,t6;
124
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
125
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
126
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
127
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
128
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
129
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
130
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
131
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
132
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
133
INSERT INTO t4 (c1) VALUES(10);
134
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
135
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
136
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
137
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
138
DROP TABLE t1,t2,t3,t4,t5,t6;
139
CREATE TABLE t1 (c1 INT NOT NULL);
140
CREATE TABLE t2 (c1 INT NOT NULL);
141
CREATE TABLE t3 (c1 INT NOT NULL);
142
CREATE TABLE t4 (c1 INT NOT NULL);
143
CREATE TABLE t5 (c1 INT NOT NULL);
144
CREATE TABLE t6 (c1 INT NOT NULL);
145
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
146
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
147
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
148
INSERT INTO t4 (c1) VALUES(10);
149
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
150
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
151
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
152
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
153
DROP TABLE t1,t2,t3,t4,t5,t6;
154
CREATE TABLE t1 (c1 INTEGER NOT NULL);
155
CREATE TABLE t2 (c1 INTEGER NOT NULL);
156
CREATE TABLE t3 (c1 INTEGER NOT NULL);
157
CREATE TABLE t4 (c1 INTEGER NOT NULL);
158
CREATE TABLE t5 (c1 INTEGER NOT NULL);
159
CREATE TABLE t6 (c1 INTEGER NOT NULL);
160
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
161
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
162
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
163
INSERT INTO t4 (c1) VALUES(10);
164
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
165
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
166
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
167
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
168
DROP TABLE t1,t2,t3,t4,t5,t6;
169
CREATE TABLE t1 (c1 BIGINT NOT NULL);
170
CREATE TABLE t2 (c1 BIGINT NOT NULL);
171
CREATE TABLE t3 (c1 BIGINT NOT NULL);
172
CREATE TABLE t4 (c1 BIGINT NOT NULL);
173
CREATE TABLE t5 (c1 BIGINT NOT NULL);
174
CREATE TABLE t6 (c1 BIGINT NOT NULL);
175
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
176
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
177
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
178
INSERT INTO t4 (c1) VALUES(10);
179
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
180
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
181
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
182
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 < 5;
183
DROP TABLE t1,t2,t3,t4,t5,t6;
184
CREATE TABLE t1 (c1 TINYINT NOT NULL);
185
CREATE TABLE t2 (c1 TINYINT NOT NULL);
186
CREATE TABLE t3 (c1 TINYINT NOT NULL);
187
CREATE TABLE t4 (c1 TINYINT NOT NULL);
188
CREATE TABLE t5 (c1 TINYINT NOT NULL);
189
CREATE TABLE t6 (c1 TINYINT NOT NULL);
190
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
191
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
192
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
193
INSERT INTO t4 (c1) VALUES(10);
194
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
195
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
196
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
197
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
198
DROP TABLE t1,t2,t3,t4,t5,t6;
199
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
200
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
201
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
202
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
203
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
204
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
205
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
206
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
207
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
208
INSERT INTO t4 (c1) VALUES(10);
209
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
210
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
211
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
212
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
213
DROP TABLE t1,t2,t3,t4,t5,t6;
214
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
215
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
216
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
217
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
218
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
219
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
220
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
221
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
222
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
223
INSERT INTO t4 (c1) VALUES(10);
224
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
225
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
226
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
227
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
228
DROP TABLE t1,t2,t3,t4,t5,t6;
229
CREATE TABLE t1 (c1 INT NOT NULL);
230
CREATE TABLE t2 (c1 INT NOT NULL);
231
CREATE TABLE t3 (c1 INT NOT NULL);
232
CREATE TABLE t4 (c1 INT NOT NULL);
233
CREATE TABLE t5 (c1 INT NOT NULL);
234
CREATE TABLE t6 (c1 INT NOT NULL);
235
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
236
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
237
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
238
INSERT INTO t4 (c1) VALUES(10);
239
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
240
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
241
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
242
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
243
DROP TABLE t1,t2,t3,t4,t5,t6;
244
CREATE TABLE t1 (c1 INTEGER NOT NULL);
245
CREATE TABLE t2 (c1 INTEGER NOT NULL);
246
CREATE TABLE t3 (c1 INTEGER NOT NULL);
247
CREATE TABLE t4 (c1 INTEGER NOT NULL);
248
CREATE TABLE t5 (c1 INTEGER NOT NULL);
249
CREATE TABLE t6 (c1 INTEGER NOT NULL);
250
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
251
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
252
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
253
INSERT INTO t4 (c1) VALUES(10);
254
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
255
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
256
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
257
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
258
DROP TABLE t1,t2,t3,t4,t5,t6;
259
CREATE TABLE t1 (c1 BIGINT NOT NULL);
260
CREATE TABLE t2 (c1 BIGINT NOT NULL);
261
CREATE TABLE t3 (c1 BIGINT NOT NULL);
262
CREATE TABLE t4 (c1 BIGINT NOT NULL);
263
CREATE TABLE t5 (c1 BIGINT NOT NULL);
264
CREATE TABLE t6 (c1 BIGINT NOT NULL);
265
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
266
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
267
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
268
INSERT INTO t4 (c1) VALUES(10);
269
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
270
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
271
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
272
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 < 5;
273
DROP TABLE t1,t2,t3,t4,t5,t6;
274
CREATE TABLE t1 (c1 TINYINT NOT NULL);
275
CREATE TABLE t2 (c1 TINYINT NOT NULL);
276
CREATE TABLE t3 (c1 TINYINT NOT NULL);
277
CREATE TABLE t4 (c1 TINYINT NOT NULL);
278
CREATE TABLE t5 (c1 TINYINT NOT NULL);
279
CREATE TABLE t6 (c1 TINYINT NOT NULL);
280
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
281
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
282
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
283
INSERT INTO t4 (c1) VALUES(10);
284
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
285
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
286
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
287
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
288
DROP TABLE t1,t2,t3,t4,t5,t6;
289
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
290
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
291
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
292
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
293
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
294
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
295
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
296
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
297
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
298
INSERT INTO t4 (c1) VALUES(10);
299
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
300
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
301
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
302
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
303
DROP TABLE t1,t2,t3,t4,t5,t6;
304
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
305
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
306
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
307
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
308
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
309
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
310
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
311
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
312
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
313
INSERT INTO t4 (c1) VALUES(10);
314
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
315
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
316
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
317
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
318
DROP TABLE t1,t2,t3,t4,t5,t6;
319
CREATE TABLE t1 (c1 INT NOT NULL);
320
CREATE TABLE t2 (c1 INT NOT NULL);
321
CREATE TABLE t3 (c1 INT NOT NULL);
322
CREATE TABLE t4 (c1 INT NOT NULL);
323
CREATE TABLE t5 (c1 INT NOT NULL);
324
CREATE TABLE t6 (c1 INT NOT NULL);
325
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
326
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
327
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
328
INSERT INTO t4 (c1) VALUES(10);
329
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
330
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
331
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
332
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
333
DROP TABLE t1,t2,t3,t4,t5,t6;
334
CREATE TABLE t1 (c1 INTEGER NOT NULL);
335
CREATE TABLE t2 (c1 INTEGER NOT NULL);
336
CREATE TABLE t3 (c1 INTEGER NOT NULL);
337
CREATE TABLE t4 (c1 INTEGER NOT NULL);
338
CREATE TABLE t5 (c1 INTEGER NOT NULL);
339
CREATE TABLE t6 (c1 INTEGER NOT NULL);
340
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
341
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
342
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
343
INSERT INTO t4 (c1) VALUES(10);
344
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
345
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
346
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
347
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
348
DROP TABLE t1,t2,t3,t4,t5,t6;
349
CREATE TABLE t1 (c1 BIGINT NOT NULL);
350
CREATE TABLE t2 (c1 BIGINT NOT NULL);
351
CREATE TABLE t3 (c1 BIGINT NOT NULL);
352
CREATE TABLE t4 (c1 BIGINT NOT NULL);
353
CREATE TABLE t5 (c1 BIGINT NOT NULL);
354
CREATE TABLE t6 (c1 BIGINT NOT NULL);
355
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
356
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
357
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
358
INSERT INTO t4 (c1) VALUES(10);
359
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
360
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
361
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
362
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 < 5;
363
DROP TABLE t1,t2,t3,t4,t5,t6;
364
CREATE TABLE t1 (c1 TINYINT NOT NULL);
365
CREATE TABLE t2 (c1 TINYINT NOT NULL);
366
CREATE TABLE t3 (c1 TINYINT NOT NULL);
367
CREATE TABLE t4 (c1 TINYINT NOT NULL);
368
CREATE TABLE t5 (c1 TINYINT NOT NULL);
369
CREATE TABLE t6 (c1 TINYINT NOT NULL);
370
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
371
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
372
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
373
INSERT INTO t4 (c1) VALUES(10);
374
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
375
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
376
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
377
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
378
DROP TABLE t1,t2,t3,t4,t5,t6;
379
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
380
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
381
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
382
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
383
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
384
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
385
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
386
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
387
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
388
INSERT INTO t4 (c1) VALUES(10);
389
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
390
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
391
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
392
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
393
DROP TABLE t1,t2,t3,t4,t5,t6;
394
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
395
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
396
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
397
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
398
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
399
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
400
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
401
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
402
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
403
INSERT INTO t4 (c1) VALUES(10);
404
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
405
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
406
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
407
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
408
DROP TABLE t1,t2,t3,t4,t5,t6;
409
CREATE TABLE t1 (c1 INT NOT NULL);
410
CREATE TABLE t2 (c1 INT NOT NULL);
411
CREATE TABLE t3 (c1 INT NOT NULL);
412
CREATE TABLE t4 (c1 INT NOT NULL);
413
CREATE TABLE t5 (c1 INT NOT NULL);
414
CREATE TABLE t6 (c1 INT NOT NULL);
415
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
416
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
417
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
418
INSERT INTO t4 (c1) VALUES(10);
419
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
420
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
421
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
422
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
423
DROP TABLE t1,t2,t3,t4,t5,t6;
424
CREATE TABLE t1 (c1 INTEGER NOT NULL);
425
CREATE TABLE t2 (c1 INTEGER NOT NULL);
426
CREATE TABLE t3 (c1 INTEGER NOT NULL);
427
CREATE TABLE t4 (c1 INTEGER NOT NULL);
428
CREATE TABLE t5 (c1 INTEGER NOT NULL);
429
CREATE TABLE t6 (c1 INTEGER NOT NULL);
430
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
431
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
432
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
433
INSERT INTO t4 (c1) VALUES(10);
434
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
435
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
436
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
437
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
438
DROP TABLE t1,t2,t3,t4,t5,t6;
439
CREATE TABLE t1 (c1 BIGINT NOT NULL);
440
CREATE TABLE t2 (c1 BIGINT NOT NULL);
441
CREATE TABLE t3 (c1 BIGINT NOT NULL);
442
CREATE TABLE t4 (c1 BIGINT NOT NULL);
443
CREATE TABLE t5 (c1 BIGINT NOT NULL);
444
CREATE TABLE t6 (c1 BIGINT NOT NULL);
445
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
446
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
448
INSERT INTO t4 (c1) VALUES(10);
449
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
450
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
451
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
452
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 < 5;
453
DROP TABLE t1,t2,t3,t4,t5,t6;
454
CREATE TABLE t1 (c1 TINYINT NOT NULL);
455
CREATE TABLE t2 (c1 TINYINT NOT NULL);
456
CREATE TABLE t3 (c1 TINYINT NOT NULL);
457
CREATE TABLE t4 (c1 TINYINT NOT NULL);
458
CREATE TABLE t5 (c1 TINYINT NOT NULL);
459
CREATE TABLE t6 (c1 TINYINT NOT NULL);
460
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
461
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
462
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
463
INSERT INTO t4 (c1) VALUES(10);
464
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
465
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
466
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
467
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
468
DROP TABLE t1,t2,t3,t4,t5,t6;
469
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
470
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
471
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
472
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
473
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
474
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
475
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
476
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
477
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
478
INSERT INTO t4 (c1) VALUES(10);
479
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
480
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
481
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
482
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
483
DROP TABLE t1,t2,t3,t4,t5,t6;
484
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
485
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
486
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
487
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
488
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
489
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
490
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
491
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
492
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
493
INSERT INTO t4 (c1) VALUES(10);
494
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
495
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
496
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
497
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
498
DROP TABLE t1,t2,t3,t4,t5,t6;
499
CREATE TABLE t1 (c1 INT NOT NULL);
500
CREATE TABLE t2 (c1 INT NOT NULL);
501
CREATE TABLE t3 (c1 INT NOT NULL);
502
CREATE TABLE t4 (c1 INT NOT NULL);
503
CREATE TABLE t5 (c1 INT NOT NULL);
504
CREATE TABLE t6 (c1 INT NOT NULL);
505
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
506
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
507
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
508
INSERT INTO t4 (c1) VALUES(10);
509
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
510
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
511
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
512
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
513
DROP TABLE t1,t2,t3,t4,t5,t6;
514
CREATE TABLE t1 (c1 INTEGER NOT NULL);
515
CREATE TABLE t2 (c1 INTEGER NOT NULL);
516
CREATE TABLE t3 (c1 INTEGER NOT NULL);
517
CREATE TABLE t4 (c1 INTEGER NOT NULL);
518
CREATE TABLE t5 (c1 INTEGER NOT NULL);
519
CREATE TABLE t6 (c1 INTEGER NOT NULL);
520
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
521
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
522
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
523
INSERT INTO t4 (c1) VALUES(10);
524
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
525
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
526
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
527
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
528
DROP TABLE t1,t2,t3,t4,t5,t6;
529
CREATE TABLE t1 (c1 BIGINT NOT NULL);
530
CREATE TABLE t2 (c1 BIGINT NOT NULL);
531
CREATE TABLE t3 (c1 BIGINT NOT NULL);
532
CREATE TABLE t4 (c1 BIGINT NOT NULL);
533
CREATE TABLE t5 (c1 BIGINT NOT NULL);
534
CREATE TABLE t6 (c1 BIGINT NOT NULL);
535
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
536
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
538
INSERT INTO t4 (c1) VALUES(10);
539
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
540
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
541
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
542
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <= 5;
543
DROP TABLE t1,t2,t3,t4,t5,t6;
544
CREATE TABLE t1 (c1 TINYINT NOT NULL);
545
CREATE TABLE t2 (c1 TINYINT NOT NULL);
546
CREATE TABLE t3 (c1 TINYINT NOT NULL);
547
CREATE TABLE t4 (c1 TINYINT NOT NULL);
548
CREATE TABLE t5 (c1 TINYINT NOT NULL);
549
CREATE TABLE t6 (c1 TINYINT NOT NULL);
550
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
551
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
552
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
553
INSERT INTO t4 (c1) VALUES(10);
554
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
555
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
556
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
557
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
558
DROP TABLE t1,t2,t3,t4,t5,t6;
559
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
560
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
561
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
562
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
563
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
564
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
565
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
566
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
567
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
568
INSERT INTO t4 (c1) VALUES(10);
569
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
570
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
571
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
572
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
573
DROP TABLE t1,t2,t3,t4,t5,t6;
574
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
575
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
576
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
577
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
578
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
579
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
580
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
581
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
582
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
583
INSERT INTO t4 (c1) VALUES(10);
584
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
585
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
586
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
587
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
588
DROP TABLE t1,t2,t3,t4,t5,t6;
589
CREATE TABLE t1 (c1 INT NOT NULL);
590
CREATE TABLE t2 (c1 INT NOT NULL);
591
CREATE TABLE t3 (c1 INT NOT NULL);
592
CREATE TABLE t4 (c1 INT NOT NULL);
593
CREATE TABLE t5 (c1 INT NOT NULL);
594
CREATE TABLE t6 (c1 INT NOT NULL);
595
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
596
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
597
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
598
INSERT INTO t4 (c1) VALUES(10);
599
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
600
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
601
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
602
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
603
DROP TABLE t1,t2,t3,t4,t5,t6;
604
CREATE TABLE t1 (c1 INTEGER NOT NULL);
605
CREATE TABLE t2 (c1 INTEGER NOT NULL);
606
CREATE TABLE t3 (c1 INTEGER NOT NULL);
607
CREATE TABLE t4 (c1 INTEGER NOT NULL);
608
CREATE TABLE t5 (c1 INTEGER NOT NULL);
609
CREATE TABLE t6 (c1 INTEGER NOT NULL);
610
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
611
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
612
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
613
INSERT INTO t4 (c1) VALUES(10);
614
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
615
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
616
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
617
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
618
DROP TABLE t1,t2,t3,t4,t5,t6;
619
CREATE TABLE t1 (c1 BIGINT NOT NULL);
620
CREATE TABLE t2 (c1 BIGINT NOT NULL);
621
CREATE TABLE t3 (c1 BIGINT NOT NULL);
622
CREATE TABLE t4 (c1 BIGINT NOT NULL);
623
CREATE TABLE t5 (c1 BIGINT NOT NULL);
624
CREATE TABLE t6 (c1 BIGINT NOT NULL);
625
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
626
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
627
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
628
INSERT INTO t4 (c1) VALUES(10);
629
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
630
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
631
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
632
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <= 5;
633
DROP TABLE t1,t2,t3,t4,t5,t6;
634
CREATE TABLE t1 (c1 TINYINT NOT NULL);
635
CREATE TABLE t2 (c1 TINYINT NOT NULL);
636
CREATE TABLE t3 (c1 TINYINT NOT NULL);
637
CREATE TABLE t4 (c1 TINYINT NOT NULL);
638
CREATE TABLE t5 (c1 TINYINT NOT NULL);
639
CREATE TABLE t6 (c1 TINYINT NOT NULL);
640
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
641
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
642
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
643
INSERT INTO t4 (c1) VALUES(10);
644
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
645
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
646
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
647
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
648
DROP TABLE t1,t2,t3,t4,t5,t6;
649
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
650
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
651
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
652
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
653
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
654
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
655
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
656
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
657
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
658
INSERT INTO t4 (c1) VALUES(10);
659
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
660
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
661
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
662
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
663
DROP TABLE t1,t2,t3,t4,t5,t6;
664
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
665
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
666
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
667
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
668
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
669
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
670
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
671
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
672
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
673
INSERT INTO t4 (c1) VALUES(10);
674
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
675
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
676
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
677
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
678
DROP TABLE t1,t2,t3,t4,t5,t6;
679
CREATE TABLE t1 (c1 INT NOT NULL);
680
CREATE TABLE t2 (c1 INT NOT NULL);
681
CREATE TABLE t3 (c1 INT NOT NULL);
682
CREATE TABLE t4 (c1 INT NOT NULL);
683
CREATE TABLE t5 (c1 INT NOT NULL);
684
CREATE TABLE t6 (c1 INT NOT NULL);
685
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
686
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
687
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
688
INSERT INTO t4 (c1) VALUES(10);
689
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
690
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
691
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
692
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
693
DROP TABLE t1,t2,t3,t4,t5,t6;
694
CREATE TABLE t1 (c1 INTEGER NOT NULL);
695
CREATE TABLE t2 (c1 INTEGER NOT NULL);
696
CREATE TABLE t3 (c1 INTEGER NOT NULL);
697
CREATE TABLE t4 (c1 INTEGER NOT NULL);
698
CREATE TABLE t5 (c1 INTEGER NOT NULL);
699
CREATE TABLE t6 (c1 INTEGER NOT NULL);
700
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
701
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
702
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
703
INSERT INTO t4 (c1) VALUES(10);
704
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
705
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
706
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
707
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
708
DROP TABLE t1,t2,t3,t4,t5,t6;
709
CREATE TABLE t1 (c1 BIGINT NOT NULL);
710
CREATE TABLE t2 (c1 BIGINT NOT NULL);
711
CREATE TABLE t3 (c1 BIGINT NOT NULL);
712
CREATE TABLE t4 (c1 BIGINT NOT NULL);
713
CREATE TABLE t5 (c1 BIGINT NOT NULL);
714
CREATE TABLE t6 (c1 BIGINT NOT NULL);
715
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
716
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
717
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
718
INSERT INTO t4 (c1) VALUES(10);
719
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
720
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
721
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
722
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <= 5;
723
DROP TABLE t1,t2,t3,t4,t5,t6;
724
CREATE TABLE t1 (c1 TINYINT NOT NULL);
725
CREATE TABLE t2 (c1 TINYINT NOT NULL);
726
CREATE TABLE t3 (c1 TINYINT NOT NULL);
727
CREATE TABLE t4 (c1 TINYINT NOT NULL);
728
CREATE TABLE t5 (c1 TINYINT NOT NULL);
729
CREATE TABLE t6 (c1 TINYINT NOT NULL);
730
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
731
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
732
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
733
INSERT INTO t4 (c1) VALUES(10);
734
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
735
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
736
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
737
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
738
DROP TABLE t1,t2,t3,t4,t5,t6;
739
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
740
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
741
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
742
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
743
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
744
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
745
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
746
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
747
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
748
INSERT INTO t4 (c1) VALUES(10);
749
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
750
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
751
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
752
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
753
DROP TABLE t1,t2,t3,t4,t5,t6;
754
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
755
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
756
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
757
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
758
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
759
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
760
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
761
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
762
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
763
INSERT INTO t4 (c1) VALUES(10);
764
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
765
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
766
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
767
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
768
DROP TABLE t1,t2,t3,t4,t5,t6;
769
CREATE TABLE t1 (c1 INT NOT NULL);
770
CREATE TABLE t2 (c1 INT NOT NULL);
771
CREATE TABLE t3 (c1 INT NOT NULL);
772
CREATE TABLE t4 (c1 INT NOT NULL);
773
CREATE TABLE t5 (c1 INT NOT NULL);
774
CREATE TABLE t6 (c1 INT NOT NULL);
775
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
776
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
777
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
778
INSERT INTO t4 (c1) VALUES(10);
779
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
780
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
781
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
782
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
783
DROP TABLE t1,t2,t3,t4,t5,t6;
784
CREATE TABLE t1 (c1 INTEGER NOT NULL);
785
CREATE TABLE t2 (c1 INTEGER NOT NULL);
786
CREATE TABLE t3 (c1 INTEGER NOT NULL);
787
CREATE TABLE t4 (c1 INTEGER NOT NULL);
788
CREATE TABLE t5 (c1 INTEGER NOT NULL);
789
CREATE TABLE t6 (c1 INTEGER NOT NULL);
790
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
791
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
792
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
793
INSERT INTO t4 (c1) VALUES(10);
794
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
795
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
796
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
797
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
798
DROP TABLE t1,t2,t3,t4,t5,t6;
799
CREATE TABLE t1 (c1 BIGINT NOT NULL);
800
CREATE TABLE t2 (c1 BIGINT NOT NULL);
801
CREATE TABLE t3 (c1 BIGINT NOT NULL);
802
CREATE TABLE t4 (c1 BIGINT NOT NULL);
803
CREATE TABLE t5 (c1 BIGINT NOT NULL);
804
CREATE TABLE t6 (c1 BIGINT NOT NULL);
805
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
806
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
807
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
808
INSERT INTO t4 (c1) VALUES(10);
809
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
810
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
811
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
812
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <= 5;
813
DROP TABLE t1,t2,t3,t4,t5,t6;
814
CREATE TABLE t1 (c1 TINYINT NOT NULL);
815
CREATE TABLE t2 (c1 TINYINT NOT NULL);
816
CREATE TABLE t3 (c1 TINYINT NOT NULL);
817
CREATE TABLE t4 (c1 TINYINT NOT NULL);
818
CREATE TABLE t5 (c1 TINYINT NOT NULL);
819
CREATE TABLE t6 (c1 TINYINT NOT NULL);
820
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
821
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
822
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
823
INSERT INTO t4 (c1) VALUES(10);
824
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
825
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
826
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
827
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
828
DROP TABLE t1,t2,t3,t4,t5,t6;
829
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
830
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
831
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
832
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
833
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
834
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
835
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
836
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
837
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
838
INSERT INTO t4 (c1) VALUES(10);
839
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
840
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
841
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
842
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
843
DROP TABLE t1,t2,t3,t4,t5,t6;
844
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
845
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
846
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
847
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
848
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
849
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
850
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
851
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
852
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
853
INSERT INTO t4 (c1) VALUES(10);
854
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
855
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
856
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
857
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
858
DROP TABLE t1,t2,t3,t4,t5,t6;
859
CREATE TABLE t1 (c1 INT NOT NULL);
860
CREATE TABLE t2 (c1 INT NOT NULL);
861
CREATE TABLE t3 (c1 INT NOT NULL);
862
CREATE TABLE t4 (c1 INT NOT NULL);
863
CREATE TABLE t5 (c1 INT NOT NULL);
864
CREATE TABLE t6 (c1 INT NOT NULL);
865
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
866
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
867
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
868
INSERT INTO t4 (c1) VALUES(10);
869
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
870
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
871
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
872
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
873
DROP TABLE t1,t2,t3,t4,t5,t6;
874
CREATE TABLE t1 (c1 INTEGER NOT NULL);
875
CREATE TABLE t2 (c1 INTEGER NOT NULL);
876
CREATE TABLE t3 (c1 INTEGER NOT NULL);
877
CREATE TABLE t4 (c1 INTEGER NOT NULL);
878
CREATE TABLE t5 (c1 INTEGER NOT NULL);
879
CREATE TABLE t6 (c1 INTEGER NOT NULL);
880
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
881
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
882
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
883
INSERT INTO t4 (c1) VALUES(10);
884
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
885
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
886
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
887
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
888
DROP TABLE t1,t2,t3,t4,t5,t6;
889
CREATE TABLE t1 (c1 BIGINT NOT NULL);
890
CREATE TABLE t2 (c1 BIGINT NOT NULL);
891
CREATE TABLE t3 (c1 BIGINT NOT NULL);
892
CREATE TABLE t4 (c1 BIGINT NOT NULL);
893
CREATE TABLE t5 (c1 BIGINT NOT NULL);
894
CREATE TABLE t6 (c1 BIGINT NOT NULL);
895
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
896
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
897
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
898
INSERT INTO t4 (c1) VALUES(10);
899
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
900
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
901
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
902
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <= 5;
903
DROP TABLE t1,t2,t3,t4,t5,t6;
904
CREATE TABLE t1 (c1 TINYINT NOT NULL);
905
CREATE TABLE t2 (c1 TINYINT NOT NULL);
906
CREATE TABLE t3 (c1 TINYINT NOT NULL);
907
CREATE TABLE t4 (c1 TINYINT NOT NULL);
908
CREATE TABLE t5 (c1 TINYINT NOT NULL);
909
CREATE TABLE t6 (c1 TINYINT NOT NULL);
910
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
911
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
912
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
913
INSERT INTO t4 (c1) VALUES(10);
914
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
915
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
916
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
917
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
918
DROP TABLE t1,t2,t3,t4,t5,t6;
919
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
920
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
921
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
922
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
923
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
924
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
925
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
926
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
927
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
928
INSERT INTO t4 (c1) VALUES(10);
929
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
930
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
931
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
932
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
933
DROP TABLE t1,t2,t3,t4,t5,t6;
934
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
935
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
936
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
937
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
938
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
939
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
940
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
941
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
942
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
943
INSERT INTO t4 (c1) VALUES(10);
944
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
945
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
946
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
947
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
948
DROP TABLE t1,t2,t3,t4,t5,t6;
949
CREATE TABLE t1 (c1 INT NOT NULL);
950
CREATE TABLE t2 (c1 INT NOT NULL);
951
CREATE TABLE t3 (c1 INT NOT NULL);
952
CREATE TABLE t4 (c1 INT NOT NULL);
953
CREATE TABLE t5 (c1 INT NOT NULL);
954
CREATE TABLE t6 (c1 INT NOT NULL);
955
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
956
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
957
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
958
INSERT INTO t4 (c1) VALUES(10);
959
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
960
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
961
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
962
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
963
DROP TABLE t1,t2,t3,t4,t5,t6;
964
CREATE TABLE t1 (c1 INTEGER NOT NULL);
965
CREATE TABLE t2 (c1 INTEGER NOT NULL);
966
CREATE TABLE t3 (c1 INTEGER NOT NULL);
967
CREATE TABLE t4 (c1 INTEGER NOT NULL);
968
CREATE TABLE t5 (c1 INTEGER NOT NULL);
969
CREATE TABLE t6 (c1 INTEGER NOT NULL);
970
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
971
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
972
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
973
INSERT INTO t4 (c1) VALUES(10);
974
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
975
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
976
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
977
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
978
DROP TABLE t1,t2,t3,t4,t5,t6;
979
CREATE TABLE t1 (c1 BIGINT NOT NULL);
980
CREATE TABLE t2 (c1 BIGINT NOT NULL);
981
CREATE TABLE t3 (c1 BIGINT NOT NULL);
982
CREATE TABLE t4 (c1 BIGINT NOT NULL);
983
CREATE TABLE t5 (c1 BIGINT NOT NULL);
984
CREATE TABLE t6 (c1 BIGINT NOT NULL);
985
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
986
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
987
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
988
INSERT INTO t4 (c1) VALUES(10);
989
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
990
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
991
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
992
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 = 5;
993
DROP TABLE t1,t2,t3,t4,t5,t6;
994
CREATE TABLE t1 (c1 TINYINT NOT NULL);
995
CREATE TABLE t2 (c1 TINYINT NOT NULL);
996
CREATE TABLE t3 (c1 TINYINT NOT NULL);
997
CREATE TABLE t4 (c1 TINYINT NOT NULL);
998
CREATE TABLE t5 (c1 TINYINT NOT NULL);
999
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1000
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1001
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1002
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1003
INSERT INTO t4 (c1) VALUES(10);
1004
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1005
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1006
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1007
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1008
DROP TABLE t1,t2,t3,t4,t5,t6;
1009
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1010
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1011
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1012
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1013
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1014
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1015
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1016
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1017
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1018
INSERT INTO t4 (c1) VALUES(10);
1019
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1020
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1021
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1022
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1023
DROP TABLE t1,t2,t3,t4,t5,t6;
1024
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1025
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1026
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1027
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1028
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1029
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1030
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1031
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1032
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1033
INSERT INTO t4 (c1) VALUES(10);
1034
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1035
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1036
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1037
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1038
DROP TABLE t1,t2,t3,t4,t5,t6;
1039
CREATE TABLE t1 (c1 INT NOT NULL);
1040
CREATE TABLE t2 (c1 INT NOT NULL);
1041
CREATE TABLE t3 (c1 INT NOT NULL);
1042
CREATE TABLE t4 (c1 INT NOT NULL);
1043
CREATE TABLE t5 (c1 INT NOT NULL);
1044
CREATE TABLE t6 (c1 INT NOT NULL);
1045
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1046
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1047
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1048
INSERT INTO t4 (c1) VALUES(10);
1049
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1050
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1051
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1052
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1053
DROP TABLE t1,t2,t3,t4,t5,t6;
1054
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1055
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1056
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1057
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1058
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1059
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1060
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1061
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1062
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1063
INSERT INTO t4 (c1) VALUES(10);
1064
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1065
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1066
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1067
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1068
DROP TABLE t1,t2,t3,t4,t5,t6;
1069
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1070
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1071
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1072
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1073
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1074
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1075
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1076
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1077
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1078
INSERT INTO t4 (c1) VALUES(10);
1079
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1080
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1081
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1082
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 = 5;
1083
DROP TABLE t1,t2,t3,t4,t5,t6;
1084
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1085
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1086
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1087
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1088
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1089
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1090
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1091
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1092
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1093
INSERT INTO t4 (c1) VALUES(10);
1094
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1095
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1096
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1097
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1098
DROP TABLE t1,t2,t3,t4,t5,t6;
1099
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1100
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1101
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1102
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1103
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1104
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1105
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1106
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1107
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1108
INSERT INTO t4 (c1) VALUES(10);
1109
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1110
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1111
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1112
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1113
DROP TABLE t1,t2,t3,t4,t5,t6;
1114
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1115
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1116
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1117
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1118
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1119
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1120
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1121
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1122
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1123
INSERT INTO t4 (c1) VALUES(10);
1124
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1125
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1126
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1127
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1128
DROP TABLE t1,t2,t3,t4,t5,t6;
1129
CREATE TABLE t1 (c1 INT NOT NULL);
1130
CREATE TABLE t2 (c1 INT NOT NULL);
1131
CREATE TABLE t3 (c1 INT NOT NULL);
1132
CREATE TABLE t4 (c1 INT NOT NULL);
1133
CREATE TABLE t5 (c1 INT NOT NULL);
1134
CREATE TABLE t6 (c1 INT NOT NULL);
1135
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1136
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1137
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1138
INSERT INTO t4 (c1) VALUES(10);
1139
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1140
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1141
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1142
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1143
DROP TABLE t1,t2,t3,t4,t5,t6;
1144
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1145
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1146
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1147
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1148
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1149
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1150
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1151
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1152
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1153
INSERT INTO t4 (c1) VALUES(10);
1154
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1155
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1156
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1157
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1158
DROP TABLE t1,t2,t3,t4,t5,t6;
1159
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1160
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1161
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1162
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1163
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1164
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1165
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1166
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1167
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1168
INSERT INTO t4 (c1) VALUES(10);
1169
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1170
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1171
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1172
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 = 5;
1173
DROP TABLE t1,t2,t3,t4,t5,t6;
1174
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1175
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1176
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1177
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1178
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1179
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1180
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1181
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1182
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1183
INSERT INTO t4 (c1) VALUES(10);
1184
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1185
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1186
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1187
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1188
DROP TABLE t1,t2,t3,t4,t5,t6;
1189
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1190
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1191
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1192
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1193
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1194
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1195
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1196
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1197
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1198
INSERT INTO t4 (c1) VALUES(10);
1199
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1200
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1201
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1202
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1203
DROP TABLE t1,t2,t3,t4,t5,t6;
1204
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1205
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1206
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1207
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1208
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1209
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1210
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1211
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1212
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1213
INSERT INTO t4 (c1) VALUES(10);
1214
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1215
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1216
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1217
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1218
DROP TABLE t1,t2,t3,t4,t5,t6;
1219
CREATE TABLE t1 (c1 INT NOT NULL);
1220
CREATE TABLE t2 (c1 INT NOT NULL);
1221
CREATE TABLE t3 (c1 INT NOT NULL);
1222
CREATE TABLE t4 (c1 INT NOT NULL);
1223
CREATE TABLE t5 (c1 INT NOT NULL);
1224
CREATE TABLE t6 (c1 INT NOT NULL);
1225
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1226
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1227
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1228
INSERT INTO t4 (c1) VALUES(10);
1229
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1230
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1231
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1232
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1233
DROP TABLE t1,t2,t3,t4,t5,t6;
1234
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1235
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1236
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1237
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1238
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1239
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1240
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1241
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1242
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1243
INSERT INTO t4 (c1) VALUES(10);
1244
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1245
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1246
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1247
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1248
DROP TABLE t1,t2,t3,t4,t5,t6;
1249
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1250
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1251
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1252
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1253
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1254
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1255
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1256
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1257
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1258
INSERT INTO t4 (c1) VALUES(10);
1259
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1260
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1261
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1262
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 = 5;
1263
DROP TABLE t1,t2,t3,t4,t5,t6;
1264
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1265
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1266
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1267
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1268
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1269
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1270
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1271
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1272
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1273
INSERT INTO t4 (c1) VALUES(10);
1274
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1275
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1276
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1277
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1278
DROP TABLE t1,t2,t3,t4,t5,t6;
1279
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1280
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1281
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1282
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1283
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1284
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1285
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1286
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1287
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1288
INSERT INTO t4 (c1) VALUES(10);
1289
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1290
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1291
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1292
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1293
DROP TABLE t1,t2,t3,t4,t5,t6;
1294
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1295
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1296
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1297
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1298
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1299
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1300
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1301
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1302
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1303
INSERT INTO t4 (c1) VALUES(10);
1304
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1305
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1306
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1307
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1308
DROP TABLE t1,t2,t3,t4,t5,t6;
1309
CREATE TABLE t1 (c1 INT NOT NULL);
1310
CREATE TABLE t2 (c1 INT NOT NULL);
1311
CREATE TABLE t3 (c1 INT NOT NULL);
1312
CREATE TABLE t4 (c1 INT NOT NULL);
1313
CREATE TABLE t5 (c1 INT NOT NULL);
1314
CREATE TABLE t6 (c1 INT NOT NULL);
1315
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1316
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1317
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1318
INSERT INTO t4 (c1) VALUES(10);
1319
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1320
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1321
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1322
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1323
DROP TABLE t1,t2,t3,t4,t5,t6;
1324
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1325
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1326
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1327
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1328
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1329
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1330
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1331
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1332
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1333
INSERT INTO t4 (c1) VALUES(10);
1334
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1335
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1336
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1337
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1338
DROP TABLE t1,t2,t3,t4,t5,t6;
1339
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1340
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1341
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1342
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1343
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1344
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1345
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1346
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1347
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1348
INSERT INTO t4 (c1) VALUES(10);
1349
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1350
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1351
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1352
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 = 5;
1353
DROP TABLE t1,t2,t3,t4,t5,t6;
1354
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1355
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1356
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1357
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1358
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1359
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1360
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1361
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1362
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1363
INSERT INTO t4 (c1) VALUES(10);
1364
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1365
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1366
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1367
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1368
DROP TABLE t1,t2,t3,t4,t5,t6;
1369
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1370
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1371
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1372
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1373
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1374
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1375
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1376
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1377
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1378
INSERT INTO t4 (c1) VALUES(10);
1379
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1380
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1381
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1382
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1383
DROP TABLE t1,t2,t3,t4,t5,t6;
1384
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1385
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1386
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1387
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1388
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1389
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1390
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1391
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1392
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1393
INSERT INTO t4 (c1) VALUES(10);
1394
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1395
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1396
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1397
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1398
DROP TABLE t1,t2,t3,t4,t5,t6;
1399
CREATE TABLE t1 (c1 INT NOT NULL);
1400
CREATE TABLE t2 (c1 INT NOT NULL);
1401
CREATE TABLE t3 (c1 INT NOT NULL);
1402
CREATE TABLE t4 (c1 INT NOT NULL);
1403
CREATE TABLE t5 (c1 INT NOT NULL);
1404
CREATE TABLE t6 (c1 INT NOT NULL);
1405
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1406
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1407
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1408
INSERT INTO t4 (c1) VALUES(10);
1409
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1410
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1411
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1412
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1413
DROP TABLE t1,t2,t3,t4,t5,t6;
1414
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1415
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1416
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1417
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1418
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1419
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1420
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1421
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1422
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1423
INSERT INTO t4 (c1) VALUES(10);
1424
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1425
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1426
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1427
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1428
DROP TABLE t1,t2,t3,t4,t5,t6;
1429
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1430
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1431
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1432
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1433
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1434
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1435
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1436
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1437
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1438
INSERT INTO t4 (c1) VALUES(10);
1439
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1440
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1441
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1442
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 >= 5;
1443
DROP TABLE t1,t2,t3,t4,t5,t6;
1444
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1445
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1446
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1447
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1448
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1449
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1450
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1451
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1452
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1453
INSERT INTO t4 (c1) VALUES(10);
1454
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1455
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1456
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1457
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1458
DROP TABLE t1,t2,t3,t4,t5,t6;
1459
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1460
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1461
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1462
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1463
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1464
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1465
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1466
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1467
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1468
INSERT INTO t4 (c1) VALUES(10);
1469
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1470
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1471
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1472
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1473
DROP TABLE t1,t2,t3,t4,t5,t6;
1474
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1475
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1476
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1477
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1478
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1479
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1480
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1481
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1482
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1483
INSERT INTO t4 (c1) VALUES(10);
1484
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1485
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1486
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1487
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1488
DROP TABLE t1,t2,t3,t4,t5,t6;
1489
CREATE TABLE t1 (c1 INT NOT NULL);
1490
CREATE TABLE t2 (c1 INT NOT NULL);
1491
CREATE TABLE t3 (c1 INT NOT NULL);
1492
CREATE TABLE t4 (c1 INT NOT NULL);
1493
CREATE TABLE t5 (c1 INT NOT NULL);
1494
CREATE TABLE t6 (c1 INT NOT NULL);
1495
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1496
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1497
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1498
INSERT INTO t4 (c1) VALUES(10);
1499
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1500
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1501
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1502
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1503
DROP TABLE t1,t2,t3,t4,t5,t6;
1504
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1505
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1506
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1507
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1508
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1509
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1510
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1511
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1512
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1513
INSERT INTO t4 (c1) VALUES(10);
1514
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1515
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1516
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1517
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1518
DROP TABLE t1,t2,t3,t4,t5,t6;
1519
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1520
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1521
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1522
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1523
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1524
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1525
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1526
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1527
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1528
INSERT INTO t4 (c1) VALUES(10);
1529
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1530
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1531
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1532
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 >= 5;
1533
DROP TABLE t1,t2,t3,t4,t5,t6;
1534
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1535
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1536
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1537
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1538
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1539
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1540
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1541
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1542
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1543
INSERT INTO t4 (c1) VALUES(10);
1544
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1545
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1546
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1547
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1548
DROP TABLE t1,t2,t3,t4,t5,t6;
1549
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1550
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1551
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1552
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1553
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1554
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1555
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1556
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1557
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1558
INSERT INTO t4 (c1) VALUES(10);
1559
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1560
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1561
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1562
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1563
DROP TABLE t1,t2,t3,t4,t5,t6;
1564
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1565
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1566
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1567
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1568
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1569
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1570
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1571
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1572
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1573
INSERT INTO t4 (c1) VALUES(10);
1574
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1575
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1576
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1577
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1578
DROP TABLE t1,t2,t3,t4,t5,t6;
1579
CREATE TABLE t1 (c1 INT NOT NULL);
1580
CREATE TABLE t2 (c1 INT NOT NULL);
1581
CREATE TABLE t3 (c1 INT NOT NULL);
1582
CREATE TABLE t4 (c1 INT NOT NULL);
1583
CREATE TABLE t5 (c1 INT NOT NULL);
1584
CREATE TABLE t6 (c1 INT NOT NULL);
1585
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1586
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1587
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1588
INSERT INTO t4 (c1) VALUES(10);
1589
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1590
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1591
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1592
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1593
DROP TABLE t1,t2,t3,t4,t5,t6;
1594
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1595
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1596
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1597
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1598
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1599
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1600
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1601
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1602
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1603
INSERT INTO t4 (c1) VALUES(10);
1604
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1605
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1606
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1607
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1608
DROP TABLE t1,t2,t3,t4,t5,t6;
1609
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1610
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1611
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1612
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1613
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1614
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1615
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1616
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1617
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1618
INSERT INTO t4 (c1) VALUES(10);
1619
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1620
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1621
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1622
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 >= 5;
1623
DROP TABLE t1,t2,t3,t4,t5,t6;
1624
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1625
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1626
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1627
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1628
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1629
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1630
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1631
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1632
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1633
INSERT INTO t4 (c1) VALUES(10);
1634
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1635
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1636
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1637
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1638
DROP TABLE t1,t2,t3,t4,t5,t6;
1639
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1640
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1641
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1642
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1643
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1644
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1645
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1646
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1647
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1648
INSERT INTO t4 (c1) VALUES(10);
1649
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1650
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1651
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1652
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1653
DROP TABLE t1,t2,t3,t4,t5,t6;
1654
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1655
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1656
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1657
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1658
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1659
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1660
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1661
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1662
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1663
INSERT INTO t4 (c1) VALUES(10);
1664
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1665
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1666
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1667
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1668
DROP TABLE t1,t2,t3,t4,t5,t6;
1669
CREATE TABLE t1 (c1 INT NOT NULL);
1670
CREATE TABLE t2 (c1 INT NOT NULL);
1671
CREATE TABLE t3 (c1 INT NOT NULL);
1672
CREATE TABLE t4 (c1 INT NOT NULL);
1673
CREATE TABLE t5 (c1 INT NOT NULL);
1674
CREATE TABLE t6 (c1 INT NOT NULL);
1675
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1676
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1677
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1678
INSERT INTO t4 (c1) VALUES(10);
1679
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1680
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1681
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1682
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1683
DROP TABLE t1,t2,t3,t4,t5,t6;
1684
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1685
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1686
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1687
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1688
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1689
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1690
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1691
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1692
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1693
INSERT INTO t4 (c1) VALUES(10);
1694
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1695
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1696
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1697
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1698
DROP TABLE t1,t2,t3,t4,t5,t6;
1699
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1700
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1701
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1702
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1703
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1704
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1705
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1706
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1707
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1708
INSERT INTO t4 (c1) VALUES(10);
1709
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1710
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
1711
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
1712
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 >= 5;
1713
DROP TABLE t1,t2,t3,t4,t5,t6;
1714
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1715
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1716
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1717
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1718
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1719
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1720
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1721
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1722
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1723
INSERT INTO t4 (c1) VALUES(10);
1724
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1725
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1726
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1727
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1728
DROP TABLE t1,t2,t3,t4,t5,t6;
1729
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1730
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1731
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1732
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1733
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1734
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1735
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1736
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1737
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1738
INSERT INTO t4 (c1) VALUES(10);
1739
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1740
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1741
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1742
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1743
DROP TABLE t1,t2,t3,t4,t5,t6;
1744
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1745
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1746
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1747
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1748
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1749
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1750
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1751
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1752
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1753
INSERT INTO t4 (c1) VALUES(10);
1754
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1755
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1756
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1757
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1758
DROP TABLE t1,t2,t3,t4,t5,t6;
1759
CREATE TABLE t1 (c1 INT NOT NULL);
1760
CREATE TABLE t2 (c1 INT NOT NULL);
1761
CREATE TABLE t3 (c1 INT NOT NULL);
1762
CREATE TABLE t4 (c1 INT NOT NULL);
1763
CREATE TABLE t5 (c1 INT NOT NULL);
1764
CREATE TABLE t6 (c1 INT NOT NULL);
1765
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1766
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1767
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1768
INSERT INTO t4 (c1) VALUES(10);
1769
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1770
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1771
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1772
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1773
DROP TABLE t1,t2,t3,t4,t5,t6;
1774
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1775
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1776
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1777
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1778
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1779
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1780
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1781
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1782
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1783
INSERT INTO t4 (c1) VALUES(10);
1784
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1785
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1786
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1787
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1788
DROP TABLE t1,t2,t3,t4,t5,t6;
1789
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1790
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1791
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1792
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1793
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1794
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1795
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1796
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1797
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1798
INSERT INTO t4 (c1) VALUES(10);
1799
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1800
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
1801
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
1802
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 >= 5;
1803
DROP TABLE t1,t2,t3,t4,t5,t6;
1804
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1805
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1806
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1807
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1808
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1809
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1810
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1811
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1812
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1813
INSERT INTO t4 (c1) VALUES(10);
1814
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1815
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1816
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1817
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1818
DROP TABLE t1,t2,t3,t4,t5,t6;
1819
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1820
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1821
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1822
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1823
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1824
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1825
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1826
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1827
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1828
INSERT INTO t4 (c1) VALUES(10);
1829
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1830
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1831
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1832
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1833
DROP TABLE t1,t2,t3,t4,t5,t6;
1834
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1835
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1836
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1837
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1838
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1839
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1840
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1841
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1842
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1843
INSERT INTO t4 (c1) VALUES(10);
1844
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1845
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1846
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1847
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1848
DROP TABLE t1,t2,t3,t4,t5,t6;
1849
CREATE TABLE t1 (c1 INT NOT NULL);
1850
CREATE TABLE t2 (c1 INT NOT NULL);
1851
CREATE TABLE t3 (c1 INT NOT NULL);
1852
CREATE TABLE t4 (c1 INT NOT NULL);
1853
CREATE TABLE t5 (c1 INT NOT NULL);
1854
CREATE TABLE t6 (c1 INT NOT NULL);
1855
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1856
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1857
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1858
INSERT INTO t4 (c1) VALUES(10);
1859
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1860
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1861
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1862
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1863
DROP TABLE t1,t2,t3,t4,t5,t6;
1864
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1865
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1866
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1867
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1868
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1869
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1870
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1871
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1872
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1873
INSERT INTO t4 (c1) VALUES(10);
1874
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1875
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1876
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1877
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1878
DROP TABLE t1,t2,t3,t4,t5,t6;
1879
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1880
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1881
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1882
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1883
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1884
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1885
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1886
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1887
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1888
INSERT INTO t4 (c1) VALUES(10);
1889
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1890
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
1891
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
1892
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 != 5;
1893
DROP TABLE t1,t2,t3,t4,t5,t6;
1894
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1895
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1896
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1897
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1898
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1899
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1900
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1901
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1902
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1903
INSERT INTO t4 (c1) VALUES(10);
1904
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1905
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1906
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1907
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1908
DROP TABLE t1,t2,t3,t4,t5,t6;
1909
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
1910
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
1911
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
1912
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
1913
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
1914
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
1915
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1916
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1917
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1918
INSERT INTO t4 (c1) VALUES(10);
1919
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1920
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1921
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1922
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1923
DROP TABLE t1,t2,t3,t4,t5,t6;
1924
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
1925
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
1926
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
1927
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
1928
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
1929
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
1930
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1931
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1932
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1933
INSERT INTO t4 (c1) VALUES(10);
1934
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1935
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1936
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1937
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1938
DROP TABLE t1,t2,t3,t4,t5,t6;
1939
CREATE TABLE t1 (c1 INT NOT NULL);
1940
CREATE TABLE t2 (c1 INT NOT NULL);
1941
CREATE TABLE t3 (c1 INT NOT NULL);
1942
CREATE TABLE t4 (c1 INT NOT NULL);
1943
CREATE TABLE t5 (c1 INT NOT NULL);
1944
CREATE TABLE t6 (c1 INT NOT NULL);
1945
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1946
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1947
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1948
INSERT INTO t4 (c1) VALUES(10);
1949
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1950
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1951
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1952
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1953
DROP TABLE t1,t2,t3,t4,t5,t6;
1954
CREATE TABLE t1 (c1 INTEGER NOT NULL);
1955
CREATE TABLE t2 (c1 INTEGER NOT NULL);
1956
CREATE TABLE t3 (c1 INTEGER NOT NULL);
1957
CREATE TABLE t4 (c1 INTEGER NOT NULL);
1958
CREATE TABLE t5 (c1 INTEGER NOT NULL);
1959
CREATE TABLE t6 (c1 INTEGER NOT NULL);
1960
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1961
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1962
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1963
INSERT INTO t4 (c1) VALUES(10);
1964
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1965
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1966
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1967
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1968
DROP TABLE t1,t2,t3,t4,t5,t6;
1969
CREATE TABLE t1 (c1 BIGINT NOT NULL);
1970
CREATE TABLE t2 (c1 BIGINT NOT NULL);
1971
CREATE TABLE t3 (c1 BIGINT NOT NULL);
1972
CREATE TABLE t4 (c1 BIGINT NOT NULL);
1973
CREATE TABLE t5 (c1 BIGINT NOT NULL);
1974
CREATE TABLE t6 (c1 BIGINT NOT NULL);
1975
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1976
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1977
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1978
INSERT INTO t4 (c1) VALUES(10);
1979
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1980
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
1981
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
1982
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 != 5;
1983
DROP TABLE t1,t2,t3,t4,t5,t6;
1984
CREATE TABLE t1 (c1 TINYINT NOT NULL);
1985
CREATE TABLE t2 (c1 TINYINT NOT NULL);
1986
CREATE TABLE t3 (c1 TINYINT NOT NULL);
1987
CREATE TABLE t4 (c1 TINYINT NOT NULL);
1988
CREATE TABLE t5 (c1 TINYINT NOT NULL);
1989
CREATE TABLE t6 (c1 TINYINT NOT NULL);
1990
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1991
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1992
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
1993
INSERT INTO t4 (c1) VALUES(10);
1994
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
1995
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
1996
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
1997
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
1998
DROP TABLE t1,t2,t3,t4,t5,t6;
1999
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2000
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2001
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2002
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2003
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2004
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2005
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2006
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2007
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2008
INSERT INTO t4 (c1) VALUES(10);
2009
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2010
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2011
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2012
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2013
DROP TABLE t1,t2,t3,t4,t5,t6;
2014
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2015
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2016
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2017
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2018
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2019
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2020
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2021
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2022
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2023
INSERT INTO t4 (c1) VALUES(10);
2024
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2025
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2026
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2027
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2028
DROP TABLE t1,t2,t3,t4,t5,t6;
2029
CREATE TABLE t1 (c1 INT NOT NULL);
2030
CREATE TABLE t2 (c1 INT NOT NULL);
2031
CREATE TABLE t3 (c1 INT NOT NULL);
2032
CREATE TABLE t4 (c1 INT NOT NULL);
2033
CREATE TABLE t5 (c1 INT NOT NULL);
2034
CREATE TABLE t6 (c1 INT NOT NULL);
2035
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2036
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2037
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2038
INSERT INTO t4 (c1) VALUES(10);
2039
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2040
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2041
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2042
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2043
DROP TABLE t1,t2,t3,t4,t5,t6;
2044
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2045
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2046
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2047
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2048
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2049
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2050
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2051
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2052
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2053
INSERT INTO t4 (c1) VALUES(10);
2054
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2055
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2056
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2057
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2058
DROP TABLE t1,t2,t3,t4,t5,t6;
2059
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2060
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2061
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2062
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2063
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2064
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2065
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2066
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2067
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2068
INSERT INTO t4 (c1) VALUES(10);
2069
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2070
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2071
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2072
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 != 5;
2073
DROP TABLE t1,t2,t3,t4,t5,t6;
2074
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2075
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2076
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2077
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2078
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2079
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2080
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2081
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2082
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2083
INSERT INTO t4 (c1) VALUES(10);
2084
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2085
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2086
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2087
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2088
DROP TABLE t1,t2,t3,t4,t5,t6;
2089
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2090
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2091
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2092
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2093
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2094
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2095
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2096
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2097
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2098
INSERT INTO t4 (c1) VALUES(10);
2099
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2100
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2101
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2102
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2103
DROP TABLE t1,t2,t3,t4,t5,t6;
2104
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2105
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2106
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2107
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2108
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2109
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2110
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2111
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2112
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2113
INSERT INTO t4 (c1) VALUES(10);
2114
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2115
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2116
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2117
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2118
DROP TABLE t1,t2,t3,t4,t5,t6;
2119
CREATE TABLE t1 (c1 INT NOT NULL);
2120
CREATE TABLE t2 (c1 INT NOT NULL);
2121
CREATE TABLE t3 (c1 INT NOT NULL);
2122
CREATE TABLE t4 (c1 INT NOT NULL);
2123
CREATE TABLE t5 (c1 INT NOT NULL);
2124
CREATE TABLE t6 (c1 INT NOT NULL);
2125
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2126
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2127
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2128
INSERT INTO t4 (c1) VALUES(10);
2129
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2130
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2131
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2132
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2133
DROP TABLE t1,t2,t3,t4,t5,t6;
2134
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2135
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2136
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2137
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2138
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2139
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2140
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2141
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2142
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2143
INSERT INTO t4 (c1) VALUES(10);
2144
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2145
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2146
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2147
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2148
DROP TABLE t1,t2,t3,t4,t5,t6;
2149
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2150
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2151
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2152
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2153
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2154
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2155
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2156
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2157
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2158
INSERT INTO t4 (c1) VALUES(10);
2159
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2160
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2161
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2162
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 != 5;
2163
DROP TABLE t1,t2,t3,t4,t5,t6;
2164
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2165
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2166
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2167
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2168
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2169
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2170
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2171
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2172
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2173
INSERT INTO t4 (c1) VALUES(10);
2174
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2175
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2176
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2177
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2178
DROP TABLE t1,t2,t3,t4,t5,t6;
2179
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2180
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2181
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2182
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2183
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2184
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2185
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2186
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2187
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2188
INSERT INTO t4 (c1) VALUES(10);
2189
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2190
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2191
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2192
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2193
DROP TABLE t1,t2,t3,t4,t5,t6;
2194
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2195
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2196
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2197
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2198
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2199
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2200
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2201
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2202
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2203
INSERT INTO t4 (c1) VALUES(10);
2204
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2205
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2206
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2207
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2208
DROP TABLE t1,t2,t3,t4,t5,t6;
2209
CREATE TABLE t1 (c1 INT NOT NULL);
2210
CREATE TABLE t2 (c1 INT NOT NULL);
2211
CREATE TABLE t3 (c1 INT NOT NULL);
2212
CREATE TABLE t4 (c1 INT NOT NULL);
2213
CREATE TABLE t5 (c1 INT NOT NULL);
2214
CREATE TABLE t6 (c1 INT NOT NULL);
2215
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2216
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2217
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2218
INSERT INTO t4 (c1) VALUES(10);
2219
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2220
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2221
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2222
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2223
DROP TABLE t1,t2,t3,t4,t5,t6;
2224
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2225
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2226
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2227
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2228
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2229
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2230
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2231
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2232
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2233
INSERT INTO t4 (c1) VALUES(10);
2234
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2235
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2236
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2237
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2238
DROP TABLE t1,t2,t3,t4,t5,t6;
2239
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2240
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2241
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2242
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2243
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2244
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2245
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2246
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2247
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2248
INSERT INTO t4 (c1) VALUES(10);
2249
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2250
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2251
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2252
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 != 5;
2253
DROP TABLE t1,t2,t3,t4,t5,t6;
2254
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2255
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2256
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2257
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2258
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2259
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2260
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2261
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2262
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2263
INSERT INTO t4 (c1) VALUES(10);
2264
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2265
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2266
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2267
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2268
DROP TABLE t1,t2,t3,t4,t5,t6;
2269
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2270
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2271
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2272
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2273
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2274
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2275
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2276
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2277
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2278
INSERT INTO t4 (c1) VALUES(10);
2279
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2280
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2281
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2282
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2283
DROP TABLE t1,t2,t3,t4,t5,t6;
2284
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2285
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2286
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2287
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2288
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2289
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2290
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2291
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2292
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2293
INSERT INTO t4 (c1) VALUES(10);
2294
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2295
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2296
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2297
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2298
DROP TABLE t1,t2,t3,t4,t5,t6;
2299
CREATE TABLE t1 (c1 INT NOT NULL);
2300
CREATE TABLE t2 (c1 INT NOT NULL);
2301
CREATE TABLE t3 (c1 INT NOT NULL);
2302
CREATE TABLE t4 (c1 INT NOT NULL);
2303
CREATE TABLE t5 (c1 INT NOT NULL);
2304
CREATE TABLE t6 (c1 INT NOT NULL);
2305
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2306
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2307
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2308
INSERT INTO t4 (c1) VALUES(10);
2309
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2310
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2311
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2312
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2313
DROP TABLE t1,t2,t3,t4,t5,t6;
2314
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2315
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2316
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2317
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2318
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2319
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2320
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2321
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2322
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2323
INSERT INTO t4 (c1) VALUES(10);
2324
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2325
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2326
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2327
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2328
DROP TABLE t1,t2,t3,t4,t5,t6;
2329
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2330
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2331
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2332
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2333
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2334
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2335
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2336
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2337
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2338
INSERT INTO t4 (c1) VALUES(10);
2339
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2340
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2341
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2342
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <> 5;
2343
DROP TABLE t1,t2,t3,t4,t5,t6;
2344
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2345
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2346
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2347
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2348
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2349
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2350
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2351
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2352
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2353
INSERT INTO t4 (c1) VALUES(10);
2354
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2355
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2356
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2357
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2358
DROP TABLE t1,t2,t3,t4,t5,t6;
2359
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2360
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2361
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2362
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2363
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2364
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2365
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2366
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2367
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2368
INSERT INTO t4 (c1) VALUES(10);
2369
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2370
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2371
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2372
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2373
DROP TABLE t1,t2,t3,t4,t5,t6;
2374
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2375
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2376
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2377
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2378
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2379
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2380
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2381
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2382
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2383
INSERT INTO t4 (c1) VALUES(10);
2384
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2385
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2386
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2387
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2388
DROP TABLE t1,t2,t3,t4,t5,t6;
2389
CREATE TABLE t1 (c1 INT NOT NULL);
2390
CREATE TABLE t2 (c1 INT NOT NULL);
2391
CREATE TABLE t3 (c1 INT NOT NULL);
2392
CREATE TABLE t4 (c1 INT NOT NULL);
2393
CREATE TABLE t5 (c1 INT NOT NULL);
2394
CREATE TABLE t6 (c1 INT NOT NULL);
2395
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2396
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2397
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2398
INSERT INTO t4 (c1) VALUES(10);
2399
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2400
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2401
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2402
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2403
DROP TABLE t1,t2,t3,t4,t5,t6;
2404
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2405
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2406
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2407
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2408
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2409
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2410
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2411
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2412
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2413
INSERT INTO t4 (c1) VALUES(10);
2414
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2415
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2416
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2417
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2418
DROP TABLE t1,t2,t3,t4,t5,t6;
2419
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2420
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2421
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2422
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2423
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2424
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2425
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2426
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2427
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2428
INSERT INTO t4 (c1) VALUES(10);
2429
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2430
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2431
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2432
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <> 5;
2433
DROP TABLE t1,t2,t3,t4,t5,t6;
2434
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2435
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2436
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2437
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2438
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2439
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2440
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2441
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2442
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2443
INSERT INTO t4 (c1) VALUES(10);
2444
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2445
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2446
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2447
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2448
DROP TABLE t1,t2,t3,t4,t5,t6;
2449
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2450
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2451
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2452
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2453
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2454
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2455
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2456
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2457
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2458
INSERT INTO t4 (c1) VALUES(10);
2459
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2460
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2461
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2462
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2463
DROP TABLE t1,t2,t3,t4,t5,t6;
2464
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2465
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2466
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2467
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2468
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2469
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2470
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2471
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2472
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2473
INSERT INTO t4 (c1) VALUES(10);
2474
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2475
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2476
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2477
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2478
DROP TABLE t1,t2,t3,t4,t5,t6;
2479
CREATE TABLE t1 (c1 INT NOT NULL);
2480
CREATE TABLE t2 (c1 INT NOT NULL);
2481
CREATE TABLE t3 (c1 INT NOT NULL);
2482
CREATE TABLE t4 (c1 INT NOT NULL);
2483
CREATE TABLE t5 (c1 INT NOT NULL);
2484
CREATE TABLE t6 (c1 INT NOT NULL);
2485
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2486
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2487
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2488
INSERT INTO t4 (c1) VALUES(10);
2489
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2490
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2491
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2492
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2493
DROP TABLE t1,t2,t3,t4,t5,t6;
2494
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2495
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2496
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2497
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2498
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2499
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2500
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2501
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2502
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2503
INSERT INTO t4 (c1) VALUES(10);
2504
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2505
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2506
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2507
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2508
DROP TABLE t1,t2,t3,t4,t5,t6;
2509
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2510
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2511
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2512
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2513
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2514
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2515
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2516
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2517
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2518
INSERT INTO t4 (c1) VALUES(10);
2519
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2520
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2521
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2522
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <> 5;
2523
DROP TABLE t1,t2,t3,t4,t5,t6;
2524
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2525
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2526
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2527
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2528
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2529
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2530
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2531
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2532
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2533
INSERT INTO t4 (c1) VALUES(10);
2534
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2535
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2536
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2537
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2538
DROP TABLE t1,t2,t3,t4,t5,t6;
2539
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2540
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2541
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2542
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2543
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2544
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2545
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2546
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2547
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2548
INSERT INTO t4 (c1) VALUES(10);
2549
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2550
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2551
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2552
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2553
DROP TABLE t1,t2,t3,t4,t5,t6;
2554
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2555
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2556
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2557
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2558
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2559
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2560
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2561
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2562
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2563
INSERT INTO t4 (c1) VALUES(10);
2564
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2565
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2566
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2567
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2568
DROP TABLE t1,t2,t3,t4,t5,t6;
2569
CREATE TABLE t1 (c1 INT NOT NULL);
2570
CREATE TABLE t2 (c1 INT NOT NULL);
2571
CREATE TABLE t3 (c1 INT NOT NULL);
2572
CREATE TABLE t4 (c1 INT NOT NULL);
2573
CREATE TABLE t5 (c1 INT NOT NULL);
2574
CREATE TABLE t6 (c1 INT NOT NULL);
2575
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2576
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2577
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2578
INSERT INTO t4 (c1) VALUES(10);
2579
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2580
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2581
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2582
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2583
DROP TABLE t1,t2,t3,t4,t5,t6;
2584
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2585
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2586
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2587
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2588
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2589
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2590
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2591
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2592
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2593
INSERT INTO t4 (c1) VALUES(10);
2594
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2595
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2596
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2597
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2598
DROP TABLE t1,t2,t3,t4,t5,t6;
2599
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2600
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2601
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2602
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2603
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2604
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2605
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2606
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2607
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2608
INSERT INTO t4 (c1) VALUES(10);
2609
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2610
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2611
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2612
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <> 5;
2613
DROP TABLE t1,t2,t3,t4,t5,t6;
2614
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2615
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2616
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2617
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2618
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2619
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2620
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2621
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2622
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2623
INSERT INTO t4 (c1) VALUES(10);
2624
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2625
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2626
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2627
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2628
DROP TABLE t1,t2,t3,t4,t5,t6;
2629
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2630
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2631
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2632
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2633
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2634
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2635
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2636
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2637
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2638
INSERT INTO t4 (c1) VALUES(10);
2639
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2640
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2641
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2642
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2643
DROP TABLE t1,t2,t3,t4,t5,t6;
2644
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2645
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2646
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2647
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2648
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2649
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2650
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2651
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2652
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2653
INSERT INTO t4 (c1) VALUES(10);
2654
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2655
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2656
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2657
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2658
DROP TABLE t1,t2,t3,t4,t5,t6;
2659
CREATE TABLE t1 (c1 INT NOT NULL);
2660
CREATE TABLE t2 (c1 INT NOT NULL);
2661
CREATE TABLE t3 (c1 INT NOT NULL);
2662
CREATE TABLE t4 (c1 INT NOT NULL);
2663
CREATE TABLE t5 (c1 INT NOT NULL);
2664
CREATE TABLE t6 (c1 INT NOT NULL);
2665
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2666
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2667
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2668
INSERT INTO t4 (c1) VALUES(10);
2669
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2670
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2671
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2672
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2673
DROP TABLE t1,t2,t3,t4,t5,t6;
2674
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2675
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2676
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2677
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2678
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2679
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2680
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2681
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2682
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2683
INSERT INTO t4 (c1) VALUES(10);
2684
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2685
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2686
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2687
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2688
DROP TABLE t1,t2,t3,t4,t5,t6;
2689
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2690
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2691
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2692
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2693
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2694
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2695
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2696
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2697
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2698
INSERT INTO t4 (c1) VALUES(10);
2699
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2700
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
2701
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
2702
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <> 5;
2703
DROP TABLE t1,t2,t3,t4,t5,t6;
2704
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2705
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2706
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2707
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2708
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2709
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2710
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2711
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2712
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2713
INSERT INTO t4 (c1) VALUES(10);
2714
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2715
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2716
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2717
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2718
DROP TABLE t1,t2,t3,t4,t5,t6;
2719
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2720
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2721
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2722
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2723
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2724
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2725
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2726
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2727
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2728
INSERT INTO t4 (c1) VALUES(10);
2729
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2730
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2731
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2732
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2733
DROP TABLE t1,t2,t3,t4,t5,t6;
2734
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2735
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2736
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2737
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2738
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2739
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2740
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2741
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2742
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2743
INSERT INTO t4 (c1) VALUES(10);
2744
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2745
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2746
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2747
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2748
DROP TABLE t1,t2,t3,t4,t5,t6;
2749
CREATE TABLE t1 (c1 INT NOT NULL);
2750
CREATE TABLE t2 (c1 INT NOT NULL);
2751
CREATE TABLE t3 (c1 INT NOT NULL);
2752
CREATE TABLE t4 (c1 INT NOT NULL);
2753
CREATE TABLE t5 (c1 INT NOT NULL);
2754
CREATE TABLE t6 (c1 INT NOT NULL);
2755
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2756
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2757
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2758
INSERT INTO t4 (c1) VALUES(10);
2759
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2760
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2761
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2762
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2763
DROP TABLE t1,t2,t3,t4,t5,t6;
2764
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2765
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2766
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2767
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2768
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2769
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2770
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2771
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2772
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2773
INSERT INTO t4 (c1) VALUES(10);
2774
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2775
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2776
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2777
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2778
DROP TABLE t1,t2,t3,t4,t5,t6;
2779
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2780
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2781
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2782
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2783
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2784
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2785
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2786
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2787
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2788
INSERT INTO t4 (c1) VALUES(10);
2789
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2790
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 USING (c1);
2791
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1;
2792
SELECT t1.c1,t2.c1 FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1 WHERE t1.c1 <=> 5;
2793
DROP TABLE t1,t2,t3,t4,t5,t6;
2794
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2795
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2796
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2797
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2798
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2799
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2800
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2801
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2802
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2803
INSERT INTO t4 (c1) VALUES(10);
2804
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2805
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2806
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2807
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2808
DROP TABLE t1,t2,t3,t4,t5,t6;
2809
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2810
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2811
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2812
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2813
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2814
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2815
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2816
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2817
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2818
INSERT INTO t4 (c1) VALUES(10);
2819
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2820
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2821
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2822
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2823
DROP TABLE t1,t2,t3,t4,t5,t6;
2824
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2825
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2826
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2827
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2828
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2829
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2830
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2831
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2832
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2833
INSERT INTO t4 (c1) VALUES(10);
2834
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2835
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2836
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2837
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2838
DROP TABLE t1,t2,t3,t4,t5,t6;
2839
CREATE TABLE t1 (c1 INT NOT NULL);
2840
CREATE TABLE t2 (c1 INT NOT NULL);
2841
CREATE TABLE t3 (c1 INT NOT NULL);
2842
CREATE TABLE t4 (c1 INT NOT NULL);
2843
CREATE TABLE t5 (c1 INT NOT NULL);
2844
CREATE TABLE t6 (c1 INT NOT NULL);
2845
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2846
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2847
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2848
INSERT INTO t4 (c1) VALUES(10);
2849
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2850
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2851
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2852
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2853
DROP TABLE t1,t2,t3,t4,t5,t6;
2854
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2855
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2856
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2857
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2858
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2859
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2860
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2861
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2862
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2863
INSERT INTO t4 (c1) VALUES(10);
2864
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2865
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2866
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2867
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2868
DROP TABLE t1,t2,t3,t4,t5,t6;
2869
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2870
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2871
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2872
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2873
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2874
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2875
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2876
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2877
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2878
INSERT INTO t4 (c1) VALUES(10);
2879
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2880
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 USING (c1);
2881
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1;
2882
SELECT t1.c1,t3.c1 FROM t1 LEFT JOIN t3 ON t1.c1 = t3.c1 WHERE t1.c1 <=> 5;
2883
DROP TABLE t1,t2,t3,t4,t5,t6;
2884
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2885
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2886
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2887
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2888
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2889
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2890
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2891
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2892
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2893
INSERT INTO t4 (c1) VALUES(10);
2894
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2895
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2896
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2897
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2898
DROP TABLE t1,t2,t3,t4,t5,t6;
2899
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2900
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2901
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2902
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2903
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2904
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2905
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2906
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2907
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2908
INSERT INTO t4 (c1) VALUES(10);
2909
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2910
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2911
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2912
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2913
DROP TABLE t1,t2,t3,t4,t5,t6;
2914
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
2915
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
2916
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
2917
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
2918
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
2919
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
2920
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2921
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2922
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2923
INSERT INTO t4 (c1) VALUES(10);
2924
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2925
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2926
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2927
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2928
DROP TABLE t1,t2,t3,t4,t5,t6;
2929
CREATE TABLE t1 (c1 INT NOT NULL);
2930
CREATE TABLE t2 (c1 INT NOT NULL);
2931
CREATE TABLE t3 (c1 INT NOT NULL);
2932
CREATE TABLE t4 (c1 INT NOT NULL);
2933
CREATE TABLE t5 (c1 INT NOT NULL);
2934
CREATE TABLE t6 (c1 INT NOT NULL);
2935
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2936
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2937
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2938
INSERT INTO t4 (c1) VALUES(10);
2939
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2940
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2941
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2942
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2943
DROP TABLE t1,t2,t3,t4,t5,t6;
2944
CREATE TABLE t1 (c1 INTEGER NOT NULL);
2945
CREATE TABLE t2 (c1 INTEGER NOT NULL);
2946
CREATE TABLE t3 (c1 INTEGER NOT NULL);
2947
CREATE TABLE t4 (c1 INTEGER NOT NULL);
2948
CREATE TABLE t5 (c1 INTEGER NOT NULL);
2949
CREATE TABLE t6 (c1 INTEGER NOT NULL);
2950
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2951
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2952
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2953
INSERT INTO t4 (c1) VALUES(10);
2954
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2955
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2956
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2957
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2958
DROP TABLE t1,t2,t3,t4,t5,t6;
2959
CREATE TABLE t1 (c1 BIGINT NOT NULL);
2960
CREATE TABLE t2 (c1 BIGINT NOT NULL);
2961
CREATE TABLE t3 (c1 BIGINT NOT NULL);
2962
CREATE TABLE t4 (c1 BIGINT NOT NULL);
2963
CREATE TABLE t5 (c1 BIGINT NOT NULL);
2964
CREATE TABLE t6 (c1 BIGINT NOT NULL);
2965
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2966
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2967
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2968
INSERT INTO t4 (c1) VALUES(10);
2969
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2970
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 USING (c1);
2971
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1;
2972
SELECT t1.c1,t4.c1 FROM t1 LEFT JOIN t4 ON t1.c1 = t4.c1 WHERE t1.c1 <=> 5;
2973
DROP TABLE t1,t2,t3,t4,t5,t6;
2974
CREATE TABLE t1 (c1 TINYINT NOT NULL);
2975
CREATE TABLE t2 (c1 TINYINT NOT NULL);
2976
CREATE TABLE t3 (c1 TINYINT NOT NULL);
2977
CREATE TABLE t4 (c1 TINYINT NOT NULL);
2978
CREATE TABLE t5 (c1 TINYINT NOT NULL);
2979
CREATE TABLE t6 (c1 TINYINT NOT NULL);
2980
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2981
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2982
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2983
INSERT INTO t4 (c1) VALUES(10);
2984
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
2985
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
2986
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
2987
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
2988
DROP TABLE t1,t2,t3,t4,t5,t6;
2989
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
2990
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
2991
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
2992
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
2993
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
2994
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
2995
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2996
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2997
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
2998
INSERT INTO t4 (c1) VALUES(10);
2999
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3000
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3001
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3002
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3003
DROP TABLE t1,t2,t3,t4,t5,t6;
3004
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3005
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3006
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3007
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3008
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3009
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3010
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3011
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3012
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3013
INSERT INTO t4 (c1) VALUES(10);
3014
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3015
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3016
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3017
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3018
DROP TABLE t1,t2,t3,t4,t5,t6;
3019
CREATE TABLE t1 (c1 INT NOT NULL);
3020
CREATE TABLE t2 (c1 INT NOT NULL);
3021
CREATE TABLE t3 (c1 INT NOT NULL);
3022
CREATE TABLE t4 (c1 INT NOT NULL);
3023
CREATE TABLE t5 (c1 INT NOT NULL);
3024
CREATE TABLE t6 (c1 INT NOT NULL);
3025
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3026
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3027
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3028
INSERT INTO t4 (c1) VALUES(10);
3029
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3030
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3031
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3032
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3033
DROP TABLE t1,t2,t3,t4,t5,t6;
3034
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3035
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3036
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3037
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3038
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3039
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3040
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3041
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3042
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3043
INSERT INTO t4 (c1) VALUES(10);
3044
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3045
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3046
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3047
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3048
DROP TABLE t1,t2,t3,t4,t5,t6;
3049
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3050
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3051
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3052
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3053
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3054
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3055
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3056
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3057
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3058
INSERT INTO t4 (c1) VALUES(10);
3059
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3060
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 USING (c1);
3061
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1;
3062
SELECT t1.c1,t5.c1 FROM t1 LEFT JOIN t5 ON t1.c1 = t5.c1 WHERE t1.c1 <=> 5;
3063
DROP TABLE t1,t2,t3,t4,t5,t6;
3064
CREATE TABLE t1 (c1 TINYINT NOT NULL);
3065
CREATE TABLE t2 (c1 TINYINT NOT NULL);
3066
CREATE TABLE t3 (c1 TINYINT NOT NULL);
3067
CREATE TABLE t4 (c1 TINYINT NOT NULL);
3068
CREATE TABLE t5 (c1 TINYINT NOT NULL);
3069
CREATE TABLE t6 (c1 TINYINT NOT NULL);
3070
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3071
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3072
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3073
INSERT INTO t4 (c1) VALUES(10);
3074
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3075
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3076
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3077
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3078
DROP TABLE t1,t2,t3,t4,t5,t6;
3079
CREATE TABLE t1 (c1 SMALLINT NOT NULL);
3080
CREATE TABLE t2 (c1 SMALLINT NOT NULL);
3081
CREATE TABLE t3 (c1 SMALLINT NOT NULL);
3082
CREATE TABLE t4 (c1 SMALLINT NOT NULL);
3083
CREATE TABLE t5 (c1 SMALLINT NOT NULL);
3084
CREATE TABLE t6 (c1 SMALLINT NOT NULL);
3085
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3086
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3087
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3088
INSERT INTO t4 (c1) VALUES(10);
3089
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3090
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3091
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3092
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3093
DROP TABLE t1,t2,t3,t4,t5,t6;
3094
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL);
3095
CREATE TABLE t2 (c1 MEDIUMINT NOT NULL);
3096
CREATE TABLE t3 (c1 MEDIUMINT NOT NULL);
3097
CREATE TABLE t4 (c1 MEDIUMINT NOT NULL);
3098
CREATE TABLE t5 (c1 MEDIUMINT NOT NULL);
3099
CREATE TABLE t6 (c1 MEDIUMINT NOT NULL);
3100
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3101
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3102
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3103
INSERT INTO t4 (c1) VALUES(10);
3104
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3105
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3106
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3107
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3108
DROP TABLE t1,t2,t3,t4,t5,t6;
3109
CREATE TABLE t1 (c1 INT NOT NULL);
3110
CREATE TABLE t2 (c1 INT NOT NULL);
3111
CREATE TABLE t3 (c1 INT NOT NULL);
3112
CREATE TABLE t4 (c1 INT NOT NULL);
3113
CREATE TABLE t5 (c1 INT NOT NULL);
3114
CREATE TABLE t6 (c1 INT NOT NULL);
3115
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3116
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3117
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3118
INSERT INTO t4 (c1) VALUES(10);
3119
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3120
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3121
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3122
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3123
DROP TABLE t1,t2,t3,t4,t5,t6;
3124
CREATE TABLE t1 (c1 INTEGER NOT NULL);
3125
CREATE TABLE t2 (c1 INTEGER NOT NULL);
3126
CREATE TABLE t3 (c1 INTEGER NOT NULL);
3127
CREATE TABLE t4 (c1 INTEGER NOT NULL);
3128
CREATE TABLE t5 (c1 INTEGER NOT NULL);
3129
CREATE TABLE t6 (c1 INTEGER NOT NULL);
3130
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3131
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3132
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3133
INSERT INTO t4 (c1) VALUES(10);
3134
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3135
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3136
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3137
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3138
DROP TABLE t1,t2,t3,t4,t5,t6;
3139
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3140
CREATE TABLE t2 (c1 BIGINT NOT NULL);
3141
CREATE TABLE t3 (c1 BIGINT NOT NULL);
3142
CREATE TABLE t4 (c1 BIGINT NOT NULL);
3143
CREATE TABLE t5 (c1 BIGINT NOT NULL);
3144
CREATE TABLE t6 (c1 BIGINT NOT NULL);
3145
INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3146
INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3147
INSERT INTO t3 (c1) VALUES(1),(3),(5),(7),(9);
3148
INSERT INTO t4 (c1) VALUES(10);
3149
INSERT INTO t5 (c1) VALUES(10),(11),(12),(13),(14);
3150
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 USING (c1);
3151
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1;
3152
SELECT t1.c1,t6.c1 FROM t1 LEFT JOIN t6 ON t1.c1 = t6.c1 WHERE t1.c1 <=> 5;
3153
DROP TABLE t1,t2,t3,t4,t5,t6;