2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
5
SET SQL_AUTO_IS_NULL = 1;
6
INSERT INTO t1 VALUES(null);
7
INSERT INTO t1 VALUES(null);
8
INSERT INTO t1 VALUES(null);
9
SELECT * FROM t1 WHERE c1 IS NULL;
11
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
12
SET SQL_AUTO_IS_NULL = 1;
13
INSERT INTO t1 VALUES(null);
14
INSERT INTO t1 VALUES(null);
15
INSERT INTO t1 VALUES(null);
16
SELECT * FROM t1 WHERE c1 IS NULL;
18
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
19
SET SQL_AUTO_IS_NULL = 1;
20
INSERT INTO t1 VALUES(null);
21
INSERT INTO t1 VALUES(null);
22
INSERT INTO t1 VALUES(null);
23
SELECT * FROM t1 WHERE c1 IS NULL;
25
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
26
SET SQL_AUTO_IS_NULL = 1;
27
INSERT INTO t1 VALUES(null);
28
INSERT INTO t1 VALUES(null);
29
INSERT INTO t1 VALUES(null);
30
SELECT * FROM t1 WHERE c1 IS NULL;
32
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
33
SET SQL_AUTO_IS_NULL = 1;
34
INSERT INTO t1 VALUES(null);
35
INSERT INTO t1 VALUES(null);
36
INSERT INTO t1 VALUES(null);
37
SELECT * FROM t1 WHERE c1 IS NULL;
39
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
40
SET SQL_AUTO_IS_NULL = 1;
41
INSERT INTO t1 VALUES(null);
42
INSERT INTO t1 VALUES(null);
43
INSERT INTO t1 VALUES(null);
44
SELECT * FROM t1 WHERE c1 IS NULL;
46
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
47
SET SQL_AUTO_IS_NULL = 1;
48
INSERT INTO t1 VALUES(null);
49
INSERT INTO t1 VALUES(null);
50
INSERT INTO t1 VALUES(null);
51
SELECT * FROM t1 WHERE c1 IS NULL;
53
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
54
SET SQL_AUTO_IS_NULL = 1;
55
INSERT INTO t1 VALUES(null);
56
INSERT INTO t1 VALUES(null);
57
INSERT INTO t1 VALUES(null);
58
SELECT * FROM t1 WHERE c1 IS NULL;
60
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
61
SET SQL_AUTO_IS_NULL = 1;
62
INSERT INTO t1 VALUES(null);
63
INSERT INTO t1 VALUES(null);
64
INSERT INTO t1 VALUES(null);
65
SELECT * FROM t1 WHERE c1 IS NULL;
67
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
68
SET SQL_AUTO_IS_NULL = 1;
69
INSERT INTO t1 VALUES(null);
70
INSERT INTO t1 VALUES(null);
71
INSERT INTO t1 VALUES(null);
72
SELECT * FROM t1 WHERE c1 IS NULL;
74
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
75
SET SQL_AUTO_IS_NULL = 1;
76
INSERT INTO t1 VALUES(null);
77
INSERT INTO t1 VALUES(null);
78
INSERT INTO t1 VALUES(null);
79
SELECT * FROM t1 WHERE c1 IS NULL;
81
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
82
SET SQL_AUTO_IS_NULL = 1;
83
INSERT INTO t1 VALUES(null);
84
INSERT INTO t1 VALUES(null);
85
INSERT INTO t1 VALUES(null);
86
SELECT * FROM t1 WHERE c1 IS NULL;
88
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
89
SET SQL_AUTO_IS_NULL = 1;
90
INSERT INTO t1 VALUES(null);
91
INSERT INTO t1 VALUES(null);
92
INSERT INTO t1 VALUES(null);
93
SELECT * FROM t1 WHERE c1 IS NULL;
95
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
96
SET SQL_AUTO_IS_NULL = 1;
97
INSERT INTO t1 VALUES(null);
98
INSERT INTO t1 VALUES(null);
99
INSERT INTO t1 VALUES(null);
100
SELECT * FROM t1 WHERE c1 IS NULL;
102
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
103
SET SQL_AUTO_IS_NULL = 1;
104
INSERT INTO t1 VALUES(null);
105
INSERT INTO t1 VALUES(null);
106
INSERT INTO t1 VALUES(null);
107
SELECT * FROM t1 WHERE c1 IS NULL;
109
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
110
SET SQL_AUTO_IS_NULL = 1;
111
INSERT INTO t1 VALUES(null);
112
INSERT INTO t1 VALUES(null);
113
INSERT INTO t1 VALUES(null);
114
SELECT * FROM t1 WHERE c1 IS NULL;
116
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
117
SET SQL_AUTO_IS_NULL = 1;
118
INSERT INTO t1 VALUES(null);
119
INSERT INTO t1 VALUES(null);
120
INSERT INTO t1 VALUES(null);
121
SELECT * FROM t1 WHERE c1 IS NULL;
123
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
124
SET SQL_AUTO_IS_NULL = 1;
125
INSERT INTO t1 VALUES(null);
126
INSERT INTO t1 VALUES(null);
127
INSERT INTO t1 VALUES(null);
128
SELECT * FROM t1 WHERE c1 IS NULL;
130
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
131
SET SQL_AUTO_IS_NULL = 1;
132
INSERT INTO t1 VALUES(null);
133
INSERT INTO t1 VALUES(null);
134
INSERT INTO t1 VALUES(null);
135
SELECT * FROM t1 WHERE c1 IS NULL;
137
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
138
SET SQL_AUTO_IS_NULL = 1;
139
INSERT INTO t1 VALUES(null);
140
INSERT INTO t1 VALUES(null);
141
INSERT INTO t1 VALUES(null);
142
SELECT * FROM t1 WHERE c1 IS NULL;
144
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
145
SET SQL_AUTO_IS_NULL = 1;
146
INSERT INTO t1 VALUES(null);
147
INSERT INTO t1 VALUES(null);
148
INSERT INTO t1 VALUES(null);
149
SELECT * FROM t1 WHERE c1 IS NULL;
151
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
152
SET SQL_AUTO_IS_NULL = 1;
153
INSERT INTO t1 VALUES(null);
154
INSERT INTO t1 VALUES(null);
155
INSERT INTO t1 VALUES(null);
156
SELECT * FROM t1 WHERE c1 IS NULL;
158
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
159
SET SQL_AUTO_IS_NULL = 1;
160
INSERT INTO t1 VALUES(null);
161
INSERT INTO t1 VALUES(null);
162
INSERT INTO t1 VALUES(null);
163
SELECT * FROM t1 WHERE c1 IS NULL;
165
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
166
SET SQL_AUTO_IS_NULL = 1;
167
INSERT INTO t1 VALUES(null);
168
INSERT INTO t1 VALUES(null);
169
INSERT INTO t1 VALUES(null);
170
SELECT * FROM t1 WHERE c1 IS NULL;
172
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
173
SET SQL_AUTO_IS_NULL = 1;
174
INSERT INTO t1 VALUES(null);
175
INSERT INTO t1 VALUES(null);
176
INSERT INTO t1 VALUES(null);
177
SELECT * FROM t1 WHERE c1 IS NULL;
179
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
180
SET SQL_AUTO_IS_NULL = 1;
181
INSERT INTO t1 VALUES(null);
182
INSERT INTO t1 VALUES(null);
183
INSERT INTO t1 VALUES(null);
184
SELECT * FROM t1 WHERE c1 IS NULL;
186
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
187
SET SQL_AUTO_IS_NULL = 1;
188
INSERT INTO t1 VALUES(null);
189
INSERT INTO t1 VALUES(null);
190
INSERT INTO t1 VALUES(null);
191
SELECT * FROM t1 WHERE c1 IS NULL;
193
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
194
SET SQL_AUTO_IS_NULL = 1;
195
INSERT INTO t1 VALUES(null);
196
INSERT INTO t1 VALUES(null);
197
INSERT INTO t1 VALUES(null);
198
SELECT * FROM t1 WHERE c1 IS NULL;
200
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
201
SET SQL_AUTO_IS_NULL = 1;
202
INSERT INTO t1 VALUES(null);
203
INSERT INTO t1 VALUES(null);
204
INSERT INTO t1 VALUES(null);
205
SELECT * FROM t1 WHERE c1 IS NULL;
207
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
208
SET SQL_AUTO_IS_NULL = 1;
209
INSERT INTO t1 VALUES(null);
210
INSERT INTO t1 VALUES(null);
211
INSERT INTO t1 VALUES(null);
212
SELECT * FROM t1 WHERE c1 IS NULL;
214
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
215
SET SQL_AUTO_IS_NULL = 1;
216
INSERT INTO t1 VALUES(null);
217
INSERT INTO t1 VALUES(null);
218
INSERT INTO t1 VALUES(null);
219
SELECT * FROM t1 WHERE c1 IS NULL;
221
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
222
SET SQL_AUTO_IS_NULL = 1;
223
INSERT INTO t1 VALUES(null);
224
INSERT INTO t1 VALUES(null);
225
INSERT INTO t1 VALUES(null);
226
SELECT * FROM t1 WHERE c1 IS NULL;
228
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
229
SET SQL_AUTO_IS_NULL = 1;
230
INSERT INTO t1 VALUES(null);
231
INSERT INTO t1 VALUES(null);
232
INSERT INTO t1 VALUES(null);
233
SELECT * FROM t1 WHERE c1 IS NULL;
235
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
236
SET SQL_AUTO_IS_NULL = 1;
237
INSERT INTO t1 VALUES(null);
238
INSERT INTO t1 VALUES(null);
239
INSERT INTO t1 VALUES(null);
240
SELECT * FROM t1 WHERE c1 IS NULL;
242
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
243
SET SQL_AUTO_IS_NULL = 1;
244
INSERT INTO t1 VALUES(null);
245
INSERT INTO t1 VALUES(null);
246
INSERT INTO t1 VALUES(null);
247
SELECT * FROM t1 WHERE c1 IS NULL;
249
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
250
SET SQL_AUTO_IS_NULL = 1;
251
INSERT INTO t1 VALUES(null);
252
INSERT INTO t1 VALUES(null);
253
INSERT INTO t1 VALUES(null);
254
SELECT * FROM t1 WHERE c1 IS NULL;
256
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
257
SET SQL_AUTO_IS_NULL = 1;
258
INSERT INTO t1 VALUES(null);
259
INSERT INTO t1 VALUES(null);
260
INSERT INTO t1 VALUES(null);
261
SELECT * FROM t1 WHERE c1 IS NULL;
263
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
264
SET SQL_AUTO_IS_NULL = 1;
265
INSERT INTO t1 VALUES(null);
266
INSERT INTO t1 VALUES(null);
267
INSERT INTO t1 VALUES(null);
268
SELECT * FROM t1 WHERE c1 IS NULL;
270
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
271
SET SQL_AUTO_IS_NULL = 1;
272
INSERT INTO t1 VALUES(null);
273
INSERT INTO t1 VALUES(null);
274
INSERT INTO t1 VALUES(null);
275
SELECT * FROM t1 WHERE c1 IS NULL;
277
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
278
SET SQL_AUTO_IS_NULL = 1;
279
INSERT INTO t1 VALUES(null);
280
INSERT INTO t1 VALUES(null);
281
INSERT INTO t1 VALUES(null);
282
SELECT * FROM t1 WHERE c1 IS NULL;
284
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
285
SET SQL_AUTO_IS_NULL = 1;
286
INSERT INTO t1 VALUES(null);
287
INSERT INTO t1 VALUES(null);
288
INSERT INTO t1 VALUES(null);
289
SELECT * FROM t1 WHERE c1 IS NULL;
291
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
292
SET SQL_AUTO_IS_NULL = 1;
293
INSERT INTO t1 VALUES(null);
294
INSERT INTO t1 VALUES(null);
295
INSERT INTO t1 VALUES(null);
296
SELECT * FROM t1 WHERE c1 IS NULL;
298
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
299
SET SQL_AUTO_IS_NULL = 1;
300
INSERT INTO t1 VALUES(null);
301
INSERT INTO t1 VALUES(null);
302
INSERT INTO t1 VALUES(null);
303
SELECT * FROM t1 WHERE c1 IS NULL;
305
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
306
SET SQL_AUTO_IS_NULL = 1;
307
INSERT INTO t1 VALUES(null);
308
INSERT INTO t1 VALUES(null);
309
INSERT INTO t1 VALUES(null);
310
SELECT * FROM t1 WHERE c1 IS NULL;
312
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
313
SET SQL_AUTO_IS_NULL = 1;
314
INSERT INTO t1 VALUES(null);
315
INSERT INTO t1 VALUES(null);
316
INSERT INTO t1 VALUES(null);
317
SELECT * FROM t1 WHERE c1 IS NULL;
319
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
320
SET SQL_AUTO_IS_NULL = 1;
321
INSERT INTO t1 VALUES(null);
322
INSERT INTO t1 VALUES(null);
323
INSERT INTO t1 VALUES(null);
324
SELECT * FROM t1 WHERE c1 IS NULL;
326
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
327
SET SQL_AUTO_IS_NULL = 1;
328
INSERT INTO t1 VALUES(null);
329
INSERT INTO t1 VALUES(null);
330
INSERT INTO t1 VALUES(null);
331
SELECT * FROM t1 WHERE c1 IS NULL;
333
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
334
SET SQL_AUTO_IS_NULL = 1;
335
INSERT INTO t1 VALUES(null);
336
INSERT INTO t1 VALUES(null);
337
INSERT INTO t1 VALUES(null);
338
SELECT * FROM t1 WHERE c1 IS NULL;
340
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
341
SET SQL_AUTO_IS_NULL = 1;
342
INSERT INTO t1 VALUES(null);
343
INSERT INTO t1 VALUES(null);
344
INSERT INTO t1 VALUES(null);
345
SELECT * FROM t1 WHERE c1 IS NULL;
347
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
348
SET SQL_AUTO_IS_NULL = 1;
349
INSERT INTO t1 VALUES(null);
350
INSERT INTO t1 VALUES(null);
351
INSERT INTO t1 VALUES(null);
352
SELECT * FROM t1 WHERE c1 IS NULL;
354
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
355
SET SQL_AUTO_IS_NULL = 1;
356
INSERT INTO t1 VALUES(null);
357
INSERT INTO t1 VALUES(null);
358
INSERT INTO t1 VALUES(null);
359
SELECT * FROM t1 WHERE c1 IS NULL;
361
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
362
SET SQL_AUTO_IS_NULL = 1;
363
INSERT INTO t1 VALUES(null);
364
INSERT INTO t1 VALUES(null);
365
INSERT INTO t1 VALUES(null);
366
SELECT * FROM t1 WHERE c1 IS NULL;
368
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
369
SET SQL_AUTO_IS_NULL = 1;
370
INSERT INTO t1 VALUES(null);
371
INSERT INTO t1 VALUES(null);
372
INSERT INTO t1 VALUES(null);
373
SELECT * FROM t1 WHERE c1 IS NULL;
375
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
376
SET SQL_AUTO_IS_NULL = 1;
377
INSERT INTO t1 VALUES(null);
378
INSERT INTO t1 VALUES(null);
379
INSERT INTO t1 VALUES(null);
380
SELECT * FROM t1 WHERE c1 IS NULL;
382
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
383
SET SQL_AUTO_IS_NULL = 1;
384
INSERT INTO t1 VALUES(null);
385
INSERT INTO t1 VALUES(null);
386
INSERT INTO t1 VALUES(null);
387
SELECT * FROM t1 WHERE c1 IS NULL;
389
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
390
SET SQL_AUTO_IS_NULL = 1;
391
INSERT INTO t1 VALUES(null);
392
INSERT INTO t1 VALUES(null);
393
INSERT INTO t1 VALUES(null);
394
SELECT * FROM t1 WHERE c1 IS NULL;
396
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
397
SET SQL_AUTO_IS_NULL = 1;
398
INSERT INTO t1 VALUES(null);
399
INSERT INTO t1 VALUES(null);
400
INSERT INTO t1 VALUES(null);
401
SELECT * FROM t1 WHERE c1 IS NULL;
403
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
404
SET SQL_AUTO_IS_NULL = 1;
405
INSERT INTO t1 VALUES(null);
406
INSERT INTO t1 VALUES(null);
407
INSERT INTO t1 VALUES(null);
408
SELECT * FROM t1 WHERE c1 IS NULL;
410
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
411
SET SQL_AUTO_IS_NULL = 1;
412
INSERT INTO t1 VALUES(null);
413
INSERT INTO t1 VALUES(null);
414
INSERT INTO t1 VALUES(null);
415
SELECT * FROM t1 WHERE c1 IS NULL;
417
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
418
SET SQL_AUTO_IS_NULL = 1;
419
INSERT INTO t1 VALUES(null);
420
INSERT INTO t1 VALUES(null);
421
INSERT INTO t1 VALUES(null);
422
SELECT * FROM t1 WHERE c1 IS NULL;