Debian Codegraph @

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

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