Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_mts_logical_clock.result

raw
1 RESET MASTER;
2 CREATE TABLE t1 (a int) ENGINE= innodb;
3 include/include/assert_logical_timestamps.inc [0 1]
4 INSERT INTO t1 SET a=1;
5 include/include/assert_logical_timestamps.inc [1 2]
6 [connection one]
7 BEGIN;
8 INSERT INTO t1 SET a=1;
9 [connection two]
10 BEGIN;
11 INSERT INTO t1 SET a=2;
12 COMMIT;
13 [connection one]
14 INSERT INTO t1 SET a=1;
15 [connection two]
16 BEGIN;
17 INSERT INTO t1 SET a=2;
18 COMMIT;
19 include/include/assert_logical_timestamps.inc [3 4]
20 [connection one]
21 COMMIT;
22 include/include/assert_logical_timestamps.inc [3 5]
23 [connection one]
24 INSERT INTO t1 SET a=1;
25 [connection two]
26 INSERT INTO t1 SET a=2;
27 [connection one]
28 [connection two]
29 include/include/assert_logical_timestamps.inc [5 6;[56] 7]
30 [connection one]
31 RESET MASTER;
32 INSERT INTO t1 SET a=1;
33 [connection two]
34 BEGIN;
35 INSERT INTO t1 SET a=2;
36 [connection one]
37 BEGIN;
38 INSERT INTO t1 SET a=3;
39 [connection two]
40 COMMIT;
41 include/include/assert_logical_timestamps.inc [0 1;1 2]
42 FLUSH LOGS;
43 [connection one]
44 COMMIT;
45 include/include/assert_logical_timestamps.inc [0 1]
46 [connection one]
47 RESET MASTER;
48 INSERT INTO t1 SET a=1;
49 [connection two]
50 BEGIN;
51 INSERT INTO t1 SET a=2;
52 [connection one]
53 BEGIN;
54 INSERT INTO t1 SET a=3;
55 [connection three]
56 BEGIN;
57 INSERT INTO t1 SET a=4;
58 [connection two]
59 COMMIT;
60 include/include/assert_logical_timestamps.inc [0 1;1 2]
61 RESET MASTER;
62 [connection one]
63 COMMIT;
64 [connection three]
65 COMMIT;
66 include/include/assert_logical_timestamps.inc [0 1;0 2]
67 DROP TABLE t1;
68 CREATE TABLE t1 (a int) ENGINE= innodb;
69 CREATE TABLE tm (a int) ENGINE= MyISAM;
70 RESET MASTER;
71 CREATE TEMPORARY TABLE ttm1 (a INT) ENGINE=MyISAM;
72 CREATE TEMPORARY TABLE tti1 (a INT) ENGINE=Innodb;
73 *** The query is logged in four part.
74 DROP TABLE tm,t1,ttm1,tti1;
75 include/include/assert_logical_timestamps.inc [logical_timestamps=0 1;1 2;2 3;3 4;4 5;5 6 logical_timestamps_mix=0 1;1 2]
76 CALL mtr.add_suppression("Some non-transactional changed tables couldn't be rolled back");
77 CREATE TABLE t1 (a int) ENGINE= innodb;
78 CREATE TABLE tm (a int) ENGINE= MyISAM;
79 CREATE PROCEDURE p1 ()
80 BEGIN
81 START TRANSACTION;
82 INSERT INTO t1 SET a=1;
83 INSERT INTO tm SET a=2;
84 COMMIT;
85 START TRANSACTION;
86 INSERT INTO t1 SET a=1;
87 INSERT INTO tm SET a=2;
88 ROLLBACK;
89 END|
90 CREATE PROCEDURE p2 ()
91 BEGIN
92 START TRANSACTION;
93 INSERT INTO t1 SET a=1;
94 COMMIT;
95 START TRANSACTION;
96 INSERT INTO t1 SET a=2;
97 COMMIT;
98 START TRANSACTION;
99 INSERT INTO t1 SET a=3;
100 COMMIT;
101 END|
102 RESET MASTER;
103 START TRANSACTION;
104 INSERT INTO t1 SET a=1;
105 INSERT INTO tm SET a=2;
106 COMMIT;
107 include/include/assert_logical_timestamps.inc [0 1;1 2]
108 RESET MASTER;
109 START TRANSACTION;
110 INSERT INTO t1 SET a=1;
111 INSERT INTO tm SET a=2;
112 ROLLBACK;
113 Warnings:
114 Warning 1196 Some non-transactional changed tables couldn't be rolled back
115 include/include/assert_logical_timestamps.inc [0 1]
116 RESET MASTER;
117 CALL p1();
118 Warnings:
119 Warning 1196 Some non-transactional changed tables couldn't be rolled back
120 include/include/assert_logical_timestamps.inc [0 1;1 2;2 3]
121 RESET MASTER;
122 CALL p2();
123 include/include/assert_logical_timestamps.inc [0 1;1 2;2 3]
124 DROP PROCEDURE p1;
125 DROP PROCEDURE p2;
126 DROP TABLE tm,t1;