Debian Codegraph @

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

raw
1 --- suite/storage_engine/trx/level_serializable.result
2 +++ suite/storage_engine/trx/level_serializable.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 SERIALIZABLE;
13 @@ -11,45 +17,86 @@
14 connection con2;
15 BEGIN;
16 INSERT INTO t1 (a) VALUES(1);
17 -ERROR HY000: Lock wait timeout exceeded; try restarting transaction
18 -# WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
19 +# WARNING: Statement ended with errno 0, errname ''.
20 # If it differs from the result file, it might indicate a problem.
21 connection con1;
22 SELECT a FROM t1;
23 a
24 +1
25 connection con2;
26 INSERT INTO t1 (a) VALUES (2);
27 -ERROR HY000: Lock wait timeout exceeded; try restarting transaction
28 -# WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
29 +# WARNING: Statement ended with errno 0, errname ''.
30 # If it differs from the result file, it might indicate a problem.
31 connection con1;
32 SELECT a FROM t1;
33 a
34 +1
35 +2
36 INSERT INTO t1 (a) SELECT a+100 FROM t1;
37 # WARNING: Statement ended with errno 0, errname ''.
38 # If it differs from the result file, it might indicate a problem.
39 SELECT a FROM t1;
40 a
41 +1
42 +101
43 +102
44 +2
45 connection con2;
46 SELECT a FROM t1;
47 a
48 +1
49 +101
50 +102
51 +2
52 COMMIT;
53 SELECT a FROM t1;
54 a
55 +1
56 +101
57 +102
58 +2
59 connection con1;
60 SELECT a FROM t1;
61 a
62 +1
63 +101
64 +102
65 +2
66 INSERT INTO t1 (a) SELECT a+200 FROM t1;
67 # WARNING: Statement ended with errno 0, errname ''.
68 # If it differs from the result file, it might indicate a problem.
69 SELECT a FROM t1;
70 a
71 +1
72 +101
73 +102
74 +2
75 +201
76 +202
77 +301
78 +302
79 COMMIT;
80 SELECT a FROM t1;
81 a
82 +1
83 +101
84 +102
85 +2
86 +201
87 +202
88 +301
89 +302
90 connection con2;
91 SELECT a FROM t1;
92 a
93 +1
94 +101
95 +102
96 +2
97 +201
98 +202
99 +301
100 +302
101 connection default;
102 disconnect con1;
103 disconnect con2;