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