Debian Codegraph @

mysql-test/suite/engines/funcs/t/ai_sql_auto_is_null.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT 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;
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 DROP TABLE t1;
18 CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT 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;
24 DROP TABLE t1;
25 CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT 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;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT 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;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT 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;
45 DROP TABLE t1;
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;
52 DROP TABLE t1;
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;
59 DROP TABLE t1;
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;
66 DROP TABLE t1;
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;
73 DROP TABLE t1;
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;
80 DROP TABLE t1;
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;
87 DROP TABLE t1;
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;
94 DROP TABLE t1;
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;
101 DROP TABLE t1;
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;
108 DROP TABLE t1;
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;
115 DROP TABLE t1;
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;
122 DROP TABLE t1;
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;
129 DROP TABLE t1;
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;
136 DROP TABLE t1;
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;
143 DROP TABLE t1;
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;
150 DROP TABLE t1;
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;
157 DROP TABLE t1;
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;
164 DROP TABLE t1;
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;
171 DROP TABLE t1;
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;
178 DROP TABLE t1;
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;
185 DROP TABLE t1;
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;
192 DROP TABLE t1;
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;
199 DROP TABLE t1;
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;
206 DROP TABLE t1;
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;
213 DROP TABLE t1;
214 CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT 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;
220 DROP TABLE t1;
221 CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT 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;
227 DROP TABLE t1;
228 CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT 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;
234 DROP TABLE t1;
235 CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT 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;
241 DROP TABLE t1;
242 CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT 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;
248 DROP TABLE t1;
249 CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT 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;
255 DROP TABLE t1;
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;
262 DROP TABLE t1;
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;
269 DROP TABLE t1;
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;
276 DROP TABLE t1;
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;
283 DROP TABLE t1;
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;
290 DROP TABLE t1;
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;
297 DROP TABLE t1;
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;
304 DROP TABLE t1;
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;
311 DROP TABLE t1;
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;
318 DROP TABLE t1;
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;
325 DROP TABLE t1;
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;
332 DROP TABLE t1;
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;
339 DROP TABLE t1;
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;
346 DROP TABLE t1;
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;
353 DROP TABLE t1;
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;
360 DROP TABLE t1;
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;
367 DROP TABLE t1;
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;
374 DROP TABLE t1;
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;
381 DROP TABLE t1;
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;
388 DROP TABLE t1;
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;
395 DROP TABLE t1;
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;
402 DROP TABLE t1;
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;
409 DROP TABLE t1;
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;
416 DROP TABLE t1;
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;
423 DROP TABLE t1;
424