Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
3 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
4 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
5 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
6 INSERT INTO t3 (c1) VALUES('a');
7 SELECT COUNT(c1) FROM t1;
8 COUNT(c1)
9 0
10 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
11 COUNT(c1)
12 0
13 REPLACE t1 VALUES ('a');
14 SELECT COUNT(c1) FROM t1;
15 COUNT(c1)
16 1
17 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
18 COUNT(c1)
19 1
20 DROP TABLE t1,t2,t3;
21 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
22 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
23 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
24 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
25 INSERT INTO t3 (c1) VALUES('a');
26 SELECT COUNT(c1) FROM t1;
27 COUNT(c1)
28 0
29 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
30 COUNT(c1)
31 0
32 REPLACE t1 VALUES ('a');
33 SELECT COUNT(c1) FROM t1;
34 COUNT(c1)
35 1
36 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
37 COUNT(c1)
38 1
39 DROP TABLE t1,t2,t3;
40 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
41 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
42 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
43 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
44 INSERT INTO t3 (c1) VALUES('a');
45 SELECT COUNT(c1) FROM t1;
46 COUNT(c1)
47 0
48 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
49 COUNT(c1)
50 0
51 REPLACE t1 VALUES ('a');
52 SELECT COUNT(c1) FROM t1;
53 COUNT(c1)
54 1
55 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
56 COUNT(c1)
57 0
58 DROP TABLE t1,t2,t3;
59 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
60 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
61 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
62 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
63 INSERT INTO t3 (c1) VALUES('a');
64 SELECT COUNT(c1) FROM t1;
65 COUNT(c1)
66 0
67 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
68 COUNT(c1)
69 0
70 REPLACE t1 VALUES ('a');
71 SELECT COUNT(c1) FROM t1;
72 COUNT(c1)
73 1
74 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
75 COUNT(c1)
76 1
77 DROP TABLE t1,t2,t3;
78 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
79 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
80 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
81 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
82 INSERT INTO t3 (c1) VALUES('a');
83 SELECT COUNT(c1) FROM t2;
84 COUNT(c1)
85 6
86 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
87 COUNT(c1)
88 1
89 REPLACE t2 VALUES ('a');
90 SELECT COUNT(c1) FROM t2;
91 COUNT(c1)
92 6
93 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
94 COUNT(c1)
95 1
96 DROP TABLE t1,t2,t3;
97 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
98 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
99 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
100 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
101 INSERT INTO t3 (c1) VALUES('a');
102 SELECT COUNT(c1) FROM t2;
103 COUNT(c1)
104 6
105 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
106 COUNT(c1)
107 1
108 REPLACE t2 VALUES ('a');
109 SELECT COUNT(c1) FROM t2;
110 COUNT(c1)
111 6
112 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
113 COUNT(c1)
114 1
115 DROP TABLE t1,t2,t3;
116 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
117 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
118 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
119 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
120 INSERT INTO t3 (c1) VALUES('a');
121 SELECT COUNT(c1) FROM t2;
122 COUNT(c1)
123 6
124 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
125 COUNT(c1)
126 0
127 REPLACE t2 VALUES ('a');
128 SELECT COUNT(c1) FROM t2;
129 COUNT(c1)
130 6
131 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
132 COUNT(c1)
133 0
134 DROP TABLE t1,t2,t3;
135 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
136 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
137 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
138 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
139 INSERT INTO t3 (c1) VALUES('a');
140 SELECT COUNT(c1) FROM t2;
141 COUNT(c1)
142 6
143 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
144 COUNT(c1)
145 1
146 REPLACE t2 VALUES ('a');
147 SELECT COUNT(c1) FROM t2;
148 COUNT(c1)
149 6
150 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
151 COUNT(c1)
152 1
153 DROP TABLE t1,t2,t3;
154 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
155 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
156 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
157 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
158 INSERT INTO t3 (c1) VALUES('a');
159 SELECT COUNT(c1) FROM t3;
160 COUNT(c1)
161 1
162 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
163 COUNT(c1)
164 1
165 REPLACE t3 VALUES ('a');
166 SELECT COUNT(c1) FROM t3;
167 COUNT(c1)
168 1
169 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
170 COUNT(c1)
171 1
172 DROP TABLE t1,t2,t3;
173 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
174 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
175 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
176 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
177 INSERT INTO t3 (c1) VALUES('a');
178 SELECT COUNT(c1) FROM t3;
179 COUNT(c1)
180 1
181 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
182 COUNT(c1)
183 1
184 REPLACE t3 VALUES ('a');
185 SELECT COUNT(c1) FROM t3;
186 COUNT(c1)
187 1
188 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
189 COUNT(c1)
190 1
191 DROP TABLE t1,t2,t3;
192 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
193 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
194 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
195 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
196 INSERT INTO t3 (c1) VALUES('a');
197 SELECT COUNT(c1) FROM t3;
198 COUNT(c1)
199 1
200 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
201 COUNT(c1)
202 0
203 REPLACE t3 VALUES ('a');
204 SELECT COUNT(c1) FROM t3;
205 COUNT(c1)
206 1
207 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
208 COUNT(c1)
209 0
210 DROP TABLE t1,t2,t3;
211 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
212 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
213 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
214 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
215 INSERT INTO t3 (c1) VALUES('a');
216 SELECT COUNT(c1) FROM t3;
217 COUNT(c1)
218 1
219 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
220 COUNT(c1)
221 1
222 REPLACE t3 VALUES ('a');
223 SELECT COUNT(c1) FROM t3;
224 COUNT(c1)
225 1
226 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
227 COUNT(c1)
228 1
229 DROP TABLE t1,t2,t3;
230 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
231 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
232 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
233 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
234 INSERT INTO t3 (c1) VALUES('a');
235 SELECT COUNT(c1) FROM t1;
236 COUNT(c1)
237 0
238 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
239 COUNT(c1)
240 0
241 REPLACE t1 VALUES ('a');
242 SELECT COUNT(c1) FROM t1;
243 COUNT(c1)
244 1
245 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
246 COUNT(c1)
247 0
248 DROP TABLE t1,t2,t3;
249 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
250 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
251 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
252 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
253 INSERT INTO t3 (c1) VALUES('a');
254 SELECT COUNT(c1) FROM t1;
255 COUNT(c1)
256 0
257 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
258 COUNT(c1)
259 0
260 REPLACE t1 VALUES ('a');
261 SELECT COUNT(c1) FROM t1;
262 COUNT(c1)
263 1
264 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
265 COUNT(c1)
266 0
267 DROP TABLE t1,t2,t3;
268 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
269 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
270 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
271 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
272 INSERT INTO t3 (c1) VALUES('a');
273 SELECT COUNT(c1) FROM t1;
274 COUNT(c1)
275 0
276 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
277 COUNT(c1)
278 0
279 REPLACE t1 VALUES ('a');
280 SELECT COUNT(c1) FROM t1;
281 COUNT(c1)
282 1
283 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
284 COUNT(c1)
285 0
286 DROP TABLE t1,t2,t3;
287 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
288 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
289 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
290 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
291 INSERT INTO t3 (c1) VALUES('a');
292 SELECT COUNT(c1) FROM t1;
293 COUNT(c1)
294 0
295 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
296 COUNT(c1)
297 0
298 REPLACE t1 VALUES ('a');
299 SELECT COUNT(c1) FROM t1;
300 COUNT(c1)
301 1
302 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
303 COUNT(c1)
304 0
305 DROP TABLE t1,t2,t3;
306 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
307 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
308 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
309 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
310 INSERT INTO t3 (c1) VALUES('a');
311 SELECT COUNT(c1) FROM t2;
312 COUNT(c1)
313 6
314 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
315 COUNT(c1)
316 1
317 REPLACE t2 VALUES ('a');
318 SELECT COUNT(c1) FROM t2;
319 COUNT(c1)
320 6
321 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
322 COUNT(c1)
323 1
324 DROP TABLE t1,t2,t3;
325 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
326 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
327 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
328 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
329 INSERT INTO t3 (c1) VALUES('a');
330 SELECT COUNT(c1) FROM t2;
331 COUNT(c1)
332 6
333 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
334 COUNT(c1)
335 1
336 REPLACE t2 VALUES ('a');
337 SELECT COUNT(c1) FROM t2;
338 COUNT(c1)
339 6
340 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
341 COUNT(c1)
342 1
343 DROP TABLE t1,t2,t3;
344 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
345 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
346 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
347 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
348 INSERT INTO t3 (c1) VALUES('a');
349 SELECT COUNT(c1) FROM t2;
350 COUNT(c1)
351 6
352 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
353 COUNT(c1)
354 0
355 REPLACE t2 VALUES ('a');
356 SELECT COUNT(c1) FROM t2;
357 COUNT(c1)
358 6
359 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
360 COUNT(c1)
361 0
362 DROP TABLE t1,t2,t3;
363 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
364 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
365 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
366 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
367 INSERT INTO t3 (c1) VALUES('a');
368 SELECT COUNT(c1) FROM t2;
369 COUNT(c1)
370 6
371 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
372 COUNT(c1)
373 1
374 REPLACE t2 VALUES ('a');
375 SELECT COUNT(c1) FROM t2;
376 COUNT(c1)
377 6
378 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
379 COUNT(c1)
380 1
381 DROP TABLE t1,t2,t3;
382 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
383 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
384 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
385 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
386 INSERT INTO t3 (c1) VALUES('a');
387 SELECT COUNT(c1) FROM t3;
388 COUNT(c1)
389 1
390 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
391 COUNT(c1)
392 0
393 REPLACE t3 VALUES ('a');
394 SELECT COUNT(c1) FROM t3;
395 COUNT(c1)
396 1
397 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
398 COUNT(c1)
399 0
400 DROP TABLE t1,t2,t3;
401 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
402 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
403 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
404 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
405 INSERT INTO t3 (c1) VALUES('a');
406 SELECT COUNT(c1) FROM t3;
407 COUNT(c1)
408 1
409 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
410 COUNT(c1)
411 0
412 REPLACE t3 VALUES ('a');
413 SELECT COUNT(c1) FROM t3;
414 COUNT(c1)
415 1
416 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
417 COUNT(c1)
418 0
419 DROP TABLE t1,t2,t3;
420 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
421 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
422 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
423 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
424 INSERT INTO t3 (c1) VALUES('a');
425 SELECT COUNT(c1) FROM t3;
426 COUNT(c1)
427 1
428 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
429 COUNT(c1)
430 0
431 REPLACE t3 VALUES ('a');
432 SELECT COUNT(c1) FROM t3;
433 COUNT(c1)
434 1
435 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
436 COUNT(c1)
437 0
438 DROP TABLE t1,t2,t3;
439 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
440 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
441 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
442 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
443 INSERT INTO t3 (c1) VALUES('a');
444 SELECT COUNT(c1) FROM t3;
445 COUNT(c1)
446 1
447 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
448 COUNT(c1)
449 0
450 REPLACE t3 VALUES ('a');
451 SELECT COUNT(c1) FROM t3;
452 COUNT(c1)
453 1
454 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
455 COUNT(c1)
456 0
457 DROP TABLE t1,t2,t3;
458 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
459 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
460 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
461 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
462 INSERT INTO t3 (c1) VALUES('a');
463 SELECT COUNT(c1) FROM t1;
464 COUNT(c1)
465 0
466 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
467 COUNT(c1)
468 0
469 REPLACE t1 VALUES ('a');
470 SELECT COUNT(c1) FROM t1;
471 COUNT(c1)
472 1
473 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
474 COUNT(c1)
475 0
476 DROP TABLE t1,t2,t3;
477 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
478 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
479 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
480 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
481 INSERT INTO t3 (c1) VALUES('a');
482 SELECT COUNT(c1) FROM t1;
483 COUNT(c1)
484 0
485 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
486 COUNT(c1)
487 0
488 REPLACE t1 VALUES ('a');
489 SELECT COUNT(c1) FROM t1;
490 COUNT(c1)
491 1
492 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
493 COUNT(c1)
494 0
495 DROP TABLE t1,t2,t3;
496 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
497 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
498 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
499 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
500 INSERT INTO t3 (c1) VALUES('a');
501 SELECT COUNT(c1) FROM t1;
502 COUNT(c1)
503 0
504 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
505 COUNT(c1)
506 0
507 REPLACE t1 VALUES ('a');
508 SELECT COUNT(c1) FROM t1;
509 COUNT(c1)
510 1
511 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
512 COUNT(c1)
513 0
514 DROP TABLE t1,t2,t3;
515 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
516 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
517 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
518 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
519 INSERT INTO t3 (c1) VALUES('a');
520 SELECT COUNT(c1) FROM t1;
521 COUNT(c1)
522 0
523 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
524 COUNT(c1)
525 0
526 REPLACE t1 VALUES ('a');
527 SELECT COUNT(c1) FROM t1;
528 COUNT(c1)
529 1
530 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
531 COUNT(c1)
532 0
533 DROP TABLE t1,t2,t3;
534 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
535 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
536 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
537 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
538 INSERT INTO t3 (c1) VALUES('a');
539 SELECT COUNT(c1) FROM t2;
540 COUNT(c1)
541 6
542 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
543 COUNT(c1)
544 1
545 REPLACE t2 VALUES ('a');
546 SELECT COUNT(c1) FROM t2;
547 COUNT(c1)
548 6
549 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
550 COUNT(c1)
551 1
552 DROP TABLE t1,t2,t3;
553 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
554 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
555 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
556 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
557 INSERT INTO t3 (c1) VALUES('a');
558 SELECT COUNT(c1) FROM t2;
559 COUNT(c1)
560 6
561 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
562 COUNT(c1)
563 1
564 REPLACE t2 VALUES ('a');
565 SELECT COUNT(c1) FROM t2;
566 COUNT(c1)
567 6
568 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
569 COUNT(c1)
570 1
571 DROP TABLE t1,t2,t3;
572 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
573 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
574 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
575 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
576 INSERT INTO t3 (c1) VALUES('a');
577 SELECT COUNT(c1) FROM t2;
578 COUNT(c1)
579 6
580 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
581 COUNT(c1)
582 0
583 REPLACE t2 VALUES ('a');
584 SELECT COUNT(c1) FROM t2;
585 COUNT(c1)
586 6
587 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
588 COUNT(c1)
589 0
590 DROP TABLE t1,t2,t3;
591 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
592 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
593 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
594 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
595 INSERT INTO t3 (c1) VALUES('a');
596 SELECT COUNT(c1) FROM t2;
597 COUNT(c1)
598 6
599 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
600 COUNT(c1)
601 1
602 REPLACE t2 VALUES ('a');
603 SELECT COUNT(c1) FROM t2;
604 COUNT(c1)
605 6
606 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
607 COUNT(c1)
608 1
609 DROP TABLE t1,t2,t3;
610 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
611 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
612 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
613 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
614 INSERT INTO t3 (c1) VALUES('a');
615 SELECT COUNT(c1) FROM t3;
616 COUNT(c1)
617 1
618 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
619 COUNT(c1)
620 0
621 REPLACE t3 VALUES ('a');
622 SELECT COUNT(c1) FROM t3;
623 COUNT(c1)
624 1
625 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
626 COUNT(c1)
627 0
628 DROP TABLE t1,t2,t3;
629 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
630 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
631 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
632 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
633 INSERT INTO t3 (c1) VALUES('a');
634 SELECT COUNT(c1) FROM t3;
635 COUNT(c1)
636 1
637 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
638 COUNT(c1)
639 0
640 REPLACE t3 VALUES ('a');
641 SELECT COUNT(c1) FROM t3;
642 COUNT(c1)
643 1
644 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
645 COUNT(c1)
646 0
647 DROP TABLE t1,t2,t3;
648 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
649 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
650 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
651 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
652 INSERT INTO t3 (c1) VALUES('a');
653 SELECT COUNT(c1) FROM t3;
654 COUNT(c1)
655 1
656 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
657 COUNT(c1)
658 0
659 REPLACE t3 VALUES ('a');
660 SELECT COUNT(c1) FROM t3;
661 COUNT(c1)
662 1
663 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
664 COUNT(c1)
665 0
666 DROP TABLE t1,t2,t3;
667 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
668 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
669 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
670 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
671 INSERT INTO t3 (c1) VALUES('a');
672 SELECT COUNT(c1) FROM t3;
673 COUNT(c1)
674 1
675 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
676 COUNT(c1)
677 0
678 REPLACE t3 VALUES ('a');
679 SELECT COUNT(c1) FROM t3;
680 COUNT(c1)
681 1
682 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
683 COUNT(c1)
684 0
685 DROP TABLE t1,t2,t3;
686 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
687 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
688 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
689 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
690 INSERT INTO t3 (c1) VALUES('a');
691 SELECT COUNT(c1) FROM t1;
692 COUNT(c1)
693 0
694 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
695 COUNT(c1)
696 0
697 REPLACE t1 VALUES ('a');
698 SELECT COUNT(c1) FROM t1;
699 COUNT(c1)
700 1
701 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
702 COUNT(c1)
703 0
704 DROP TABLE t1,t2,t3;
705 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
706 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
707 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
708 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
709 INSERT INTO t3 (c1) VALUES('a');
710 SELECT COUNT(c1) FROM t1;
711 COUNT(c1)
712 0
713 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
714 COUNT(c1)
715 0
716 REPLACE t1 VALUES ('a');
717 SELECT COUNT(c1) FROM t1;
718 COUNT(c1)
719 1
720 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
721 COUNT(c1)
722 0
723 DROP TABLE t1,t2,t3;
724 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
725 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
726 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
727 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
728 INSERT INTO t3 (c1) VALUES('a');
729 SELECT COUNT(c1) FROM t1;
730 COUNT(c1)
731 0
732 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
733 COUNT(c1)
734 0
735 REPLACE t1 VALUES ('a');
736 SELECT COUNT(c1) FROM t1;
737 COUNT(c1)
738 1
739 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
740 COUNT(c1)
741 0
742 DROP TABLE t1,t2,t3;
743 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
744 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
745 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
746 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
747 INSERT INTO t3 (c1) VALUES('a');
748 SELECT COUNT(c1) FROM t1;
749 COUNT(c1)
750 0
751 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
752 COUNT(c1)
753 0
754 REPLACE t1 VALUES ('a');
755 SELECT COUNT(c1) FROM t1;
756 COUNT(c1)
757 1
758 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
759 COUNT(c1)
760 0
761 DROP TABLE t1,t2,t3;
762 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
763 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
764 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
765 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
766 INSERT INTO t3 (c1) VALUES('a');
767 SELECT COUNT(c1) FROM t2;
768 COUNT(c1)
769 6
770 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
771 COUNT(c1)
772 0
773 REPLACE t2 VALUES ('a');
774 SELECT COUNT(c1) FROM t2;
775 COUNT(c1)
776 6
777 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
778 COUNT(c1)
779 0
780 DROP TABLE t1,t2,t3;
781 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
782 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
783 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
784 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
785 INSERT INTO t3 (c1) VALUES('a');
786 SELECT COUNT(c1) FROM t2;
787 COUNT(c1)
788 6
789 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
790 COUNT(c1)
791 0
792 REPLACE t2 VALUES ('a');
793 SELECT COUNT(c1) FROM t2;
794 COUNT(c1)
795 6
796 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
797 COUNT(c1)
798 0
799 DROP TABLE t1,t2,t3;
800 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
801 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
802 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
803 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
804 INSERT INTO t3 (c1) VALUES('a');
805 SELECT COUNT(c1) FROM t2;
806 COUNT(c1)
807 6
808 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
809 COUNT(c1)
810 0
811 REPLACE t2 VALUES ('a');
812 SELECT COUNT(c1) FROM t2;
813 COUNT(c1)
814 6
815 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
816 COUNT(c1)
817 0
818 DROP TABLE t1,t2,t3;
819 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
820 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
821 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
822 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
823 INSERT INTO t3 (c1) VALUES('a');
824 SELECT COUNT(c1) FROM t2;
825 COUNT(c1)
826 6
827 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
828 COUNT(c1)
829 0
830 REPLACE t2 VALUES ('a');
831 SELECT COUNT(c1) FROM t2;
832 COUNT(c1)
833 6
834 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
835 COUNT(c1)
836 0
837 DROP TABLE t1,t2,t3;
838 CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
839 CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
840 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
841 CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
842 INSERT INTO t3 (c1) VALUES('a');
843 SELECT COUNT(c1) FROM t3;
844 COUNT(c1)
845 1
846 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
847 COUNT(c1)
848 0
849 REPLACE t3 VALUES ('a');
850 SELECT COUNT(c1) FROM t3;
851 COUNT(c1)
852 1
853 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
854 COUNT(c1)
855 0
856 DROP TABLE t1,t2,t3;
857 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
858 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
859 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
860 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
861 INSERT INTO t3 (c1) VALUES('a');
862 SELECT COUNT(c1) FROM t3;
863 COUNT(c1)
864 1
865 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
866 COUNT(c1)
867 0
868 REPLACE t3 VALUES ('a');
869 SELECT COUNT(c1) FROM t3;
870 COUNT(c1)
871 1
872 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
873 COUNT(c1)
874 0
875 DROP TABLE t1,t2,t3;
876 CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
877 CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
878 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
879 CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
880 INSERT INTO t3 (c1) VALUES('a');
881 SELECT COUNT(c1) FROM t3;
882 COUNT(c1)
883 1
884 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
885 COUNT(c1)
886 0
887 REPLACE t3 VALUES ('a');
888 SELECT COUNT(c1) FROM t3;
889 COUNT(c1)
890 1
891 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
892 COUNT(c1)
893 0
894 DROP TABLE t1,t2,t3;
895 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
896 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
897 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
898 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
899 INSERT INTO t3 (c1) VALUES('a');
900 SELECT COUNT(c1) FROM t3;
901 COUNT(c1)
902 1
903 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
904 COUNT(c1)
905 0
906 REPLACE t3 VALUES ('a');
907 SELECT COUNT(c1) FROM t3;
908 COUNT(c1)
909 1
910 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
911 COUNT(c1)
912 0
913 DROP TABLE t1,t2,t3;