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