Debian Codegraph @

mysql-test/suite/innodb/t/innodb-bug12552164.test

raw
1 --source include/count_sessions.inc
2
3 CREATE TABLE worklog5743 (col_1_CHAR CHAR(255) , col_2_CHAR CHAR(255) ,
4 PRIMARY KEY (col_1_CHAR)) engine = innodb STATS_PERSISTENT=0 charset latin1;
5 INSERT INTO worklog5743 VALUES(repeat("a", 200) , repeat("o", 200));
6 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
7 worklog5743;
8
9 --echo "In connection 1"
10 --connect (con1,localhost,root,,)
11 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
12 worklog5743;
13 SELECT COUNT(*) FROM worklog5743;
14
15 --echo "In connection 2"
16 --connect (con2,localhost,root,,)
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
24 --echo "In connection 1"
25 --connection con1
26 SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
27 worklog5743;
28
29 START TRANSACTION;
30
31 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
32 worklog5743;
33 SELECT COUNT(*) FROM worklog5743;
34
35 --echo "In connection 2"
36 --connection con2
37 COMMIT;
38 --source include/wait_innodb_all_purged.inc
39
40 --echo "In connection 1"
41 --connection con1
42 SELECT col_1_CHAR = repeat("b", 200) , col_2_CHAR = repeat("o", 200) FROM
43 worklog5743;
44 SELECT col_1_CHAR = repeat("a", 200) , col_2_CHAR = repeat("o", 200) FROM
45 worklog5743;
46 SELECT COUNT(*) FROM worklog5743;
47 COMMIT;
48
49 disconnect con1;
50 disconnect con2;
51
52 --connection default
53 DROP TABLE worklog5743;
54
55 --source include/wait_until_count_sessions.inc