Debian Codegraph @

mysql-test/suite/engines/funcs/r/ai_sql_auto_is_null.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
3 SET SQL_AUTO_IS_NULL = 1;
4 INSERT INTO t1 VALUES(null);
5 INSERT INTO t1 VALUES(null);
6 INSERT INTO t1 VALUES(null);
7 SELECT * FROM t1 WHERE c1 IS NULL;
8 c1
9 3
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT 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;
17 c1
18 3
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
21 SET SQL_AUTO_IS_NULL = 1;
22 INSERT INTO t1 VALUES(null);
23 INSERT INTO t1 VALUES(null);
24 INSERT INTO t1 VALUES(null);
25 SELECT * FROM t1 WHERE c1 IS NULL;
26 c1
27 3
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
30 SET SQL_AUTO_IS_NULL = 1;
31 INSERT INTO t1 VALUES(null);
32 INSERT INTO t1 VALUES(null);
33 INSERT INTO t1 VALUES(null);
34 SELECT * FROM t1 WHERE c1 IS NULL;
35 c1
36 3
37 DROP TABLE t1;
38 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
39 SET SQL_AUTO_IS_NULL = 1;
40 INSERT INTO t1 VALUES(null);
41 INSERT INTO t1 VALUES(null);
42 INSERT INTO t1 VALUES(null);
43 SELECT * FROM t1 WHERE c1 IS NULL;
44 c1
45 3
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
48 SET SQL_AUTO_IS_NULL = 1;
49 INSERT INTO t1 VALUES(null);
50 INSERT INTO t1 VALUES(null);
51 INSERT INTO t1 VALUES(null);
52 SELECT * FROM t1 WHERE c1 IS NULL;
53 c1
54 3
55 DROP TABLE t1;
56 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
57 SET SQL_AUTO_IS_NULL = 1;
58 INSERT INTO t1 VALUES(null);
59 INSERT INTO t1 VALUES(null);
60 INSERT INTO t1 VALUES(null);
61 SELECT * FROM t1 WHERE c1 IS NULL;
62 c1
63 3
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
66 SET SQL_AUTO_IS_NULL = 1;
67 INSERT INTO t1 VALUES(null);
68 INSERT INTO t1 VALUES(null);
69 INSERT INTO t1 VALUES(null);
70 SELECT * FROM t1 WHERE c1 IS NULL;
71 c1
72 3
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 MEDIUMINT 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;
80 c1
81 3
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
84 SET SQL_AUTO_IS_NULL = 1;
85 INSERT INTO t1 VALUES(null);
86 INSERT INTO t1 VALUES(null);
87 INSERT INTO t1 VALUES(null);
88 SELECT * FROM t1 WHERE c1 IS NULL;
89 c1
90 3
91 DROP TABLE t1;
92 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
93 SET SQL_AUTO_IS_NULL = 1;
94 INSERT INTO t1 VALUES(null);
95 INSERT INTO t1 VALUES(null);
96 INSERT INTO t1 VALUES(null);
97 SELECT * FROM t1 WHERE c1 IS NULL;
98 c1
99 3
100 DROP TABLE t1;
101 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
102 SET SQL_AUTO_IS_NULL = 1;
103 INSERT INTO t1 VALUES(null);
104 INSERT INTO t1 VALUES(null);
105 INSERT INTO t1 VALUES(null);
106 SELECT * FROM t1 WHERE c1 IS NULL;
107 c1
108 3
109 DROP TABLE t1;
110 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
111 SET SQL_AUTO_IS_NULL = 1;
112 INSERT INTO t1 VALUES(null);
113 INSERT INTO t1 VALUES(null);
114 INSERT INTO t1 VALUES(null);
115 SELECT * FROM t1 WHERE c1 IS NULL;
116 c1
117 DROP TABLE t1;
118 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
119 SET SQL_AUTO_IS_NULL = 1;
120 INSERT INTO t1 VALUES(null);
121 INSERT INTO t1 VALUES(null);
122 INSERT INTO t1 VALUES(null);
123 SELECT * FROM t1 WHERE c1 IS NULL;
124 c1
125 DROP TABLE t1;
126 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
127 SET SQL_AUTO_IS_NULL = 1;
128 INSERT INTO t1 VALUES(null);
129 INSERT INTO t1 VALUES(null);
130 INSERT INTO t1 VALUES(null);
131 SELECT * FROM t1 WHERE c1 IS NULL;
132 c1
133 DROP TABLE t1;
134 CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
135 SET SQL_AUTO_IS_NULL = 1;
136 INSERT INTO t1 VALUES(null);
137 INSERT INTO t1 VALUES(null);
138 INSERT INTO t1 VALUES(null);
139 SELECT * FROM t1 WHERE c1 IS NULL;
140 c1
141 DROP TABLE t1;
142 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
143 SET SQL_AUTO_IS_NULL = 1;
144 INSERT INTO t1 VALUES(null);
145 INSERT INTO t1 VALUES(null);
146 INSERT INTO t1 VALUES(null);
147 SELECT * FROM t1 WHERE c1 IS NULL;
148 c1
149 DROP TABLE t1;
150 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
151 SET SQL_AUTO_IS_NULL = 1;
152 INSERT INTO t1 VALUES(null);
153 INSERT INTO t1 VALUES(null);
154 INSERT INTO t1 VALUES(null);
155 SELECT * FROM t1 WHERE c1 IS NULL;
156 c1
157 DROP TABLE t1;
158 CREATE TABLE t1(c1 TINYINT 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;
164 c1
165 3
166 DROP TABLE t1;
167 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
168 SET SQL_AUTO_IS_NULL = 1;
169 INSERT INTO t1 VALUES(null);
170 INSERT INTO t1 VALUES(null);
171 INSERT INTO t1 VALUES(null);
172 SELECT * FROM t1 WHERE c1 IS NULL;
173 c1
174 3
175 DROP TABLE t1;
176 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
177 SET SQL_AUTO_IS_NULL = 1;
178 INSERT INTO t1 VALUES(null);
179 INSERT INTO t1 VALUES(null);
180 INSERT INTO t1 VALUES(null);
181 SELECT * FROM t1 WHERE c1 IS NULL;
182 c1
183 3
184 DROP TABLE t1;
185 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
186 SET SQL_AUTO_IS_NULL = 1;
187 INSERT INTO t1 VALUES(null);
188 INSERT INTO t1 VALUES(null);
189 INSERT INTO t1 VALUES(null);
190 SELECT * FROM t1 WHERE c1 IS NULL;
191 c1
192 3
193 DROP TABLE t1;
194 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
195 SET SQL_AUTO_IS_NULL = 1;
196 INSERT INTO t1 VALUES(null);
197 INSERT INTO t1 VALUES(null);
198 INSERT INTO t1 VALUES(null);
199 SELECT * FROM t1 WHERE c1 IS NULL;
200 c1
201 3
202 DROP TABLE t1;
203 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
204 SET SQL_AUTO_IS_NULL = 1;
205 INSERT INTO t1 VALUES(null);
206 INSERT INTO t1 VALUES(null);
207 INSERT INTO t1 VALUES(null);
208 SELECT * FROM t1 WHERE c1 IS NULL;
209 c1
210 3
211 DROP TABLE t1;
212 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
213 SET SQL_AUTO_IS_NULL = 1;
214 INSERT INTO t1 VALUES(null);
215 INSERT INTO t1 VALUES(null);
216 INSERT INTO t1 VALUES(null);
217 SELECT * FROM t1 WHERE c1 IS NULL;
218 c1
219 3
220 DROP TABLE t1;
221 CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY 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;
227 c1
228 3
229 DROP TABLE t1;
230 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
231 SET SQL_AUTO_IS_NULL = 1;
232 INSERT INTO t1 VALUES(null);
233 INSERT INTO t1 VALUES(null);
234 INSERT INTO t1 VALUES(null);
235 SELECT * FROM t1 WHERE c1 IS NULL;
236 c1
237 3
238 DROP TABLE t1;
239 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
240 SET SQL_AUTO_IS_NULL = 1;
241 INSERT INTO t1 VALUES(null);
242 INSERT INTO t1 VALUES(null);
243 INSERT INTO t1 VALUES(null);
244 SELECT * FROM t1 WHERE c1 IS NULL;
245 c1
246 3
247 DROP TABLE t1;
248 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
249 SET SQL_AUTO_IS_NULL = 1;
250 INSERT INTO t1 VALUES(null);
251 INSERT INTO t1 VALUES(null);
252 INSERT INTO t1 VALUES(null);
253 SELECT * FROM t1 WHERE c1 IS NULL;
254 c1
255 3
256 DROP TABLE t1;
257 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
258 SET SQL_AUTO_IS_NULL = 1;
259 INSERT INTO t1 VALUES(null);
260 INSERT INTO t1 VALUES(null);
261 INSERT INTO t1 VALUES(null);
262 SELECT * FROM t1 WHERE c1 IS NULL;
263 c1
264 3
265 DROP TABLE t1;
266 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
267 SET SQL_AUTO_IS_NULL = 1;
268 INSERT INTO t1 VALUES(null);
269 INSERT INTO t1 VALUES(null);
270 INSERT INTO t1 VALUES(null);
271 SELECT * FROM t1 WHERE c1 IS NULL;
272 c1
273 3
274 DROP TABLE t1;
275 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
276 SET SQL_AUTO_IS_NULL = 1;
277 INSERT INTO t1 VALUES(null);
278 INSERT INTO t1 VALUES(null);
279 INSERT INTO t1 VALUES(null);
280 SELECT * FROM t1 WHERE c1 IS NULL;
281 c1
282 3
283 DROP TABLE t1;
284 CREATE TABLE t1(c1 MEDIUMINT 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;
290 c1
291 3
292 DROP TABLE t1;
293 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
294 SET SQL_AUTO_IS_NULL = 1;
295 INSERT INTO t1 VALUES(null);
296 INSERT INTO t1 VALUES(null);
297 INSERT INTO t1 VALUES(null);
298 SELECT * FROM t1 WHERE c1 IS NULL;
299 c1
300 3
301 DROP TABLE t1;
302 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
303 SET SQL_AUTO_IS_NULL = 1;
304 INSERT INTO t1 VALUES(null);
305 INSERT INTO t1 VALUES(null);
306 INSERT INTO t1 VALUES(null);
307 SELECT * FROM t1 WHERE c1 IS NULL;
308 c1
309 3
310 DROP TABLE t1;
311 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
312 SET SQL_AUTO_IS_NULL = 1;
313 INSERT INTO t1 VALUES(null);
314 INSERT INTO t1 VALUES(null);
315 INSERT INTO t1 VALUES(null);
316 SELECT * FROM t1 WHERE c1 IS NULL;
317 c1
318 3
319 DROP TABLE t1;
320 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
321 SET SQL_AUTO_IS_NULL = 1;
322 INSERT INTO t1 VALUES(null);
323 INSERT INTO t1 VALUES(null);
324 INSERT INTO t1 VALUES(null);
325 SELECT * FROM t1 WHERE c1 IS NULL;
326 c1
327 3
328 DROP TABLE t1;
329 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
330 SET SQL_AUTO_IS_NULL = 1;
331 INSERT INTO t1 VALUES(null);
332 INSERT INTO t1 VALUES(null);
333 INSERT INTO t1 VALUES(null);
334 SELECT * FROM t1 WHERE c1 IS NULL;
335 c1
336 3
337 DROP TABLE t1;
338 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
339 SET SQL_AUTO_IS_NULL = 1;
340 INSERT INTO t1 VALUES(null);
341 INSERT INTO t1 VALUES(null);
342 INSERT INTO t1 VALUES(null);
343 SELECT * FROM t1 WHERE c1 IS NULL;
344 c1
345 3
346 DROP TABLE t1;
347 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL 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;
353 c1
354 3
355 DROP TABLE t1;
356 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
357 SET SQL_AUTO_IS_NULL = 1;
358 INSERT INTO t1 VALUES(null);
359 INSERT INTO t1 VALUES(null);
360 INSERT INTO t1 VALUES(null);
361 SELECT * FROM t1 WHERE c1 IS NULL;
362 c1
363 3
364 DROP TABLE t1;
365 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
366 SET SQL_AUTO_IS_NULL = 1;
367 INSERT INTO t1 VALUES(null);
368 INSERT INTO t1 VALUES(null);
369 INSERT INTO t1 VALUES(null);
370 SELECT * FROM t1 WHERE c1 IS NULL;
371 c1
372 3
373 DROP TABLE t1;
374 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
375 SET SQL_AUTO_IS_NULL = 1;
376 INSERT INTO t1 VALUES(null);
377 INSERT INTO t1 VALUES(null);
378 INSERT INTO t1 VALUES(null);
379 SELECT * FROM t1 WHERE c1 IS NULL;
380 c1
381 DROP TABLE t1;
382 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE 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;
388 c1
389 DROP TABLE t1;
390 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
391 SET SQL_AUTO_IS_NULL = 1;
392 INSERT INTO t1 VALUES(null);
393 INSERT INTO t1 VALUES(null);
394 INSERT INTO t1 VALUES(null);
395 SELECT * FROM t1 WHERE c1 IS NULL;
396 c1
397 DROP TABLE t1;
398 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
399 SET SQL_AUTO_IS_NULL = 1;
400 INSERT INTO t1 VALUES(null);
401 INSERT INTO t1 VALUES(null);
402 INSERT INTO t1 VALUES(null);
403 SELECT * FROM t1 WHERE c1 IS NULL;
404 c1
405 DROP TABLE t1;
406 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
407 SET SQL_AUTO_IS_NULL = 1;
408 INSERT INTO t1 VALUES(null);
409 INSERT INTO t1 VALUES(null);
410 INSERT INTO t1 VALUES(null);
411 SELECT * FROM t1 WHERE c1 IS NULL;
412 c1
413 DROP TABLE t1;
414 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
415 SET SQL_AUTO_IS_NULL = 1;
416 INSERT INTO t1 VALUES(null);
417 INSERT INTO t1 VALUES(null);
418 INSERT INTO t1 VALUES(null);
419 SELECT * FROM t1 WHERE c1 IS NULL;
420 c1
421 DROP TABLE t1;
422 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
423 SET SQL_AUTO_IS_NULL = 1;
424 INSERT INTO t1 VALUES(null);
425 INSERT INTO t1 VALUES(null);
426 INSERT INTO t1 VALUES(null);
427 SELECT * FROM t1 WHERE c1 IS NULL;
428 c1
429 3
430 DROP TABLE t1;
431 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
432 SET SQL_AUTO_IS_NULL = 1;
433 INSERT INTO t1 VALUES(null);
434 INSERT INTO t1 VALUES(null);
435 INSERT INTO t1 VALUES(null);
436 SELECT * FROM t1 WHERE c1 IS NULL;
437 c1
438 3
439 DROP TABLE t1;
440 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
441 SET SQL_AUTO_IS_NULL = 1;
442 INSERT INTO t1 VALUES(null);
443 INSERT INTO t1 VALUES(null);
444 INSERT INTO t1 VALUES(null);
445 SELECT * FROM t1 WHERE c1 IS NULL;
446 c1
447 3
448 DROP TABLE t1;
449 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
450 SET SQL_AUTO_IS_NULL = 1;
451 INSERT INTO t1 VALUES(null);
452 INSERT INTO t1 VALUES(null);
453 INSERT INTO t1 VALUES(null);
454 SELECT * FROM t1 WHERE c1 IS NULL;
455 c1
456 3
457 DROP TABLE t1;
458 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
459 SET SQL_AUTO_IS_NULL = 1;
460 INSERT INTO t1 VALUES(null);
461 INSERT INTO t1 VALUES(null);
462 INSERT INTO t1 VALUES(null);
463 SELECT * FROM t1 WHERE c1 IS NULL;
464 c1
465 3
466 DROP TABLE t1;
467 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
468 SET SQL_AUTO_IS_NULL = 1;
469 INSERT INTO t1 VALUES(null);
470 INSERT INTO t1 VALUES(null);
471 INSERT INTO t1 VALUES(null);
472 SELECT * FROM t1 WHERE c1 IS NULL;
473 c1
474 3
475 DROP TABLE t1;
476 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
477 SET SQL_AUTO_IS_NULL = 1;
478 INSERT INTO t1 VALUES(null);
479 INSERT INTO t1 VALUES(null);
480 INSERT INTO t1 VALUES(null);
481 SELECT * FROM t1 WHERE c1 IS NULL;
482 c1
483 3
484 DROP TABLE t1;
485 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
486 SET SQL_AUTO_IS_NULL = 1;
487 INSERT INTO t1 VALUES(null);
488 INSERT INTO t1 VALUES(null);
489 INSERT INTO t1 VALUES(null);
490 SELECT * FROM t1 WHERE c1 IS NULL;
491 c1
492 3
493 DROP TABLE t1;
494 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
495 SET SQL_AUTO_IS_NULL = 1;
496 INSERT INTO t1 VALUES(null);
497 INSERT INTO t1 VALUES(null);
498 INSERT INTO t1 VALUES(null);
499 SELECT * FROM t1 WHERE c1 IS NULL;
500 c1
501 3
502 DROP TABLE t1;
503 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
504 SET SQL_AUTO_IS_NULL = 1;
505 INSERT INTO t1 VALUES(null);
506 INSERT INTO t1 VALUES(null);
507 INSERT INTO t1 VALUES(null);
508 SELECT * FROM t1 WHERE c1 IS NULL;
509 c1
510 3
511 DROP TABLE t1;
512 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
513 SET SQL_AUTO_IS_NULL = 1;
514 INSERT INTO t1 VALUES(null);
515 INSERT INTO t1 VALUES(null);
516 INSERT INTO t1 VALUES(null);
517 SELECT * FROM t1 WHERE c1 IS NULL;
518 c1
519 3
520 DROP TABLE t1;
521 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
522 SET SQL_AUTO_IS_NULL = 1;
523 INSERT INTO t1 VALUES(null);
524 INSERT INTO t1 VALUES(null);
525 INSERT INTO t1 VALUES(null);
526 SELECT * FROM t1 WHERE c1 IS NULL;
527 c1
528 3
529 DROP TABLE t1;