Debian Codegraph @

mysql-test/suite/binlog/r/binlog_rewrite_order.result

raw
1 call mtr.add_suppression("WARNING: The option --database has been used. It may filter parts of transactions,");
2 RESET MASTER;
3 CREATE SCHEMA schemaa;
4 USE schemaa;
5 FLUSH LOGS;
6 CREATE TABLE test (id int);
7 CREATE TABLE tload (c1 TEXT);
8 SET SESSION BINLOG_FORMAT='STATEMENT';
9 Warnings:
10 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
11 INSERT INTO test (id) VALUES (1);
12 SET SESSION BINLOG_FORMAT='ROW';
13 Warnings:
14 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
15 INSERT INTO test (id) VALUES (2);
16 SET SESSION BINLOG_FORMAT=STATEMENT;
17 Warnings:
18 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
19 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE tload;
20 SET SESSION SQL_LOG_BIN=0;
21 CREATE DATABASE _other_;
22 USE _other_;
23 SET SESSION SQL_LOG_BIN=1;
24 CREATE TABLE t1 (a INT);
25 SET SESSION BINLOG_FORMAT='STATEMENT';
26 Warnings:
27 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
28 INSERT INTO t1 VALUES (1);
29 SET SESSION BINLOG_FORMAT='ROW';
30 Warnings:
31 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
32 INSERT INTO t1 VALUES (2);
33 SET SQL_LOG_BIN=0;
34 FLUSH LOGS;
35 CREATE SCHEMA db1;
36 RESET MASTER;
37 TRUNCATE _other_.t1;
38 include/diff_tables.inc [schemaa.test,db1.test]
39 include/diff_tables.inc [schemaa.tload,db1.tload]
40 TRUNCATE db1.test;
41 TRUNCATE db1.tload;
42 TRUNCATE _other_.t1;
43 RESET MASTER;
44 USE db1;
45 include/assert.inc [Zero records on db1.test]
46 include/assert.inc [There is NO data in 'tload' table]
47 TRUNCATE db1.test;
48 TRUNCATE db1.tload;
49 TRUNCATE _other_.t1;
50 RESET MASTER;
51 DROP TABLE db1.test;
52 DROP TABLE db1.tload;
53 DROP TABLE _other_.t1;
54 include/assert.inc [Verify that other database was not rewritten]
55 SET SQL_LOG_BIN=1;
56 SET BINLOG_FORMAT=MIXED;
57 Warnings:
58 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
59 DROP SCHEMA db1;
60 DROP SCHEMA schemaa;
61 DROP SCHEMA _other_;
62 RESET MASTER;
63 RESET MASTER;
64 CREATE SCHEMA schemaa;
65 USE schemaa;
66 FLUSH LOGS;
67 CREATE TABLE test (id int);
68 CREATE TABLE tload (c1 TEXT);
69 SET SESSION BINLOG_FORMAT='STATEMENT';
70 Warnings:
71 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
72 INSERT INTO test (id) VALUES (1);
73 SET SESSION BINLOG_FORMAT='ROW';
74 Warnings:
75 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
76 INSERT INTO test (id) VALUES (2);
77 SET SESSION BINLOG_FORMAT=STATEMENT;
78 Warnings:
79 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
80 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE tload;
81 SET SESSION SQL_LOG_BIN=0;
82 CREATE DATABASE _other_;
83 USE _other_;
84 SET SESSION SQL_LOG_BIN=1;
85 CREATE TABLE t1 (a INT);
86 SET SESSION BINLOG_FORMAT='STATEMENT';
87 Warnings:
88 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
89 INSERT INTO t1 VALUES (1);
90 SET SESSION BINLOG_FORMAT='ROW';
91 Warnings:
92 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
93 INSERT INTO t1 VALUES (2);
94 SET SQL_LOG_BIN=0;
95 FLUSH LOGS;
96 CREATE SCHEMA schemab;
97 RESET MASTER;
98 TRUNCATE _other_.t1;
99 include/diff_tables.inc [schemaa.test,schemab.test]
100 include/diff_tables.inc [schemaa.tload,schemab.tload]
101 TRUNCATE schemab.test;
102 TRUNCATE schemab.tload;
103 TRUNCATE _other_.t1;
104 RESET MASTER;
105 USE schemab;
106 include/assert.inc [Zero records on schemab.test]
107 include/assert.inc [There is NO data in 'tload' table]
108 TRUNCATE schemab.test;
109 TRUNCATE schemab.tload;
110 TRUNCATE _other_.t1;
111 RESET MASTER;
112 DROP TABLE schemab.test;
113 DROP TABLE schemab.tload;
114 DROP TABLE _other_.t1;
115 include/assert.inc [Verify that other database was not rewritten]
116 SET SQL_LOG_BIN=1;
117 SET BINLOG_FORMAT=MIXED;
118 Warnings:
119 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
120 DROP SCHEMA schemab;
121 DROP SCHEMA schemaa;
122 DROP SCHEMA _other_;
123 RESET MASTER;
124 RESET MASTER;
125 CREATE SCHEMA schemaa;
126 USE schemaa;
127 FLUSH LOGS;
128 CREATE TABLE test (id int);
129 CREATE TABLE tload (c1 TEXT);
130 SET SESSION BINLOG_FORMAT='STATEMENT';
131 Warnings:
132 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
133 INSERT INTO test (id) VALUES (1);
134 SET SESSION BINLOG_FORMAT='ROW';
135 Warnings:
136 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
137 INSERT INTO test (id) VALUES (2);
138 SET SESSION BINLOG_FORMAT=STATEMENT;
139 Warnings:
140 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
141 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE tload;
142 SET SESSION SQL_LOG_BIN=0;
143 CREATE DATABASE _other_;
144 USE _other_;
145 SET SESSION SQL_LOG_BIN=1;
146 CREATE TABLE t1 (a INT);
147 SET SESSION BINLOG_FORMAT='STATEMENT';
148 Warnings:
149 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
150 INSERT INTO t1 VALUES (1);
151 SET SESSION BINLOG_FORMAT='ROW';
152 Warnings:
153 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
154 INSERT INTO t1 VALUES (2);
155 SET SQL_LOG_BIN=0;
156 FLUSH LOGS;
157 CREATE SCHEMA my_new_fancy_and_very_long_schema_name;
158 RESET MASTER;
159 TRUNCATE _other_.t1;
160 include/diff_tables.inc [schemaa.test,my_new_fancy_and_very_long_schema_name.test]
161 include/diff_tables.inc [schemaa.tload,my_new_fancy_and_very_long_schema_name.tload]
162 TRUNCATE my_new_fancy_and_very_long_schema_name.test;
163 TRUNCATE my_new_fancy_and_very_long_schema_name.tload;
164 TRUNCATE _other_.t1;
165 RESET MASTER;
166 USE my_new_fancy_and_very_long_schema_name;
167 include/assert.inc [Zero records on my_new_fancy_and_very_long_schema_name.test]
168 include/assert.inc [There is NO data in 'tload' table]
169 TRUNCATE my_new_fancy_and_very_long_schema_name.test;
170 TRUNCATE my_new_fancy_and_very_long_schema_name.tload;
171 TRUNCATE _other_.t1;
172 RESET MASTER;
173 DROP TABLE my_new_fancy_and_very_long_schema_name.test;
174 DROP TABLE my_new_fancy_and_very_long_schema_name.tload;
175 DROP TABLE _other_.t1;
176 include/assert.inc [Verify that other database was not rewritten]
177 SET SQL_LOG_BIN=1;
178 SET BINLOG_FORMAT=MIXED;
179 Warnings:
180 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
181 DROP SCHEMA my_new_fancy_and_very_long_schema_name;
182 DROP SCHEMA schemaa;
183 DROP SCHEMA _other_;
184 RESET MASTER;
185 SET BINLOG_FORMAT=MIXED;
186 Warnings:
187 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.