1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
set binlog_format=statement;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
# 'DROP TABLE IF EXISTS <deleted table>' are binlogged
# for each table in SEs not supporting atomic DDL which
# were dropped by failed 'DROP DATABASE'.
#
# Unlike test for bug#11765416/58381 this test uses MyISAM
# for t1. So failed DROP DATABASE will have side-effect even
# though removal of InnoDB tables is rolled back.
# DROP TABLE IF EXISTS is logged for MyISAM table in this case.
RESET MASTER;
CREATE DATABASE testing_1;
USE testing_1;
CREATE TABLE t1(c1 INT) ENGINE=MyISAM;
CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB;
#
# 'DROP DATABASE' will fail but will delete table t1.
#
SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
DROP DATABASE testing_1;
ERROR HY000: Unknown error
SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
binlog.000001 # Query # # CREATE DATABASE testing_1
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t1(c1 INT) ENGINE=MyISAM
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB
binlog.000001 # Query # # use `testing_1`; DROP TABLE IF EXISTS `t1` /* generated by server */
# Cleanup.
DROP DATABASE testing_1;
set binlog_format=mixed;
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
# 'DROP TABLE IF EXISTS <deleted table>' are binlogged
# for each table in SEs not supporting atomic DDL which
# were dropped by failed 'DROP DATABASE'.
#
# Unlike test for bug#11765416/58381 this test uses MyISAM
# for t1. So failed DROP DATABASE will have side-effect even
# though removal of InnoDB tables is rolled back.
# DROP TABLE IF EXISTS is logged for MyISAM table in this case.
RESET MASTER;
CREATE DATABASE testing_1;
USE testing_1;
CREATE TABLE t1(c1 INT) ENGINE=MyISAM;
CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB;
#
# 'DROP DATABASE' will fail but will delete table t1.
#
SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
DROP DATABASE testing_1;
ERROR HY000: Unknown error
SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
binlog.000001 # Query # # CREATE DATABASE testing_1
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t1(c1 INT) ENGINE=MyISAM
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB
binlog.000001 # Query # # use `testing_1`; DROP TABLE IF EXISTS `t1` /* generated by server */
# Cleanup.
DROP DATABASE testing_1;
set binlog_format='row';
Warnings:
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
# 'DROP TABLE IF EXISTS <deleted table>' are binlogged
# for each table in SEs not supporting atomic DDL which
# were dropped by failed 'DROP DATABASE'.
#
# Unlike test for bug#11765416/58381 this test uses MyISAM
# for t1. So failed DROP DATABASE will have side-effect even
# though removal of InnoDB tables is rolled back.
# DROP TABLE IF EXISTS is logged for MyISAM table in this case.
RESET MASTER;
CREATE DATABASE testing_1;
USE testing_1;
CREATE TABLE t1(c1 INT) ENGINE=MyISAM;
CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB;
#
# 'DROP DATABASE' will fail but will delete table t1.
#
SET SESSION DEBUG='+d,rm_table_no_locks_abort_after_atomic_tables';
DROP DATABASE testing_1;
ERROR HY000: Unknown error
SET SESSION DEBUG='-d,rm_table_no_locks_abort_after_atomic_tables';
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
binlog.000001 # Query # # CREATE DATABASE testing_1
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t1(c1 INT) ENGINE=MyISAM
binlog.000001 # Query # # use `testing_1`; CREATE TABLE t2(c1 INT PRIMARY KEY) ENGINE=InnoDB
binlog.000001 # Query # # use `testing_1`; DROP TABLE IF EXISTS `t1` /* generated by server */
# Cleanup.
DROP DATABASE testing_1;
show databases;
Database
information_schema
mtr
mysql
performance_schema
sys
test
|
