Debian Codegraph @

mysql-test/suite/innodb/r/innodb-bug12552164.result

raw
1 CREATE TABLE worklog5743 (col_1_CHAR CHAR(255) , col_2_CHAR CHAR(255) ,
2 PRIMARY KEY (col_1_CHAR)) engine = innodb STATS_PERSISTENT=0 charset latin1;
3 INSERT INTO worklog5743 VALUES(repeat("a", 200) , repeat("o", 200));
4 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
5 worklog5743;
6 col_1_CHAR = repeat("a", 200) col_2_CHAR = repeat("o", 200)
7 1 1
8 "In connection 1"
9 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
10 worklog5743;
11 col_1_CHAR = repeat("a", 200) col_2_CHAR = repeat("o", 200)
12 1 1
13 SELECT COUNT(*) FROM worklog5743;
14 COUNT(*)
15 1
16 "In connection 2"
17 START TRANSACTION;
18 INSERT INTO worklog5743 VALUES(repeat("b", 200) , repeat("o", 200));
19 UPDATE worklog5743 SET col_1_CHAR = repeat("d", 200) WHERE col_1_CHAR =
20 repeat("a", 200) AND col_2_CHAR = repeat("o", 200);
21 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
22 worklog5743;
23 col_1_CHAR = repeat("a", 200) col_2_CHAR = repeat("o", 200)
24 0 1
25 0 1
26 "In connection 1"
27 SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
28 worklog5743;
29 col_1_CHAR = repeat("b", 200) col_2_CHAR = repeat("o", 200)
30 0 1
31 START TRANSACTION;
32 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
33 worklog5743;
34 col_1_CHAR = repeat("a", 200) col_2_CHAR = repeat("o", 200)
35 1 1
36 SELECT COUNT(*) FROM worklog5743;
37 COUNT(*)
38 1
39 "In connection 2"
40 COMMIT;
41 "In connection 1"
42 SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
43 worklog5743;
44 col_1_CHAR = repeat("b", 200) col_2_CHAR = repeat("o", 200)
45 0 1
46 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
47 worklog5743;
48 col_1_CHAR = repeat("a", 200) col_2_CHAR = repeat("o", 200)
49 1 1
50 SELECT COUNT(*) FROM worklog5743;
51 COUNT(*)
52 1
53 COMMIT;
54 DROP TABLE worklog5743;