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