Debian Codegraph @

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

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