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