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