1CREATE TABLE worklog5743 (col_1_CHAR CHAR(255) , col_2_CHAR CHAR(255) ,
2PRIMARY KEY (col_1_CHAR)) engine = innodb;
3INSERT INTO worklog5743 VALUES(repeat("a", 200) , repeat("o", 200));
4SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR  = repeat("o", 200) FROM
5worklog5743;
6col_1_CHAR = repeat("a", 200)	col_2_CHAR  = repeat("o", 200)
71	1
8"In connection 1"
9SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
10worklog5743;
11col_1_CHAR = repeat("a", 200)	col_2_CHAR = repeat("o", 200)
121	1
13SELECT COUNT(*) FROM worklog5743;
14COUNT(*)
151
16"In connection 2"
17START TRANSACTION;
18INSERT INTO worklog5743 VALUES(repeat("b", 200) , repeat("o", 200));
19UPDATE worklog5743 SET col_1_CHAR = repeat("d", 200) WHERE col_1_CHAR =
20repeat("a", 200) AND col_2_CHAR = repeat("o", 200);
21SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR  = repeat("o", 200) FROM
22worklog5743;
23col_1_CHAR = repeat("a", 200)	col_2_CHAR  = repeat("o", 200)
240	1
250	1
26"In connection 1"
27SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
28worklog5743;
29col_1_CHAR = repeat("b", 200)	col_2_CHAR = repeat("o", 200)
300	1
31START TRANSACTION;
32SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
33worklog5743;
34col_1_CHAR = repeat("a", 200)	col_2_CHAR = repeat("o", 200)
351	1
36SELECT COUNT(*) FROM worklog5743;
37COUNT(*)
381
39"In connection 2"
40COMMIT;
41SELECT sleep(5);
42sleep(5)
430
44"In connection 1"
45SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
46worklog5743;
47col_1_CHAR = repeat("b", 200)	col_2_CHAR = repeat("o", 200)
480	1
49SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
50worklog5743;
51col_1_CHAR = repeat("a", 200)	col_2_CHAR = repeat("o", 200)
521	1
53SELECT COUNT(*) FROM worklog5743;
54COUNT(*)
551
56COMMIT;
57DROP TABLE worklog5743;
58