Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(100) NOT NULL);
3 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
4 SET @a='';
5 EXECUTE stmt1 USING @a;
6 SET @a='x';
7 EXECUTE stmt1 USING @a;
8 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
9 EXECUTE stmt1 USING @a;
10 DEALLOCATE PREPARE stmt1;
11 SELECT * FROM t1;
12 c1
13
14 x
15 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
16 SELECT COUNT(c1) AS total_rows FROM t1;
17 total_rows
18 3
19 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
20 null_rows
21 0
22 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
23 not_null_rows
24 3
25 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
26 SET @a='';
27 EXECUTE stmt1 USING @a;
28 c1
29
30 SET @a='x';
31 EXECUTE stmt1 USING @a;
32 c1
33 x
34 DEALLOCATE PREPARE stmt1;
35 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
36 SET @a='';
37 SET @b='b';
38 EXECUTE stmt1 USING @a,@b;
39 SET @a='x';
40 SET @b='c';
41 EXECUTE stmt1 USING @a,@c;
42 DEALLOCATE PREPARE stmt1;
43 SELECT * FROM t1;
44 c1
45
46 x
47 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
48 SELECT COUNT(c1) AS total_rows FROM t1;
49 total_rows
50 3
51 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
52 null_rows
53 0
54 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
55 not_null_rows
56 3
57 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
58 SET @a='a';
59 EXECUTE stmt1 USING @a;
60 SET @a='b';
61 EXECUTE stmt1 USING @a;
62 SET @a='c';
63 EXECUTE stmt1 USING @a;
64 DEALLOCATE PREPARE stmt1;
65 SELECT * FROM t1;
66 c1
67
68 x
69 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
70 SELECT COUNT(c1) AS total_rows FROM t1;
71 total_rows
72 3
73 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
74 null_rows
75 0
76 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
77 not_null_rows
78 3
79 DROP TABLE t1;
80 CREATE TABLE t1(c1 VARCHAR(100) NOT NULL);
81 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
82 SET @a='';
83 EXECUTE stmt1 USING @a;
84 SET @a='x';
85 EXECUTE stmt1 USING @a;
86 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
87 EXECUTE stmt1 USING @a;
88 DEALLOCATE PREPARE stmt1;
89 SELECT * FROM t1;
90 c1
91
92 x
93 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
94 SELECT COUNT(c1) AS total_rows FROM t1;
95 total_rows
96 3
97 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
98 null_rows
99 0
100 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
101 not_null_rows
102 3
103 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
104 SET @a='';
105 EXECUTE stmt1 USING @a;
106 c1
107
108 SET @a='x';
109 EXECUTE stmt1 USING @a;
110 c1
111 x
112 DEALLOCATE PREPARE stmt1;
113 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
114 SET @a='';
115 SET @b='b';
116 EXECUTE stmt1 USING @a,@b;
117 SET @a='x';
118 SET @b='c';
119 EXECUTE stmt1 USING @a,@c;
120 DEALLOCATE PREPARE stmt1;
121 SELECT * FROM t1;
122 c1
123
124 x
125 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
126 SELECT COUNT(c1) AS total_rows FROM t1;
127 total_rows
128 3
129 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
130 null_rows
131 0
132 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
133 not_null_rows
134 3
135 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
136 SET @a='a';
137 EXECUTE stmt1 USING @a;
138 SET @a='b';
139 EXECUTE stmt1 USING @a;
140 SET @a='c';
141 EXECUTE stmt1 USING @a;
142 DEALLOCATE PREPARE stmt1;
143 SELECT * FROM t1;
144 c1
145
146 x
147 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
148 SELECT COUNT(c1) AS total_rows FROM t1;
149 total_rows
150 3
151 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
152 null_rows
153 0
154 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
155 not_null_rows
156 3
157 DROP TABLE t1;
158 CREATE TABLE t1(c1 BINARY(100) NOT NULL);
159 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
160 SET @a='';
161 EXECUTE stmt1 USING @a;
162 SET @a='x';
163 EXECUTE stmt1 USING @a;
164 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
165 EXECUTE stmt1 USING @a;
166 DEALLOCATE PREPARE stmt1;
167 SELECT * FROM t1;
168 c1
169
170 x
171 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
172 SELECT COUNT(c1) AS total_rows FROM t1;
173 total_rows
174 3
175 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
176 null_rows
177 0
178 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
179 not_null_rows
180 3
181 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
182 SET @a='';
183 EXECUTE stmt1 USING @a;
184 c1
185 SET @a='x';
186 EXECUTE stmt1 USING @a;
187 c1
188 DEALLOCATE PREPARE stmt1;
189 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
190 SET @a='';
191 SET @b='b';
192 EXECUTE stmt1 USING @a,@b;
193 SET @a='x';
194 SET @b='c';
195 EXECUTE stmt1 USING @a,@c;
196 DEALLOCATE PREPARE stmt1;
197 SELECT * FROM t1;
198 c1
199
200 x
201 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
202 SELECT COUNT(c1) AS total_rows FROM t1;
203 total_rows
204 3
205 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
206 null_rows
207 0
208 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
209 not_null_rows
210 3
211 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
212 SET @a='a';
213 EXECUTE stmt1 USING @a;
214 SET @a='b';
215 EXECUTE stmt1 USING @a;
216 SET @a='c';
217 EXECUTE stmt1 USING @a;
218 DEALLOCATE PREPARE stmt1;
219 SELECT * FROM t1;
220 c1
221
222 x
223 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
224 SELECT COUNT(c1) AS total_rows FROM t1;
225 total_rows
226 3
227 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
228 null_rows
229 0
230 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
231 not_null_rows
232 3
233 DROP TABLE t1;
234 CREATE TABLE t1(c1 VARBINARY(100) NOT NULL);
235 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
236 SET @a='';
237 EXECUTE stmt1 USING @a;
238 SET @a='x';
239 EXECUTE stmt1 USING @a;
240 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
241 EXECUTE stmt1 USING @a;
242 DEALLOCATE PREPARE stmt1;
243 SELECT * FROM t1;
244 c1
245
246 x
247 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
248 SELECT COUNT(c1) AS total_rows FROM t1;
249 total_rows
250 3
251 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
252 null_rows
253 0
254 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
255 not_null_rows
256 3
257 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
258 SET @a='';
259 EXECUTE stmt1 USING @a;
260 c1
261
262 SET @a='x';
263 EXECUTE stmt1 USING @a;
264 c1
265 x
266 DEALLOCATE PREPARE stmt1;
267 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
268 SET @a='';
269 SET @b='b';
270 EXECUTE stmt1 USING @a,@b;
271 SET @a='x';
272 SET @b='c';
273 EXECUTE stmt1 USING @a,@c;
274 DEALLOCATE PREPARE stmt1;
275 SELECT * FROM t1;
276 c1
277
278 x
279 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
280 SELECT COUNT(c1) AS total_rows FROM t1;
281 total_rows
282 3
283 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
284 null_rows
285 0
286 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
287 not_null_rows
288 3
289 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
290 SET @a='a';
291 EXECUTE stmt1 USING @a;
292 SET @a='b';
293 EXECUTE stmt1 USING @a;
294 SET @a='c';
295 EXECUTE stmt1 USING @a;
296 DEALLOCATE PREPARE stmt1;
297 SELECT * FROM t1;
298 c1
299
300 x
301 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
302 SELECT COUNT(c1) AS total_rows FROM t1;
303 total_rows
304 3
305 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
306 null_rows
307 0
308 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
309 not_null_rows
310 3
311 DROP TABLE t1;
312 CREATE TABLE t1(c1 BLOB(100) NOT NULL);
313 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
314 SET @a='';
315 EXECUTE stmt1 USING @a;
316 SET @a='x';
317 EXECUTE stmt1 USING @a;
318 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
319 EXECUTE stmt1 USING @a;
320 DEALLOCATE PREPARE stmt1;
321 SELECT * FROM t1;
322 c1
323
324 x
325 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
326 SELECT COUNT(c1) AS total_rows FROM t1;
327 total_rows
328 3
329 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
330 null_rows
331 0
332 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
333 not_null_rows
334 3
335 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
336 SET @a='';
337 EXECUTE stmt1 USING @a;
338 c1
339
340 SET @a='x';
341 EXECUTE stmt1 USING @a;
342 c1
343 x
344 DEALLOCATE PREPARE stmt1;
345 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
346 SET @a='';
347 SET @b='b';
348 EXECUTE stmt1 USING @a,@b;
349 SET @a='x';
350 SET @b='c';
351 EXECUTE stmt1 USING @a,@c;
352 DEALLOCATE PREPARE stmt1;
353 SELECT * FROM t1;
354 c1
355
356 x
357 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
358 SELECT COUNT(c1) AS total_rows FROM t1;
359 total_rows
360 3
361 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
362 null_rows
363 0
364 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
365 not_null_rows
366 3
367 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
368 SET @a='a';
369 EXECUTE stmt1 USING @a;
370 SET @a='b';
371 EXECUTE stmt1 USING @a;
372 SET @a='c';
373 EXECUTE stmt1 USING @a;
374 DEALLOCATE PREPARE stmt1;
375 SELECT * FROM t1;
376 c1
377
378 x
379 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
380 SELECT COUNT(c1) AS total_rows FROM t1;
381 total_rows
382 3
383 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
384 null_rows
385 0
386 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
387 not_null_rows
388 3
389 DROP TABLE t1;
390 CREATE TABLE t1(c1 TEXT(100) NOT NULL);
391 PREPARE stmt1 FROM 'INSERT INTO t1 (c1) VALUES(?)';
392 SET @a='';
393 EXECUTE stmt1 USING @a;
394 SET @a='x';
395 EXECUTE stmt1 USING @a;
396 SET @a='123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.';
397 EXECUTE stmt1 USING @a;
398 DEALLOCATE PREPARE stmt1;
399 SELECT * FROM t1;
400 c1
401
402 x
403 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
404 SELECT COUNT(c1) AS total_rows FROM t1;
405 total_rows
406 3
407 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
408 null_rows
409 0
410 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
411 not_null_rows
412 3
413 PREPARE stmt1 FROM 'SELECT * FROM t1 WHERE c1 = ?';
414 SET @a='';
415 EXECUTE stmt1 USING @a;
416 c1
417
418 SET @a='x';
419 EXECUTE stmt1 USING @a;
420 c1
421 x
422 DEALLOCATE PREPARE stmt1;
423 PREPARE stmt1 FROM 'UPDATE t1 SET c1 = ? WHERE c1 = ?';
424 SET @a='';
425 SET @b='b';
426 EXECUTE stmt1 USING @a,@b;
427 SET @a='x';
428 SET @b='c';
429 EXECUTE stmt1 USING @a,@c;
430 DEALLOCATE PREPARE stmt1;
431 SELECT * FROM t1;
432 c1
433
434 x
435 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
436 SELECT COUNT(c1) AS total_rows FROM t1;
437 total_rows
438 3
439 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
440 null_rows
441 0
442 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
443 not_null_rows
444 3
445 PREPARE stmt1 FROM 'DELETE FROM t1 WHERE c1 = ?';
446 SET @a='a';
447 EXECUTE stmt1 USING @a;
448 SET @a='b';
449 EXECUTE stmt1 USING @a;
450 SET @a='c';
451 EXECUTE stmt1 USING @a;
452 DEALLOCATE PREPARE stmt1;
453 SELECT * FROM t1;
454 c1
455
456 x
457 123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.
458 SELECT COUNT(c1) AS total_rows FROM t1;
459 total_rows
460 3
461 SELECT COUNT(c1) AS null_rows FROM t1 WHERE c1 IS NULL;
462 null_rows
463 0
464 SELECT COUNT(c1) AS not_null_rows FROM t1 WHERE c1 IS NOT NULL;
465 not_null_rows
466 3
467 DROP TABLE t1;