Debian Codegraph @

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

raw
1 set binlog_format=statement;
2 Warnings:
3 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
4 reset master;
5 create database testing_1;
6 use testing_1;
7 create table t1 (a int);
8 create function sf1 (a int) returns int return a+1;
9 create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
10 create procedure sp1 (a int) insert into t1 values(a);
11 drop database testing_1;
12 include/show_binlog_events.inc
13 Log_name Pos Event_type Server_id End_log_pos Info
14 binlog.000001 # Query # # create database testing_1
15 binlog.000001 # Query # # use `testing_1`; create table t1 (a int)
16 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int
17 return a+1
18 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
19 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
20 insert into t1 values(a)
21 binlog.000001 # Query # # drop database testing_1
22 use test;
23 reset master;
24 create temporary table tt1 (a int);
25 create table t1 (a int);
26 insert into t1 values (1);
27 drop database if exists mysqltest1;
28 insert into t1 values (1);
29 drop table tt1, t1;
30 include/show_binlog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 binlog.000001 # Query # # use `test`; create temporary table tt1 (a int)
33 binlog.000001 # Query # # use `test`; create table t1 (a int)
34 binlog.000001 # Query # # BEGIN
35 binlog.000001 # Query # # use `test`; insert into t1 values (1)
36 binlog.000001 # Query # # COMMIT
37 binlog.000001 # Query # # drop database if exists mysqltest1
38 binlog.000001 # Query # # BEGIN
39 binlog.000001 # Query # # use `test`; insert into t1 values (1)
40 binlog.000001 # Query # # COMMIT
41 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
42 binlog.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt1` /* generated by server */
43 FLUSH STATUS;
44 #
45 # Bug#11765416 58381: FAILED DROP DATABASE CAN BREAK STATEMENT
46 # BASED REPLICATION
47 #
48 USE test;
49 DROP DATABASE IF EXISTS db1;
50 DROP TABLE IF EXISTS t3;
51 CREATE DATABASE db1;
52 CREATE TABLE db1.t1 (a INT) engine=innodb;
53 CREATE TABLE db1.t2 (b INT, KEY(b)) engine=innodb;
54 RESET MASTER;
55 SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
56 DROP DATABASE db1;
57 ERROR HY000: Unknown error
58 SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
59 SHOW TABLES FROM db1;
60 Tables_in_db1
61 t1
62 t2
63 include/show_binlog_events.inc
64 Log_name Pos Event_type Server_id End_log_pos Info
65 DROP DATABASE db1;
66 RESET MASTER;
67 set binlog_format=mixed;
68 Warnings:
69 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
70 reset master;
71 create database testing_1;
72 use testing_1;
73 create table t1 (a int);
74 create function sf1 (a int) returns int return a+1;
75 create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
76 create procedure sp1 (a int) insert into t1 values(a);
77 drop database testing_1;
78 include/show_binlog_events.inc
79 Log_name Pos Event_type Server_id End_log_pos Info
80 binlog.000001 # Query # # create database testing_1
81 binlog.000001 # Query # # use `testing_1`; create table t1 (a int)
82 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int
83 return a+1
84 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
85 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
86 insert into t1 values(a)
87 binlog.000001 # Query # # drop database testing_1
88 use test;
89 reset master;
90 create temporary table tt1 (a int);
91 create table t1 (a int);
92 insert into t1 values (1);
93 drop database if exists mysqltest1;
94 insert into t1 values (1);
95 drop table tt1, t1;
96 include/show_binlog_events.inc
97 Log_name Pos Event_type Server_id End_log_pos Info
98 binlog.000001 # Query # # use `test`; create table t1 (a int)
99 binlog.000001 # Query # # BEGIN
100 binlog.000001 # Query # # use `test`; insert into t1 values (1)
101 binlog.000001 # Query # # COMMIT
102 binlog.000001 # Query # # drop database if exists mysqltest1
103 binlog.000001 # Query # # BEGIN
104 binlog.000001 # Query # # use `test`; insert into t1 values (1)
105 binlog.000001 # Query # # COMMIT
106 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
107 FLUSH STATUS;
108 #
109 # Bug#11765416 58381: FAILED DROP DATABASE CAN BREAK STATEMENT
110 # BASED REPLICATION
111 #
112 USE test;
113 DROP DATABASE IF EXISTS db1;
114 DROP TABLE IF EXISTS t3;
115 CREATE DATABASE db1;
116 CREATE TABLE db1.t1 (a INT) engine=innodb;
117 CREATE TABLE db1.t2 (b INT, KEY(b)) engine=innodb;
118 RESET MASTER;
119 SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
120 DROP DATABASE db1;
121 ERROR HY000: Unknown error
122 SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
123 SHOW TABLES FROM db1;
124 Tables_in_db1
125 t1
126 t2
127 include/show_binlog_events.inc
128 Log_name Pos Event_type Server_id End_log_pos Info
129 DROP DATABASE db1;
130 RESET MASTER;
131 set binlog_format='row';
132 Warnings:
133 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
134 reset master;
135 create database testing_1;
136 use testing_1;
137 create table t1 (a int);
138 create function sf1 (a int) returns int return a+1;
139 create trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a);
140 create procedure sp1 (a int) insert into t1 values(a);
141 drop database testing_1;
142 include/show_binlog_events.inc
143 Log_name Pos Event_type Server_id End_log_pos Info
144 binlog.000001 # Query # # create database testing_1
145 binlog.000001 # Query # # use `testing_1`; create table t1 (a int)
146 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` FUNCTION `sf1`(a int) RETURNS int
147 return a+1
148 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` trigger tr1 before insert on t1 for each row insert into t2 values (2*new.a)
149 binlog.000001 # Query # # use `testing_1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`(a int)
150 insert into t1 values(a)
151 binlog.000001 # Query # # drop database testing_1
152 use test;
153 reset master;
154 create temporary table tt1 (a int);
155 create table t1 (a int);
156 insert into t1 values (1);
157 drop database if exists mysqltest1;
158 insert into t1 values (1);
159 drop table tt1, t1;
160 include/show_binlog_events.inc
161 Log_name Pos Event_type Server_id End_log_pos Info
162 binlog.000001 # Query # # use `test`; create table t1 (a int)
163 binlog.000001 # Query # # BEGIN
164 binlog.000001 # Table_map # # table_id: # (test.t1)
165 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
166 binlog.000001 # Query # # COMMIT
167 binlog.000001 # Query # # drop database if exists mysqltest1
168 binlog.000001 # Query # # BEGIN
169 binlog.000001 # Table_map # # table_id: # (test.t1)
170 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
171 binlog.000001 # Query # # COMMIT
172 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
173 FLUSH STATUS;
174 #
175 # Bug#11765416 58381: FAILED DROP DATABASE CAN BREAK STATEMENT
176 # BASED REPLICATION
177 #
178 USE test;
179 DROP DATABASE IF EXISTS db1;
180 DROP TABLE IF EXISTS t3;
181 CREATE DATABASE db1;
182 CREATE TABLE db1.t1 (a INT) engine=innodb;
183 CREATE TABLE db1.t2 (b INT, KEY(b)) engine=innodb;
184 RESET MASTER;
185 SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
186 DROP DATABASE db1;
187 ERROR HY000: Unknown error
188 SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
189 SHOW TABLES FROM db1;
190 Tables_in_db1
191 t1
192 t2
193 include/show_binlog_events.inc
194 Log_name Pos Event_type Server_id End_log_pos Info
195 DROP DATABASE db1;
196 RESET MASTER;
197 show databases;
198 Database
199 information_schema
200 mtr
201 mysql
202 performance_schema
203 sys
204 test