Debian Codegraph @

storage/myisam/mysql-test/storage_engine/trx/level_repeatable_read.rdiff

raw
1 --- suite/storage_engine/trx/level_repeatable_read.result
2 +++ suite/storage_engine/trx/level_repeatable_read.reject
3 @@ -1,3 +1,9 @@
4 +# -- WARNING ----------------------------------------------------------------
5 +# According to I_S.ENGINES, MyISAM does not support transactions.
6 +# If it is true, the test will most likely fail; you can
7 +# either create an rdiff file, or add the test to disabled.def.
8 +# If transactions should be supported, check the data in Information Schema.
9 +# ---------------------------------------------------------------------------
10 DROP TABLE IF EXISTS t1;
11 connect con1,localhost,root,,;
12 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
13 @@ -16,6 +22,7 @@
14 connection con1;
15 SELECT a FROM t1;
16 a
17 +1
18 connection con2;
19 INSERT INTO t1 (a) VALUES (2);
20 # WARNING: Statement ended with errno 0, errname ''.
21 @@ -23,46 +30,73 @@
22 connection con1;
23 SELECT a FROM t1;
24 a
25 +1
26 +2
27 INSERT INTO t1 (a) SELECT a+100 FROM t1;
28 -ERROR HY000: Lock wait timeout exceeded; try restarting transaction
29 -# WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
30 +# WARNING: Statement ended with errno 0, errname ''.
31 # If it differs from the result file, it might indicate a problem.
32 SELECT a FROM t1;
33 a
34 +1
35 +101
36 +102
37 +2
38 connection con2;
39 SELECT a FROM t1;
40 a
41 1
42 +101
43 +102
44 2
45 COMMIT;
46 SELECT a FROM t1;
47 a
48 1
49 +101
50 +102
51 2
52 connection con1;
53 SELECT a FROM t1;
54 a
55 +1
56 +101
57 +102
58 +2
59 INSERT INTO t1 (a) SELECT a+200 FROM t1;
60 # WARNING: Statement ended with errno 0, errname ''.
61 # If it differs from the result file, it might indicate a problem.
62 SELECT a FROM t1;
63 a
64 +1
65 +101
66 +102
67 +2
68 201
69 202
70 +301
71 +302
72 COMMIT;
73 SELECT a FROM t1;
74 a
75 1
76 +101
77 +102
78 2
79 201
80 202
81 +301
82 +302
83 connection con2;
84 SELECT a FROM t1;
85 a
86 1
87 +101
88 +102
89 2
90 201
91 202
92 +301
93 +302
94 connection default;
95 disconnect con1;
96 disconnect con2;