| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
######################################################################### |
| 7 |
# CONFIGURATION |
| 8 |
######################################################################### |
| 9 |
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT."); |
| 10 |
SET @commands= 'configure'; |
| 11 |
CREATE TABLE tt_xx_1 ( id INT ) ENGINE = Innodb; |
| 12 |
CREATE TABLE nt_xx_1 ( id INT ) ENGINE = MyIsam; |
| 13 |
CREATE TABLE tt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb; |
| 14 |
CREATE TABLE nt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam; |
| 15 |
CREATE TABLE tt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb; |
| 16 |
CREATE TABLE nt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam; |
| 17 |
CREATE TRIGGER tr_i_nt_2_to_tt_2 AFTER INSERT ON nt_error_2 FOR EACH ROW |
| 18 |
BEGIN |
| 19 |
DECLARE in_stmt_id INTEGER; |
| 20 |
INSERT INTO tt_error_2(id) VALUES (NEW.id); |
| 21 |
END| |
| 22 |
CREATE TEMPORARY TABLE nt_tmp_xx_1 ( id INT ) ENGINE = MyIsam; |
| 23 |
CREATE TEMPORARY TABLE tt_tmp_xx_1 ( id INT ) ENGINE = Innodb; |
| 24 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2; |
| 25 |
Warnings: |
| 26 |
Note 1051 Unknown table 'test.nt_tmp_2' |
| 27 |
CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) ENGINE = MyIsam; |
| 28 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_1; |
| 29 |
Warnings: |
| 30 |
Note 1051 Unknown table 'test.nt_tmp_1' |
| 31 |
CREATE TEMPORARY TABLE nt_tmp_1 ( id INT ) ENGINE = MyIsam; |
| 32 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2; |
| 33 |
Warnings: |
| 34 |
Note 1051 Unknown table 'test.tt_tmp_2' |
| 35 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) ENGINE = Innodb; |
| 36 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_1; |
| 37 |
Warnings: |
| 38 |
Note 1051 Unknown table 'test.tt_tmp_1' |
| 39 |
CREATE TEMPORARY TABLE tt_tmp_1 ( id INT ) ENGINE = Innodb; |
| 40 |
DROP TABLE IF EXISTS nt_2; |
| 41 |
Warnings: |
| 42 |
Note 1051 Unknown table 'test.nt_2' |
| 43 |
CREATE TABLE nt_2 ( id INT ) ENGINE = MyIsam; |
| 44 |
DROP TABLE IF EXISTS nt_1; |
| 45 |
Warnings: |
| 46 |
Note 1051 Unknown table 'test.nt_1' |
| 47 |
CREATE TABLE nt_1 ( id INT ) ENGINE = MyIsam; |
| 48 |
DROP TABLE IF EXISTS tt_2; |
| 49 |
Warnings: |
| 50 |
Note 1051 Unknown table 'test.tt_2' |
| 51 |
CREATE TABLE tt_2 ( id INT ) ENGINE = Innodb; |
| 52 |
DROP TABLE IF EXISTS tt_1; |
| 53 |
Warnings: |
| 54 |
Note 1051 Unknown table 'test.tt_1' |
| 55 |
CREATE TABLE tt_1 ( id INT ) ENGINE = Innodb; |
| 56 |
SET @commands= ''; |
| 57 |
######################################################################### |
| 58 |
# 1 - Tables dropped by "DROP TEMPORARY TABLE" |
| 59 |
######################################################################### |
| 60 |
|
| 61 |
# |
| 62 |
#1) Generates in the binlog what follows: |
| 63 |
# |
| 64 |
SET @commands= 'Drop-Temp-T-Temp'; |
| 65 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 66 |
-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b- |
| 67 |
include/show_binlog_events.inc |
| 68 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 69 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 70 |
-e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- |
| 71 |
|
| 72 |
SET @commands= 'Drop-Temp-N-Temp'; |
| 73 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 74 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-N-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 75 |
include/show_binlog_events.inc |
| 76 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 77 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 78 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-N-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 79 |
|
| 80 |
SET @commands= 'Drop-Temp-Xe-Temp'; |
| 81 |
DROP TEMPORARY TABLE tt_xx_1; |
| 82 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 83 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-Xe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 84 |
include/show_binlog_events.inc |
| 85 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-Xe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 86 |
|
| 87 |
SET @commands= 'Drop-Temp-If-Xe-Temp'; |
| 88 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 89 |
Warnings: |
| 90 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 91 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-Xe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 92 |
include/show_binlog_events.inc |
| 93 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-Xe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 94 |
|
| 95 |
SET @commands= 'Drop-Temp-TXe-Temp'; |
| 96 |
DROP TEMPORARY TABLE tt_tmp_2, tt_1; |
| 97 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 98 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TXe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 99 |
include/show_binlog_events.inc |
| 100 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TXe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 101 |
|
| 102 |
SET @commands= 'Drop-Temp-If-TXe-Temp'; |
| 103 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1; |
| 104 |
Warnings: |
| 105 |
Note 1051 Unknown table 'test.tt_1' |
| 106 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-TXe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 107 |
include/show_binlog_events.inc |
| 108 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 109 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ |
| 110 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-TXe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 111 |
|
| 112 |
SET @commands= 'Drop-Temp-NXe-Temp'; |
| 113 |
DROP TEMPORARY TABLE nt_tmp_2, tt_1; |
| 114 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 115 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-NXe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 116 |
include/show_binlog_events.inc |
| 117 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-NXe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 118 |
|
| 119 |
SET @commands= 'Drop-Temp-If-NXe-Temp'; |
| 120 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1; |
| 121 |
Warnings: |
| 122 |
Note 1051 Unknown table 'test.tt_1' |
| 123 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-NXe-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 124 |
include/show_binlog_events.inc |
| 125 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 126 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ |
| 127 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-NXe-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 128 |
|
| 129 |
SET @commands= 'Drop-Temp-TN-Temp'; |
| 130 |
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; |
| 131 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 132 |
include/show_binlog_events.inc |
| 133 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 134 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 135 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 136 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 137 |
|
| 138 |
SET @commands= 'Drop-Temp-TT-Temp'; |
| 139 |
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; |
| 140 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TT-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 141 |
include/show_binlog_events.inc |
| 142 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 143 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */ |
| 144 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TT-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 145 |
|
| 146 |
SET @commands= 'Drop-Temp-NN-Temp'; |
| 147 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 148 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-NN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 149 |
include/show_binlog_events.inc |
| 150 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 151 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 152 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-NN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 153 |
|
| 154 |
|
| 155 |
# |
| 156 |
#2) Generates in the binlog what follows: |
| 157 |
# |
| 158 |
SET @commands= 'B T Drop-Temp-T-Temp C'; |
| 159 |
BEGIN; |
| 160 |
INSERT INTO tt_xx_1() VALUES (1); |
| 161 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 162 |
COMMIT; |
| 163 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 164 |
include/show_binlog_events.inc |
| 165 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 166 |
master-bin.000001 # Query # # BEGIN |
| 167 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 168 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 169 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 170 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 171 |
|
| 172 |
SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C'; |
| 173 |
BEGIN; |
| 174 |
INSERT INTO tt_xx_1() VALUES (1); |
| 175 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 176 |
INSERT INTO nt_xx_1() VALUES (1); |
| 177 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 178 |
COMMIT; |
| 179 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 180 |
include/show_binlog_events.inc |
| 181 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 182 |
master-bin.000001 # Query # # BEGIN |
| 183 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 184 |
master-bin.000001 # Query # # COMMIT |
| 185 |
master-bin.000001 # Query # # BEGIN |
| 186 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 187 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 188 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 189 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 190 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 191 |
|
| 192 |
SET @commands= 'B T Drop-Temp-N-Temp C'; |
| 193 |
BEGIN; |
| 194 |
INSERT INTO tt_xx_1() VALUES (1); |
| 195 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 196 |
COMMIT; |
| 197 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 198 |
include/show_binlog_events.inc |
| 199 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 200 |
master-bin.000001 # Query # # BEGIN |
| 201 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 202 |
master-bin.000001 # Query # # COMMIT |
| 203 |
master-bin.000001 # Query # # BEGIN |
| 204 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 205 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 206 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 207 |
|
| 208 |
SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C'; |
| 209 |
BEGIN; |
| 210 |
INSERT INTO tt_xx_1() VALUES (1); |
| 211 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 212 |
INSERT INTO nt_xx_1() VALUES (1); |
| 213 |
DROP TEMPORARY TABLE nt_tmp_1; |
| 214 |
COMMIT; |
| 215 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 216 |
include/show_binlog_events.inc |
| 217 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 218 |
master-bin.000001 # Query # # BEGIN |
| 219 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 220 |
master-bin.000001 # Query # # COMMIT |
| 221 |
master-bin.000001 # Query # # BEGIN |
| 222 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 223 |
master-bin.000001 # Query # # COMMIT |
| 224 |
master-bin.000001 # Query # # BEGIN |
| 225 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 226 |
master-bin.000001 # Query # # COMMIT |
| 227 |
master-bin.000001 # Query # # BEGIN |
| 228 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 229 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 230 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 231 |
|
| 232 |
SET @commands= 'B T Drop-Temp-Xe-Temp C'; |
| 233 |
BEGIN; |
| 234 |
INSERT INTO tt_xx_1() VALUES (1); |
| 235 |
DROP TEMPORARY TABLE tt_xx_1; |
| 236 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 237 |
COMMIT; |
| 238 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 239 |
include/show_binlog_events.inc |
| 240 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 241 |
master-bin.000001 # Query # # BEGIN |
| 242 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 243 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 244 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 245 |
|
| 246 |
SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C'; |
| 247 |
BEGIN; |
| 248 |
INSERT INTO tt_xx_1() VALUES (1); |
| 249 |
DROP TEMPORARY TABLE tt_xx_1; |
| 250 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 251 |
INSERT INTO nt_xx_1() VALUES (1); |
| 252 |
DROP TEMPORARY TABLE tt_xx_1; |
| 253 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 254 |
COMMIT; |
| 255 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 256 |
include/show_binlog_events.inc |
| 257 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 258 |
master-bin.000001 # Query # # BEGIN |
| 259 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 260 |
master-bin.000001 # Query # # COMMIT |
| 261 |
master-bin.000001 # Query # # BEGIN |
| 262 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 263 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 264 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 265 |
|
| 266 |
SET @commands= 'B T Drop-Temp-If-Xe-Temp C'; |
| 267 |
BEGIN; |
| 268 |
INSERT INTO tt_xx_1() VALUES (1); |
| 269 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 270 |
Warnings: |
| 271 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 272 |
COMMIT; |
| 273 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 274 |
include/show_binlog_events.inc |
| 275 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 276 |
master-bin.000001 # Query # # BEGIN |
| 277 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 278 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 279 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 280 |
|
| 281 |
SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C'; |
| 282 |
BEGIN; |
| 283 |
INSERT INTO tt_xx_1() VALUES (1); |
| 284 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 285 |
Warnings: |
| 286 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 287 |
INSERT INTO nt_xx_1() VALUES (1); |
| 288 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 289 |
Warnings: |
| 290 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 291 |
COMMIT; |
| 292 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 293 |
include/show_binlog_events.inc |
| 294 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 295 |
master-bin.000001 # Query # # BEGIN |
| 296 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 297 |
master-bin.000001 # Query # # COMMIT |
| 298 |
master-bin.000001 # Query # # BEGIN |
| 299 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 300 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 301 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 302 |
|
| 303 |
SET @commands= 'B T Drop-Temp-TXe-Temp C'; |
| 304 |
BEGIN; |
| 305 |
INSERT INTO tt_xx_1() VALUES (1); |
| 306 |
DROP TEMPORARY TABLE tt_tmp_2, tt_1; |
| 307 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 308 |
COMMIT; |
| 309 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 310 |
include/show_binlog_events.inc |
| 311 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 312 |
master-bin.000001 # Query # # BEGIN |
| 313 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 314 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 315 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 316 |
|
| 317 |
SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C'; |
| 318 |
BEGIN; |
| 319 |
INSERT INTO tt_xx_1() VALUES (1); |
| 320 |
DROP TEMPORARY TABLE tt_tmp_2, tt_1; |
| 321 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 322 |
INSERT INTO nt_xx_1() VALUES (1); |
| 323 |
DROP TEMPORARY TABLE tt_tmp_1, tt_1; |
| 324 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 325 |
COMMIT; |
| 326 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 327 |
include/show_binlog_events.inc |
| 328 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 329 |
master-bin.000001 # Query # # BEGIN |
| 330 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 331 |
master-bin.000001 # Query # # COMMIT |
| 332 |
master-bin.000001 # Query # # BEGIN |
| 333 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 334 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 335 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 336 |
|
| 337 |
SET @commands= 'B T Drop-Temp-If-TXe-Temp C'; |
| 338 |
BEGIN; |
| 339 |
INSERT INTO tt_xx_1() VALUES (1); |
| 340 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1; |
| 341 |
Warnings: |
| 342 |
Note 1051 Unknown table 'test.tt_1' |
| 343 |
COMMIT; |
| 344 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 345 |
include/show_binlog_events.inc |
| 346 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 347 |
master-bin.000001 # Query # # BEGIN |
| 348 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 349 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ |
| 350 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 351 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 352 |
|
| 353 |
SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C'; |
| 354 |
BEGIN; |
| 355 |
INSERT INTO tt_xx_1() VALUES (1); |
| 356 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1; |
| 357 |
Warnings: |
| 358 |
Note 1051 Unknown table 'test.tt_1' |
| 359 |
INSERT INTO nt_xx_1() VALUES (1); |
| 360 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1; |
| 361 |
Warnings: |
| 362 |
Note 1051 Unknown table 'test.tt_1' |
| 363 |
COMMIT; |
| 364 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 365 |
include/show_binlog_events.inc |
| 366 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 367 |
master-bin.000001 # Query # # BEGIN |
| 368 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 369 |
master-bin.000001 # Query # # COMMIT |
| 370 |
master-bin.000001 # Query # # BEGIN |
| 371 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 372 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ |
| 373 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ |
| 374 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 375 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 376 |
|
| 377 |
SET @commands= 'B T Drop-Temp-NXe-Temp C'; |
| 378 |
BEGIN; |
| 379 |
INSERT INTO tt_xx_1() VALUES (1); |
| 380 |
DROP TEMPORARY TABLE nt_tmp_2, tt_1; |
| 381 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 382 |
COMMIT; |
| 383 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 384 |
include/show_binlog_events.inc |
| 385 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 386 |
master-bin.000001 # Query # # BEGIN |
| 387 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 388 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 389 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 390 |
|
| 391 |
SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C'; |
| 392 |
BEGIN; |
| 393 |
INSERT INTO tt_xx_1() VALUES (1); |
| 394 |
DROP TEMPORARY TABLE nt_tmp_2, tt_1; |
| 395 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 396 |
INSERT INTO nt_xx_1() VALUES (1); |
| 397 |
DROP TEMPORARY TABLE nt_tmp_1, tt_1; |
| 398 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 399 |
COMMIT; |
| 400 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 401 |
include/show_binlog_events.inc |
| 402 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 403 |
master-bin.000001 # Query # # BEGIN |
| 404 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 405 |
master-bin.000001 # Query # # COMMIT |
| 406 |
master-bin.000001 # Query # # BEGIN |
| 407 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 408 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 409 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 410 |
|
| 411 |
SET @commands= 'B T Drop-Temp-If-NXe-Temp C'; |
| 412 |
BEGIN; |
| 413 |
INSERT INTO tt_xx_1() VALUES (1); |
| 414 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1; |
| 415 |
Warnings: |
| 416 |
Note 1051 Unknown table 'test.tt_1' |
| 417 |
COMMIT; |
| 418 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 419 |
include/show_binlog_events.inc |
| 420 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 421 |
master-bin.000001 # Query # # BEGIN |
| 422 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ |
| 423 |
master-bin.000001 # Query # # COMMIT |
| 424 |
master-bin.000001 # Query # # BEGIN |
| 425 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 426 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 427 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 428 |
|
| 429 |
SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C'; |
| 430 |
BEGIN; |
| 431 |
INSERT INTO tt_xx_1() VALUES (1); |
| 432 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1; |
| 433 |
Warnings: |
| 434 |
Note 1051 Unknown table 'test.tt_1' |
| 435 |
INSERT INTO nt_xx_1() VALUES (1); |
| 436 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1; |
| 437 |
Warnings: |
| 438 |
Note 1051 Unknown table 'test.tt_1' |
| 439 |
COMMIT; |
| 440 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 441 |
include/show_binlog_events.inc |
| 442 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 443 |
master-bin.000001 # Query # # BEGIN |
| 444 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ |
| 445 |
master-bin.000001 # Query # # COMMIT |
| 446 |
master-bin.000001 # Query # # BEGIN |
| 447 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 448 |
master-bin.000001 # Query # # COMMIT |
| 449 |
master-bin.000001 # Query # # BEGIN |
| 450 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ |
| 451 |
master-bin.000001 # Query # # COMMIT |
| 452 |
master-bin.000001 # Query # # BEGIN |
| 453 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 454 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 455 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 456 |
|
| 457 |
SET @commands= 'B T Drop-Temp-TN-Temp C'; |
| 458 |
BEGIN; |
| 459 |
INSERT INTO tt_xx_1() VALUES (1); |
| 460 |
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; |
| 461 |
COMMIT; |
| 462 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 463 |
include/show_binlog_events.inc |
| 464 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 465 |
master-bin.000001 # Query # # BEGIN |
| 466 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 467 |
master-bin.000001 # Query # # COMMIT |
| 468 |
master-bin.000001 # Query # # BEGIN |
| 469 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 470 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 471 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 472 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 473 |
|
| 474 |
SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C'; |
| 475 |
BEGIN; |
| 476 |
INSERT INTO tt_xx_1() VALUES (1); |
| 477 |
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; |
| 478 |
INSERT INTO nt_xx_1() VALUES (1); |
| 479 |
DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1; |
| 480 |
COMMIT; |
| 481 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 482 |
include/show_binlog_events.inc |
| 483 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 484 |
master-bin.000001 # Query # # BEGIN |
| 485 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 486 |
master-bin.000001 # Query # # COMMIT |
| 487 |
master-bin.000001 # Query # # BEGIN |
| 488 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 489 |
master-bin.000001 # Query # # COMMIT |
| 490 |
master-bin.000001 # Query # # BEGIN |
| 491 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 492 |
master-bin.000001 # Query # # COMMIT |
| 493 |
master-bin.000001 # Query # # BEGIN |
| 494 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 495 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 496 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 497 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 498 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 499 |
|
| 500 |
SET @commands= 'B T Drop-Temp-TT-Temp C'; |
| 501 |
BEGIN; |
| 502 |
INSERT INTO tt_xx_1() VALUES (1); |
| 503 |
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; |
| 504 |
COMMIT; |
| 505 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 506 |
include/show_binlog_events.inc |
| 507 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 508 |
master-bin.000001 # Query # # BEGIN |
| 509 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 510 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */ |
| 511 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 512 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 513 |
|
| 514 |
SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C'; |
| 515 |
BEGIN; |
| 516 |
INSERT INTO tt_xx_1() VALUES (1); |
| 517 |
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; |
| 518 |
INSERT INTO nt_xx_1() VALUES (1); |
| 519 |
COMMIT; |
| 520 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 521 |
include/show_binlog_events.inc |
| 522 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 523 |
master-bin.000001 # Query # # BEGIN |
| 524 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 525 |
master-bin.000001 # Query # # COMMIT |
| 526 |
master-bin.000001 # Query # # BEGIN |
| 527 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 528 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */ |
| 529 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 530 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 531 |
|
| 532 |
SET @commands= 'B T Drop-Temp-NN-Temp C'; |
| 533 |
BEGIN; |
| 534 |
INSERT INTO tt_xx_1() VALUES (1); |
| 535 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 536 |
COMMIT; |
| 537 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 538 |
include/show_binlog_events.inc |
| 539 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 540 |
master-bin.000001 # Query # # BEGIN |
| 541 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 542 |
master-bin.000001 # Query # # COMMIT |
| 543 |
master-bin.000001 # Query # # BEGIN |
| 544 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 545 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 546 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 547 |
|
| 548 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C'; |
| 549 |
BEGIN; |
| 550 |
INSERT INTO tt_xx_1() VALUES (1); |
| 551 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 552 |
INSERT INTO nt_xx_1() VALUES (1); |
| 553 |
COMMIT; |
| 554 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 555 |
include/show_binlog_events.inc |
| 556 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 557 |
master-bin.000001 # Query # # BEGIN |
| 558 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 559 |
master-bin.000001 # Query # # COMMIT |
| 560 |
master-bin.000001 # Query # # BEGIN |
| 561 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 562 |
master-bin.000001 # Query # # COMMIT |
| 563 |
master-bin.000001 # Query # # BEGIN |
| 564 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 565 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 566 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 567 |
|
| 568 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C'; |
| 569 |
BEGIN; |
| 570 |
INSERT INTO tt_xx_1() VALUES (1); |
| 571 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 572 |
INSERT INTO nt_xx_1() VALUES (1); |
| 573 |
INSERT INTO nt_error_1() VALUES (1), (1); |
| 574 |
ERROR 23000: Duplicate entry '1' for key 'nt_error_1.PRIMARY' |
| 575 |
COMMIT; |
| 576 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C << -b-b-b-b-b-b-b-b-b-b-b- |
| 577 |
include/show_binlog_events.inc |
| 578 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 579 |
master-bin.000001 # Query # # BEGIN |
| 580 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 581 |
master-bin.000001 # Query # # COMMIT |
| 582 |
master-bin.000001 # Query # # BEGIN |
| 583 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 584 |
master-bin.000001 # Query # # COMMIT |
| 585 |
master-bin.000001 # Query # # BEGIN |
| 586 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (1), (1) |
| 587 |
master-bin.000001 # Query # # COMMIT |
| 588 |
master-bin.000001 # Query # # BEGIN |
| 589 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 590 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 591 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C << -e-e-e-e-e-e-e-e-e-e-e- |
| 592 |
|
| 593 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C'; |
| 594 |
BEGIN; |
| 595 |
INSERT INTO tt_xx_1() VALUES (1); |
| 596 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 597 |
INSERT INTO nt_xx_1() VALUES (1); |
| 598 |
INSERT INTO tt_error_1() VALUES (1), (1); |
| 599 |
ERROR 23000: Duplicate entry '1' for key 'tt_error_1.PRIMARY' |
| 600 |
COMMIT; |
| 601 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b- |
| 602 |
include/show_binlog_events.inc |
| 603 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 604 |
master-bin.000001 # Query # # BEGIN |
| 605 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 606 |
master-bin.000001 # Query # # COMMIT |
| 607 |
master-bin.000001 # Query # # BEGIN |
| 608 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 609 |
master-bin.000001 # Query # # COMMIT |
| 610 |
master-bin.000001 # Query # # BEGIN |
| 611 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 612 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 613 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e- |
| 614 |
|
| 615 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C'; |
| 616 |
BEGIN; |
| 617 |
INSERT INTO tt_xx_1() VALUES (1); |
| 618 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 619 |
INSERT INTO nt_xx_1() VALUES (1); |
| 620 |
INSERT INTO nt_error_1() VALUES (2), (2); |
| 621 |
ERROR 23000: Duplicate entry '2' for key 'nt_error_1.PRIMARY' |
| 622 |
COMMIT; |
| 623 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b- |
| 624 |
include/show_binlog_events.inc |
| 625 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 626 |
master-bin.000001 # Query # # BEGIN |
| 627 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 628 |
master-bin.000001 # Query # # COMMIT |
| 629 |
master-bin.000001 # Query # # BEGIN |
| 630 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 631 |
master-bin.000001 # Query # # COMMIT |
| 632 |
master-bin.000001 # Query # # BEGIN |
| 633 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (2), (2) |
| 634 |
master-bin.000001 # Query # # COMMIT |
| 635 |
master-bin.000001 # Query # # BEGIN |
| 636 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 637 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 638 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e- |
| 639 |
|
| 640 |
|
| 641 |
# |
| 642 |
#3) Generates in the binlog what follows: |
| 643 |
# |
| 644 |
SET @commands= 'B T Drop-Temp-T-Temp R'; |
| 645 |
BEGIN; |
| 646 |
INSERT INTO tt_xx_1() VALUES (1); |
| 647 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 648 |
ROLLBACK; |
| 649 |
Warnings: |
| 650 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 651 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 652 |
include/show_binlog_events.inc |
| 653 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 654 |
master-bin.000001 # Query # # BEGIN |
| 655 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 656 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 657 |
master-bin.000001 # Query # # ROLLBACK |
| 658 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 659 |
|
| 660 |
SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R'; |
| 661 |
BEGIN; |
| 662 |
INSERT INTO tt_xx_1() VALUES (1); |
| 663 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 664 |
INSERT INTO nt_xx_1() VALUES (1); |
| 665 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 666 |
ROLLBACK; |
| 667 |
Warnings: |
| 668 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 669 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 670 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 671 |
include/show_binlog_events.inc |
| 672 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 673 |
master-bin.000001 # Query # # BEGIN |
| 674 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 675 |
master-bin.000001 # Query # # COMMIT |
| 676 |
master-bin.000001 # Query # # BEGIN |
| 677 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 678 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 679 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 680 |
master-bin.000001 # Query # # ROLLBACK |
| 681 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 682 |
|
| 683 |
SET @commands= 'B T Drop-Temp-N-Temp R'; |
| 684 |
BEGIN; |
| 685 |
INSERT INTO tt_xx_1() VALUES (1); |
| 686 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 687 |
ROLLBACK; |
| 688 |
Warnings: |
| 689 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 690 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 691 |
include/show_binlog_events.inc |
| 692 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 693 |
master-bin.000001 # Query # # BEGIN |
| 694 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 695 |
master-bin.000001 # Query # # COMMIT |
| 696 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 697 |
|
| 698 |
SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R'; |
| 699 |
BEGIN; |
| 700 |
INSERT INTO tt_xx_1() VALUES (1); |
| 701 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 702 |
INSERT INTO nt_xx_1() VALUES (1); |
| 703 |
DROP TEMPORARY TABLE nt_tmp_1; |
| 704 |
ROLLBACK; |
| 705 |
Warnings: |
| 706 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 707 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 708 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 709 |
include/show_binlog_events.inc |
| 710 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 711 |
master-bin.000001 # Query # # BEGIN |
| 712 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 713 |
master-bin.000001 # Query # # COMMIT |
| 714 |
master-bin.000001 # Query # # BEGIN |
| 715 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 716 |
master-bin.000001 # Query # # COMMIT |
| 717 |
master-bin.000001 # Query # # BEGIN |
| 718 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 719 |
master-bin.000001 # Query # # COMMIT |
| 720 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 721 |
|
| 722 |
SET @commands= 'B T Drop-Temp-Xe-Temp R'; |
| 723 |
BEGIN; |
| 724 |
INSERT INTO tt_xx_1() VALUES (1); |
| 725 |
DROP TEMPORARY TABLE tt_xx_1; |
| 726 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 727 |
ROLLBACK; |
| 728 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 729 |
include/show_binlog_events.inc |
| 730 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 731 |
|
| 732 |
SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R'; |
| 733 |
BEGIN; |
| 734 |
INSERT INTO tt_xx_1() VALUES (1); |
| 735 |
DROP TEMPORARY TABLE tt_xx_1; |
| 736 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 737 |
INSERT INTO nt_xx_1() VALUES (1); |
| 738 |
DROP TEMPORARY TABLE tt_xx_1; |
| 739 |
ERROR 42S02: Unknown table 'test.tt_xx_1' |
| 740 |
ROLLBACK; |
| 741 |
Warnings: |
| 742 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 743 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 744 |
include/show_binlog_events.inc |
| 745 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 746 |
master-bin.000001 # Query # # BEGIN |
| 747 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 748 |
master-bin.000001 # Query # # COMMIT |
| 749 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 750 |
|
| 751 |
SET @commands= 'B T Drop-Temp-If-Xe-Temp R'; |
| 752 |
BEGIN; |
| 753 |
INSERT INTO tt_xx_1() VALUES (1); |
| 754 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 755 |
Warnings: |
| 756 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 757 |
ROLLBACK; |
| 758 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 759 |
include/show_binlog_events.inc |
| 760 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 761 |
|
| 762 |
SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R'; |
| 763 |
BEGIN; |
| 764 |
INSERT INTO tt_xx_1() VALUES (1); |
| 765 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 766 |
Warnings: |
| 767 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 768 |
INSERT INTO nt_xx_1() VALUES (1); |
| 769 |
DROP TEMPORARY TABLE IF EXISTS tt_xx_1; |
| 770 |
Warnings: |
| 771 |
Note 1051 Unknown table 'test.tt_xx_1' |
| 772 |
ROLLBACK; |
| 773 |
Warnings: |
| 774 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 775 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 776 |
include/show_binlog_events.inc |
| 777 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 778 |
master-bin.000001 # Query # # BEGIN |
| 779 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 780 |
master-bin.000001 # Query # # COMMIT |
| 781 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 782 |
|
| 783 |
SET @commands= 'B T Drop-Temp-TXe-Temp R'; |
| 784 |
BEGIN; |
| 785 |
INSERT INTO tt_xx_1() VALUES (1); |
| 786 |
DROP TEMPORARY TABLE tt_tmp_2, tt_1; |
| 787 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 788 |
ROLLBACK; |
| 789 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 790 |
include/show_binlog_events.inc |
| 791 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 792 |
|
| 793 |
SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R'; |
| 794 |
BEGIN; |
| 795 |
INSERT INTO tt_xx_1() VALUES (1); |
| 796 |
DROP TEMPORARY TABLE tt_tmp_2, tt_1; |
| 797 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 798 |
INSERT INTO nt_xx_1() VALUES (1); |
| 799 |
DROP TEMPORARY TABLE tt_tmp_1, tt_1; |
| 800 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 801 |
ROLLBACK; |
| 802 |
Warnings: |
| 803 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 804 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 805 |
include/show_binlog_events.inc |
| 806 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 807 |
master-bin.000001 # Query # # BEGIN |
| 808 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 809 |
master-bin.000001 # Query # # COMMIT |
| 810 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 811 |
|
| 812 |
SET @commands= 'B T Drop-Temp-If-TXe-Temp R'; |
| 813 |
BEGIN; |
| 814 |
INSERT INTO tt_xx_1() VALUES (1); |
| 815 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1; |
| 816 |
Warnings: |
| 817 |
Note 1051 Unknown table 'test.tt_1' |
| 818 |
ROLLBACK; |
| 819 |
Warnings: |
| 820 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 821 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 822 |
include/show_binlog_events.inc |
| 823 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 824 |
master-bin.000001 # Query # # BEGIN |
| 825 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 826 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ |
| 827 |
master-bin.000001 # Query # # ROLLBACK |
| 828 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 829 |
|
| 830 |
SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R'; |
| 831 |
BEGIN; |
| 832 |
INSERT INTO tt_xx_1() VALUES (1); |
| 833 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1; |
| 834 |
Warnings: |
| 835 |
Note 1051 Unknown table 'test.tt_1' |
| 836 |
INSERT INTO nt_xx_1() VALUES (1); |
| 837 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1; |
| 838 |
Warnings: |
| 839 |
Note 1051 Unknown table 'test.tt_1' |
| 840 |
ROLLBACK; |
| 841 |
Warnings: |
| 842 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 843 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 844 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 845 |
include/show_binlog_events.inc |
| 846 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 847 |
master-bin.000001 # Query # # BEGIN |
| 848 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 849 |
master-bin.000001 # Query # # COMMIT |
| 850 |
master-bin.000001 # Query # # BEGIN |
| 851 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 852 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ |
| 853 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ |
| 854 |
master-bin.000001 # Query # # ROLLBACK |
| 855 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 856 |
|
| 857 |
SET @commands= 'B T Drop-Temp-NXe-Temp R'; |
| 858 |
BEGIN; |
| 859 |
INSERT INTO tt_xx_1() VALUES (1); |
| 860 |
DROP TEMPORARY TABLE nt_tmp_2, tt_1; |
| 861 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 862 |
ROLLBACK; |
| 863 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 864 |
include/show_binlog_events.inc |
| 865 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 866 |
|
| 867 |
SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R'; |
| 868 |
BEGIN; |
| 869 |
INSERT INTO tt_xx_1() VALUES (1); |
| 870 |
DROP TEMPORARY TABLE nt_tmp_2, tt_1; |
| 871 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 872 |
INSERT INTO nt_xx_1() VALUES (1); |
| 873 |
DROP TEMPORARY TABLE nt_tmp_1, tt_1; |
| 874 |
ERROR 42S02: Unknown table 'test.tt_1' |
| 875 |
ROLLBACK; |
| 876 |
Warnings: |
| 877 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 878 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 879 |
include/show_binlog_events.inc |
| 880 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 881 |
master-bin.000001 # Query # # BEGIN |
| 882 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 883 |
master-bin.000001 # Query # # COMMIT |
| 884 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 885 |
|
| 886 |
SET @commands= 'B T Drop-Temp-If-NXe-Temp R'; |
| 887 |
BEGIN; |
| 888 |
INSERT INTO tt_xx_1() VALUES (1); |
| 889 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1; |
| 890 |
Warnings: |
| 891 |
Note 1051 Unknown table 'test.tt_1' |
| 892 |
ROLLBACK; |
| 893 |
Warnings: |
| 894 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 895 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 896 |
include/show_binlog_events.inc |
| 897 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 898 |
master-bin.000001 # Query # # BEGIN |
| 899 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ |
| 900 |
master-bin.000001 # Query # # COMMIT |
| 901 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 902 |
|
| 903 |
SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R'; |
| 904 |
BEGIN; |
| 905 |
INSERT INTO tt_xx_1() VALUES (1); |
| 906 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1; |
| 907 |
Warnings: |
| 908 |
Note 1051 Unknown table 'test.tt_1' |
| 909 |
INSERT INTO nt_xx_1() VALUES (1); |
| 910 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1; |
| 911 |
Warnings: |
| 912 |
Note 1051 Unknown table 'test.tt_1' |
| 913 |
ROLLBACK; |
| 914 |
Warnings: |
| 915 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 916 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 917 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 918 |
include/show_binlog_events.inc |
| 919 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 920 |
master-bin.000001 # Query # # BEGIN |
| 921 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ |
| 922 |
master-bin.000001 # Query # # COMMIT |
| 923 |
master-bin.000001 # Query # # BEGIN |
| 924 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 925 |
master-bin.000001 # Query # # COMMIT |
| 926 |
master-bin.000001 # Query # # BEGIN |
| 927 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ |
| 928 |
master-bin.000001 # Query # # COMMIT |
| 929 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 930 |
|
| 931 |
SET @commands= 'B T Drop-Temp-TN-Temp R'; |
| 932 |
BEGIN; |
| 933 |
INSERT INTO tt_xx_1() VALUES (1); |
| 934 |
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; |
| 935 |
ROLLBACK; |
| 936 |
Warnings: |
| 937 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 938 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 939 |
include/show_binlog_events.inc |
| 940 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 941 |
master-bin.000001 # Query # # BEGIN |
| 942 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 943 |
master-bin.000001 # Query # # COMMIT |
| 944 |
master-bin.000001 # Query # # BEGIN |
| 945 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 946 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 947 |
master-bin.000001 # Query # # ROLLBACK |
| 948 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 949 |
|
| 950 |
SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R'; |
| 951 |
BEGIN; |
| 952 |
INSERT INTO tt_xx_1() VALUES (1); |
| 953 |
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; |
| 954 |
INSERT INTO nt_xx_1() VALUES (1); |
| 955 |
DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1; |
| 956 |
ROLLBACK; |
| 957 |
Warnings: |
| 958 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 959 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 960 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 961 |
include/show_binlog_events.inc |
| 962 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 963 |
master-bin.000001 # Query # # BEGIN |
| 964 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 965 |
master-bin.000001 # Query # # COMMIT |
| 966 |
master-bin.000001 # Query # # BEGIN |
| 967 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 968 |
master-bin.000001 # Query # # COMMIT |
| 969 |
master-bin.000001 # Query # # BEGIN |
| 970 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 971 |
master-bin.000001 # Query # # COMMIT |
| 972 |
master-bin.000001 # Query # # BEGIN |
| 973 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 974 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 975 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 976 |
master-bin.000001 # Query # # ROLLBACK |
| 977 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 978 |
|
| 979 |
SET @commands= 'B T Drop-Temp-TT-Temp R'; |
| 980 |
BEGIN; |
| 981 |
INSERT INTO tt_xx_1() VALUES (1); |
| 982 |
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; |
| 983 |
ROLLBACK; |
| 984 |
Warnings: |
| 985 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 986 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 987 |
include/show_binlog_events.inc |
| 988 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 989 |
master-bin.000001 # Query # # BEGIN |
| 990 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 991 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */ |
| 992 |
master-bin.000001 # Query # # ROLLBACK |
| 993 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 994 |
|
| 995 |
SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R'; |
| 996 |
BEGIN; |
| 997 |
INSERT INTO tt_xx_1() VALUES (1); |
| 998 |
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; |
| 999 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1000 |
ROLLBACK; |
| 1001 |
Warnings: |
| 1002 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1003 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1004 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1005 |
include/show_binlog_events.inc |
| 1006 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1007 |
master-bin.000001 # Query # # BEGIN |
| 1008 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1009 |
master-bin.000001 # Query # # COMMIT |
| 1010 |
master-bin.000001 # Query # # BEGIN |
| 1011 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1012 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */ |
| 1013 |
master-bin.000001 # Query # # ROLLBACK |
| 1014 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1015 |
|
| 1016 |
SET @commands= 'B T Drop-Temp-NN-Temp R'; |
| 1017 |
BEGIN; |
| 1018 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1019 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 1020 |
ROLLBACK; |
| 1021 |
Warnings: |
| 1022 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1023 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1024 |
include/show_binlog_events.inc |
| 1025 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1026 |
master-bin.000001 # Query # # BEGIN |
| 1027 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 1028 |
master-bin.000001 # Query # # COMMIT |
| 1029 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1030 |
|
| 1031 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R'; |
| 1032 |
BEGIN; |
| 1033 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1034 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 1035 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1036 |
ROLLBACK; |
| 1037 |
Warnings: |
| 1038 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1039 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1040 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1041 |
include/show_binlog_events.inc |
| 1042 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1043 |
master-bin.000001 # Query # # BEGIN |
| 1044 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 1045 |
master-bin.000001 # Query # # COMMIT |
| 1046 |
master-bin.000001 # Query # # BEGIN |
| 1047 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1048 |
master-bin.000001 # Query # # COMMIT |
| 1049 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1050 |
|
| 1051 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R'; |
| 1052 |
BEGIN; |
| 1053 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1054 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 1055 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1056 |
INSERT INTO nt_error_1() VALUES (3), (3); |
| 1057 |
ERROR 23000: Duplicate entry '3' for key 'nt_error_1.PRIMARY' |
| 1058 |
ROLLBACK; |
| 1059 |
Warnings: |
| 1060 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1061 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1062 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1063 |
include/show_binlog_events.inc |
| 1064 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1065 |
master-bin.000001 # Query # # BEGIN |
| 1066 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 1067 |
master-bin.000001 # Query # # COMMIT |
| 1068 |
master-bin.000001 # Query # # BEGIN |
| 1069 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1070 |
master-bin.000001 # Query # # COMMIT |
| 1071 |
master-bin.000001 # Query # # BEGIN |
| 1072 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (3), (3) |
| 1073 |
master-bin.000001 # Query # # COMMIT |
| 1074 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1075 |
|
| 1076 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R'; |
| 1077 |
BEGIN; |
| 1078 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1079 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 1080 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1081 |
INSERT INTO tt_error_1() VALUES (2), (2); |
| 1082 |
ERROR 23000: Duplicate entry '2' for key 'tt_error_1.PRIMARY' |
| 1083 |
ROLLBACK; |
| 1084 |
Warnings: |
| 1085 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1086 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1087 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1088 |
include/show_binlog_events.inc |
| 1089 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1090 |
master-bin.000001 # Query # # BEGIN |
| 1091 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 1092 |
master-bin.000001 # Query # # COMMIT |
| 1093 |
master-bin.000001 # Query # # BEGIN |
| 1094 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1095 |
master-bin.000001 # Query # # COMMIT |
| 1096 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1097 |
|
| 1098 |
SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R'; |
| 1099 |
BEGIN; |
| 1100 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1101 |
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; |
| 1102 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1103 |
INSERT INTO nt_error_1() VALUES (4), (4); |
| 1104 |
ERROR 23000: Duplicate entry '4' for key 'nt_error_1.PRIMARY' |
| 1105 |
ROLLBACK; |
| 1106 |
Warnings: |
| 1107 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1108 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1109 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1110 |
include/show_binlog_events.inc |
| 1111 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1112 |
master-bin.000001 # Query # # BEGIN |
| 1113 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */ |
| 1114 |
master-bin.000001 # Query # # COMMIT |
| 1115 |
master-bin.000001 # Query # # BEGIN |
| 1116 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1117 |
master-bin.000001 # Query # # COMMIT |
| 1118 |
master-bin.000001 # Query # # BEGIN |
| 1119 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (4), (4) |
| 1120 |
master-bin.000001 # Query # # COMMIT |
| 1121 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1122 |
|
| 1123 |
######################################################################### |
| 1124 |
# 2 - Tables dropped by "DROP TABLE" |
| 1125 |
######################################################################### |
| 1126 |
|
| 1127 |
# |
| 1128 |
#1) Generates in the binlog what follows: |
| 1129 |
# |
| 1130 |
SET @commands= 'Drop-T'; |
| 1131 |
DROP TABLE tt_2; |
| 1132 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-T << -b-b-b-b-b-b-b-b-b-b-b- |
| 1133 |
include/show_binlog_events.inc |
| 1134 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1135 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */ |
| 1136 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-T << -e-e-e-e-e-e-e-e-e-e-e- |
| 1137 |
|
| 1138 |
SET @commands= 'Drop-N'; |
| 1139 |
DROP TABLE nt_2; |
| 1140 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-N << -b-b-b-b-b-b-b-b-b-b-b- |
| 1141 |
include/show_binlog_events.inc |
| 1142 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1143 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1144 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-N << -e-e-e-e-e-e-e-e-e-e-e- |
| 1145 |
|
| 1146 |
SET @commands= 'Drop-Xe'; |
| 1147 |
DROP TABLE xx_1; |
| 1148 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1149 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1150 |
include/show_binlog_events.inc |
| 1151 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1152 |
|
| 1153 |
SET @commands= 'Drop-If-Xe'; |
| 1154 |
DROP TABLE IF EXISTS xx_1; |
| 1155 |
Warnings: |
| 1156 |
Note 1051 Unknown table 'test.xx_1' |
| 1157 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-Xe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1158 |
include/show_binlog_events.inc |
| 1159 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1160 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ |
| 1161 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1162 |
|
| 1163 |
SET @commands= 'Drop-TXe'; |
| 1164 |
DROP TABLE tt_2, xx_1; |
| 1165 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1166 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1167 |
include/show_binlog_events.inc |
| 1168 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1169 |
|
| 1170 |
SET @commands= 'Drop-If-TXe'; |
| 1171 |
DROP TABLE IF EXISTS tt_2, xx_1; |
| 1172 |
Warnings: |
| 1173 |
Note 1051 Unknown table 'test.xx_1' |
| 1174 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-TXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1175 |
include/show_binlog_events.inc |
| 1176 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1177 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */ |
| 1178 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-TXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1179 |
|
| 1180 |
SET @commands= 'Drop-NXe'; |
| 1181 |
DROP TABLE nt_2, xx_1; |
| 1182 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1183 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1184 |
include/show_binlog_events.inc |
| 1185 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1186 |
|
| 1187 |
SET @commands= 'Drop-If-NXe'; |
| 1188 |
DROP TABLE IF EXISTS nt_2, xx_1; |
| 1189 |
Warnings: |
| 1190 |
Note 1051 Unknown table 'test.xx_1' |
| 1191 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-NXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1192 |
include/show_binlog_events.inc |
| 1193 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1194 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */ |
| 1195 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ |
| 1196 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-NXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1197 |
|
| 1198 |
SET @commands= 'Drop-TN'; |
| 1199 |
DROP TABLE tt_2, nt_2; |
| 1200 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN << -b-b-b-b-b-b-b-b-b-b-b- |
| 1201 |
include/show_binlog_events.inc |
| 1202 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1203 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1204 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */ |
| 1205 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN << -e-e-e-e-e-e-e-e-e-e-e- |
| 1206 |
|
| 1207 |
SET @commands= 'Drop-TT'; |
| 1208 |
DROP TABLE tt_1, tt_2; |
| 1209 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-TT << -b-b-b-b-b-b-b-b-b-b-b- |
| 1210 |
include/show_binlog_events.inc |
| 1211 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1212 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */ |
| 1213 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-TT << -e-e-e-e-e-e-e-e-e-e-e- |
| 1214 |
|
| 1215 |
SET @commands= 'Drop-NN'; |
| 1216 |
DROP TABLE nt_1, nt_2; |
| 1217 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-NN << -b-b-b-b-b-b-b-b-b-b-b- |
| 1218 |
include/show_binlog_events.inc |
| 1219 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1220 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */ |
| 1221 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1222 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-NN << -e-e-e-e-e-e-e-e-e-e-e- |
| 1223 |
|
| 1224 |
SET @commands= 'Drop-N-TN-Temp'; |
| 1225 |
DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; |
| 1226 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-N-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1227 |
include/show_binlog_events.inc |
| 1228 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1229 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1230 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1231 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1232 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1233 |
|
| 1234 |
SET @commands= 'Drop-TN-Temp'; |
| 1235 |
DROP TABLE tt_tmp_2, nt_tmp_2; |
| 1236 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1237 |
include/show_binlog_events.inc |
| 1238 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1239 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1240 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1241 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1242 |
|
| 1243 |
|
| 1244 |
# |
| 1245 |
#2) Generates in the binlog what follows: |
| 1246 |
# |
| 1247 |
SET @commands= 'B T Drop-T'; |
| 1248 |
BEGIN; |
| 1249 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1250 |
DROP TABLE tt_2; |
| 1251 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-T << -b-b-b-b-b-b-b-b-b-b-b- |
| 1252 |
include/show_binlog_events.inc |
| 1253 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1254 |
master-bin.000001 # Query # # BEGIN |
| 1255 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1256 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1257 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */ |
| 1258 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-T << -e-e-e-e-e-e-e-e-e-e-e- |
| 1259 |
|
| 1260 |
SET @commands= 'B T Drop-N'; |
| 1261 |
BEGIN; |
| 1262 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1263 |
DROP TABLE nt_2; |
| 1264 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-N << -b-b-b-b-b-b-b-b-b-b-b- |
| 1265 |
include/show_binlog_events.inc |
| 1266 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1267 |
master-bin.000001 # Query # # BEGIN |
| 1268 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1269 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1270 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1271 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-N << -e-e-e-e-e-e-e-e-e-e-e- |
| 1272 |
|
| 1273 |
SET @commands= 'B T Drop-Xe'; |
| 1274 |
BEGIN; |
| 1275 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1276 |
DROP TABLE xx_1; |
| 1277 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1278 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1279 |
include/show_binlog_events.inc |
| 1280 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1281 |
master-bin.000001 # Query # # BEGIN |
| 1282 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1283 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1284 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1285 |
|
| 1286 |
SET @commands= 'B T Drop-If-Xe'; |
| 1287 |
BEGIN; |
| 1288 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1289 |
DROP TABLE IF EXISTS xx_1; |
| 1290 |
Warnings: |
| 1291 |
Note 1051 Unknown table 'test.xx_1' |
| 1292 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-Xe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1293 |
include/show_binlog_events.inc |
| 1294 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1295 |
master-bin.000001 # Query # # BEGIN |
| 1296 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1297 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1298 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ |
| 1299 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1300 |
|
| 1301 |
SET @commands= 'B T Drop-TXe'; |
| 1302 |
BEGIN; |
| 1303 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1304 |
DROP TABLE tt_2, xx_1; |
| 1305 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1306 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1307 |
include/show_binlog_events.inc |
| 1308 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1309 |
master-bin.000001 # Query # # BEGIN |
| 1310 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1311 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1312 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1313 |
|
| 1314 |
SET @commands= 'B T Drop-If-TXe'; |
| 1315 |
BEGIN; |
| 1316 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1317 |
DROP TABLE IF EXISTS tt_2, xx_1; |
| 1318 |
Warnings: |
| 1319 |
Note 1051 Unknown table 'test.xx_1' |
| 1320 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-TXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1321 |
include/show_binlog_events.inc |
| 1322 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1323 |
master-bin.000001 # Query # # BEGIN |
| 1324 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1325 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1326 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */ |
| 1327 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-TXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1328 |
|
| 1329 |
SET @commands= 'B T Drop-NXe'; |
| 1330 |
BEGIN; |
| 1331 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1332 |
DROP TABLE nt_2, xx_1; |
| 1333 |
ERROR 42S02: Unknown table 'test.xx_1' |
| 1334 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1335 |
include/show_binlog_events.inc |
| 1336 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1337 |
master-bin.000001 # Query # # BEGIN |
| 1338 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1339 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1340 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1341 |
|
| 1342 |
SET @commands= 'B T Drop-If-NXe'; |
| 1343 |
BEGIN; |
| 1344 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1345 |
DROP TABLE IF EXISTS nt_2, xx_1; |
| 1346 |
Warnings: |
| 1347 |
Note 1051 Unknown table 'test.xx_1' |
| 1348 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-NXe << -b-b-b-b-b-b-b-b-b-b-b- |
| 1349 |
include/show_binlog_events.inc |
| 1350 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1351 |
master-bin.000001 # Query # # BEGIN |
| 1352 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1353 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1354 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */ |
| 1355 |
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ |
| 1356 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-NXe << -e-e-e-e-e-e-e-e-e-e-e- |
| 1357 |
|
| 1358 |
SET @commands= 'B T Drop-TN'; |
| 1359 |
BEGIN; |
| 1360 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1361 |
DROP TABLE tt_2, nt_2; |
| 1362 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TN << -b-b-b-b-b-b-b-b-b-b-b- |
| 1363 |
include/show_binlog_events.inc |
| 1364 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1365 |
master-bin.000001 # Query # # BEGIN |
| 1366 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1367 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1368 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1369 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */ |
| 1370 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TN << -e-e-e-e-e-e-e-e-e-e-e- |
| 1371 |
|
| 1372 |
SET @commands= 'B T Drop-TT'; |
| 1373 |
BEGIN; |
| 1374 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1375 |
DROP TABLE tt_1, tt_2; |
| 1376 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TT << -b-b-b-b-b-b-b-b-b-b-b- |
| 1377 |
include/show_binlog_events.inc |
| 1378 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1379 |
master-bin.000001 # Query # # BEGIN |
| 1380 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1381 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1382 |
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */ |
| 1383 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TT << -e-e-e-e-e-e-e-e-e-e-e- |
| 1384 |
|
| 1385 |
SET @commands= 'B T Drop-NN'; |
| 1386 |
BEGIN; |
| 1387 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1388 |
DROP TABLE nt_1, nt_2; |
| 1389 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-NN << -b-b-b-b-b-b-b-b-b-b-b- |
| 1390 |
include/show_binlog_events.inc |
| 1391 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1392 |
master-bin.000001 # Query # # BEGIN |
| 1393 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1394 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1395 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */ |
| 1396 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1397 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-NN << -e-e-e-e-e-e-e-e-e-e-e- |
| 1398 |
|
| 1399 |
SET @commands= 'B T Drop-N-TN-Temp'; |
| 1400 |
BEGIN; |
| 1401 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1402 |
DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; |
| 1403 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-N-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1404 |
include/show_binlog_events.inc |
| 1405 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1406 |
master-bin.000001 # Query # # BEGIN |
| 1407 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1408 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1409 |
master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ |
| 1410 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1411 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1412 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1413 |
|
| 1414 |
SET @commands= 'B T Drop-TN-Temp'; |
| 1415 |
BEGIN; |
| 1416 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1417 |
DROP TABLE tt_tmp_2, nt_tmp_2; |
| 1418 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1419 |
include/show_binlog_events.inc |
| 1420 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1421 |
master-bin.000001 # Query # # BEGIN |
| 1422 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1423 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1424 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1425 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1426 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1427 |
|
| 1428 |
######################################################################### |
| 1429 |
# 3 - CREATE TEMPORARY TABLE |
| 1430 |
######################################################################### |
| 1431 |
|
| 1432 |
# |
| 1433 |
#1) Generates in the binlog what follows: |
| 1434 |
# |
| 1435 |
SET @commands= 'Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp'; |
| 1436 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1437 |
CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam; |
| 1438 |
DROP TEMPORARY TABLE nt_tmp_1; |
| 1439 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1440 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1441 |
include/show_binlog_events.inc |
| 1442 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1443 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1444 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam |
| 1445 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 1446 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1447 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1448 |
|
| 1449 |
SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp'; |
| 1450 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1451 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1452 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1453 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1454 |
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp << -b-b-b-b-b-b-b-b-b-b-b- |
| 1455 |
include/show_binlog_events.inc |
| 1456 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1457 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1458 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1459 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1460 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1461 |
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp << -e-e-e-e-e-e-e-e-e-e-e- |
| 1462 |
|
| 1463 |
|
| 1464 |
# |
| 1465 |
#2) Generates in the binlog what follows: |
| 1466 |
# |
| 1467 |
SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C'; |
| 1468 |
BEGIN; |
| 1469 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1470 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1471 |
CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam; |
| 1472 |
DROP TEMPORARY TABLE nt_tmp_1; |
| 1473 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1474 |
COMMIT; |
| 1475 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1476 |
include/show_binlog_events.inc |
| 1477 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1478 |
master-bin.000001 # Query # # BEGIN |
| 1479 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1480 |
master-bin.000001 # Query # # COMMIT |
| 1481 |
master-bin.000001 # Query # # BEGIN |
| 1482 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam |
| 1483 |
master-bin.000001 # Query # # COMMIT |
| 1484 |
master-bin.000001 # Query # # BEGIN |
| 1485 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 1486 |
master-bin.000001 # Query # # COMMIT |
| 1487 |
master-bin.000001 # Query # # BEGIN |
| 1488 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1489 |
master-bin.000001 # Query # # COMMIT |
| 1490 |
master-bin.000001 # Query # # BEGIN |
| 1491 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) |
| 1492 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1493 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1494 |
|
| 1495 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C'; |
| 1496 |
BEGIN; |
| 1497 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1498 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1499 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1500 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1501 |
COMMIT; |
| 1502 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1503 |
include/show_binlog_events.inc |
| 1504 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1505 |
master-bin.000001 # Query # # BEGIN |
| 1506 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1507 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1508 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1509 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1510 |
master-bin.000001 # Query # # COMMIT |
| 1511 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1512 |
|
| 1513 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C'; |
| 1514 |
BEGIN; |
| 1515 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1516 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1517 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1518 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1519 |
INSERT INTO nt_error_1() VALUES (5), (5); |
| 1520 |
ERROR 23000: Duplicate entry '5' for key 'nt_error_1.PRIMARY' |
| 1521 |
COMMIT; |
| 1522 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1523 |
include/show_binlog_events.inc |
| 1524 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1525 |
master-bin.000001 # Query # # BEGIN |
| 1526 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (5), (5) |
| 1527 |
master-bin.000001 # Query # # COMMIT |
| 1528 |
master-bin.000001 # Query # # BEGIN |
| 1529 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1530 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1531 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1532 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1533 |
master-bin.000001 # Query # # COMMIT |
| 1534 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1535 |
|
| 1536 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C'; |
| 1537 |
BEGIN; |
| 1538 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1539 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1540 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1541 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1542 |
INSERT INTO tt_error_1() VALUES (3), (3); |
| 1543 |
ERROR 23000: Duplicate entry '3' for key 'tt_error_1.PRIMARY' |
| 1544 |
COMMIT; |
| 1545 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1546 |
include/show_binlog_events.inc |
| 1547 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1548 |
master-bin.000001 # Query # # BEGIN |
| 1549 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1550 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1551 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1552 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1553 |
master-bin.000001 # Query # # COMMIT |
| 1554 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1555 |
|
| 1556 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C'; |
| 1557 |
BEGIN; |
| 1558 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1559 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1560 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1561 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1562 |
INSERT INTO nt_error_1() VALUES (6), (6); |
| 1563 |
ERROR 23000: Duplicate entry '6' for key 'nt_error_1.PRIMARY' |
| 1564 |
COMMIT; |
| 1565 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1566 |
include/show_binlog_events.inc |
| 1567 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1568 |
master-bin.000001 # Query # # BEGIN |
| 1569 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (6), (6) |
| 1570 |
master-bin.000001 # Query # # COMMIT |
| 1571 |
master-bin.000001 # Query # # BEGIN |
| 1572 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1573 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1574 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1575 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1576 |
master-bin.000001 # Query # # COMMIT |
| 1577 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1578 |
|
| 1579 |
|
| 1580 |
# |
| 1581 |
#3) Generates in the binlog what follows: |
| 1582 |
# |
| 1583 |
SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R'; |
| 1584 |
BEGIN; |
| 1585 |
INSERT INTO tt_xx_1() VALUES (1); |
| 1586 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1587 |
CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam; |
| 1588 |
DROP TEMPORARY TABLE nt_tmp_1; |
| 1589 |
DROP TEMPORARY TABLE nt_tmp_2; |
| 1590 |
ROLLBACK; |
| 1591 |
Warnings: |
| 1592 |
Warning # The creation of some temporary tables could not be rolled back. |
| 1593 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1594 |
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1595 |
include/show_binlog_events.inc |
| 1596 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1597 |
master-bin.000001 # Query # # BEGIN |
| 1598 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1599 |
master-bin.000001 # Query # # COMMIT |
| 1600 |
master-bin.000001 # Query # # BEGIN |
| 1601 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam |
| 1602 |
master-bin.000001 # Query # # COMMIT |
| 1603 |
master-bin.000001 # Query # # BEGIN |
| 1604 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */ |
| 1605 |
master-bin.000001 # Query # # COMMIT |
| 1606 |
master-bin.000001 # Query # # BEGIN |
| 1607 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */ |
| 1608 |
master-bin.000001 # Query # # COMMIT |
| 1609 |
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1610 |
|
| 1611 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R'; |
| 1612 |
BEGIN; |
| 1613 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1614 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1615 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1616 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1617 |
ROLLBACK; |
| 1618 |
Warnings: |
| 1619 |
Warning # The creation of some temporary tables could not be rolled back. |
| 1620 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1621 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1622 |
include/show_binlog_events.inc |
| 1623 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1624 |
master-bin.000001 # Query # # BEGIN |
| 1625 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1626 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1627 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1628 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1629 |
master-bin.000001 # Query # # ROLLBACK |
| 1630 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1631 |
|
| 1632 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R'; |
| 1633 |
BEGIN; |
| 1634 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1635 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1636 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1637 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1638 |
INSERT INTO nt_error_1() VALUES (7), (7); |
| 1639 |
ERROR 23000: Duplicate entry '7' for key 'nt_error_1.PRIMARY' |
| 1640 |
ROLLBACK; |
| 1641 |
Warnings: |
| 1642 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1643 |
Warning # The creation of some temporary tables could not be rolled back. |
| 1644 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1645 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1646 |
include/show_binlog_events.inc |
| 1647 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1648 |
master-bin.000001 # Query # # BEGIN |
| 1649 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (7), (7) |
| 1650 |
master-bin.000001 # Query # # COMMIT |
| 1651 |
master-bin.000001 # Query # # BEGIN |
| 1652 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1653 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1654 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1655 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1656 |
master-bin.000001 # Query # # ROLLBACK |
| 1657 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1658 |
|
| 1659 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R'; |
| 1660 |
BEGIN; |
| 1661 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1662 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1663 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1664 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1665 |
INSERT INTO tt_error_1() VALUES (4), (4); |
| 1666 |
ERROR 23000: Duplicate entry '4' for key 'tt_error_1.PRIMARY' |
| 1667 |
ROLLBACK; |
| 1668 |
Warnings: |
| 1669 |
Warning # The creation of some temporary tables could not be rolled back. |
| 1670 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1671 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1672 |
include/show_binlog_events.inc |
| 1673 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1674 |
master-bin.000001 # Query # # BEGIN |
| 1675 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1676 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1677 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1678 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1679 |
master-bin.000001 # Query # # ROLLBACK |
| 1680 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1681 |
|
| 1682 |
SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R'; |
| 1683 |
BEGIN; |
| 1684 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1685 |
CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb; |
| 1686 |
DROP TEMPORARY TABLE tt_tmp_1; |
| 1687 |
DROP TEMPORARY TABLE tt_tmp_2; |
| 1688 |
INSERT INTO nt_error_1() VALUES (8), (8); |
| 1689 |
ERROR 23000: Duplicate entry '8' for key 'nt_error_1.PRIMARY' |
| 1690 |
ROLLBACK; |
| 1691 |
Warnings: |
| 1692 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1693 |
Warning # The creation of some temporary tables could not be rolled back. |
| 1694 |
Warning # Some temporary tables were dropped, but these operations could not be rolled back. |
| 1695 |
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1696 |
include/show_binlog_events.inc |
| 1697 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1698 |
master-bin.000001 # Query # # BEGIN |
| 1699 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (8), (8) |
| 1700 |
master-bin.000001 # Query # # COMMIT |
| 1701 |
master-bin.000001 # Query # # BEGIN |
| 1702 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1703 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb |
| 1704 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */ |
| 1705 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */ |
| 1706 |
master-bin.000001 # Query # # ROLLBACK |
| 1707 |
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1708 |
|
| 1709 |
######################################################################### |
| 1710 |
# 4 - CHANGING TEMPORARY TABLES |
| 1711 |
######################################################################### |
| 1712 |
|
| 1713 |
# |
| 1714 |
#1) Generates in the binlog what follows: |
| 1715 |
# |
| 1716 |
SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp C'; |
| 1717 |
BEGIN; |
| 1718 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1719 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1720 |
INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1; |
| 1721 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1722 |
COMMIT; |
| 1723 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-N-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1724 |
include/show_binlog_events.inc |
| 1725 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1726 |
master-bin.000001 # Query # # BEGIN |
| 1727 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1728 |
master-bin.000001 # Query # # COMMIT |
| 1729 |
master-bin.000001 # Query # # BEGIN |
| 1730 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1731 |
master-bin.000001 # Query # # COMMIT |
| 1732 |
master-bin.000001 # Query # # BEGIN |
| 1733 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1 |
| 1734 |
master-bin.000001 # Query # # COMMIT |
| 1735 |
master-bin.000001 # Query # # BEGIN |
| 1736 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1737 |
master-bin.000001 # Query # # COMMIT |
| 1738 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-N-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1739 |
|
| 1740 |
SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp C'; |
| 1741 |
BEGIN; |
| 1742 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1743 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1744 |
INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1; |
| 1745 |
Warnings: |
| 1746 |
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. |
| 1747 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1748 |
COMMIT; |
| 1749 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-N-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1750 |
include/show_binlog_events.inc |
| 1751 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1752 |
master-bin.000001 # Query # # BEGIN |
| 1753 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1754 |
master-bin.000001 # Query # # COMMIT |
| 1755 |
master-bin.000001 # Query # # BEGIN |
| 1756 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1757 |
master-bin.000001 # Query # # COMMIT |
| 1758 |
master-bin.000001 # Query # # BEGIN |
| 1759 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1760 |
master-bin.000001 # Query # # COMMIT |
| 1761 |
master-bin.000001 # Query # # BEGIN |
| 1762 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1 |
| 1763 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1764 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-N-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1765 |
|
| 1766 |
SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp C'; |
| 1767 |
BEGIN; |
| 1768 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1769 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1770 |
INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1771 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1772 |
COMMIT; |
| 1773 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-T-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1774 |
include/show_binlog_events.inc |
| 1775 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1776 |
master-bin.000001 # Query # # BEGIN |
| 1777 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1778 |
master-bin.000001 # Query # # COMMIT |
| 1779 |
master-bin.000001 # Query # # BEGIN |
| 1780 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1781 |
master-bin.000001 # Query # # COMMIT |
| 1782 |
master-bin.000001 # Query # # BEGIN |
| 1783 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1784 |
master-bin.000001 # Query # # COMMIT |
| 1785 |
master-bin.000001 # Query # # BEGIN |
| 1786 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1787 |
master-bin.000001 # Query # # COMMIT |
| 1788 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-T-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1789 |
|
| 1790 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp C'; |
| 1791 |
BEGIN; |
| 1792 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1793 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1794 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1795 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1796 |
COMMIT; |
| 1797 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1798 |
include/show_binlog_events.inc |
| 1799 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1800 |
master-bin.000001 # Query # # BEGIN |
| 1801 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1802 |
master-bin.000001 # Query # # COMMIT |
| 1803 |
master-bin.000001 # Query # # BEGIN |
| 1804 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1805 |
master-bin.000001 # Query # # COMMIT |
| 1806 |
master-bin.000001 # Query # # BEGIN |
| 1807 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1808 |
master-bin.000001 # Query # # COMMIT |
| 1809 |
master-bin.000001 # Query # # BEGIN |
| 1810 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1811 |
master-bin.000001 # Query # # COMMIT |
| 1812 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1813 |
|
| 1814 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne C'; |
| 1815 |
BEGIN; |
| 1816 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1817 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1818 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1819 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1820 |
INSERT INTO nt_error_1() VALUES (9), (9); |
| 1821 |
ERROR 23000: Duplicate entry '9' for key 'nt_error_1.PRIMARY' |
| 1822 |
COMMIT; |
| 1823 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1824 |
include/show_binlog_events.inc |
| 1825 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1826 |
master-bin.000001 # Query # # BEGIN |
| 1827 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1828 |
master-bin.000001 # Query # # COMMIT |
| 1829 |
master-bin.000001 # Query # # BEGIN |
| 1830 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1831 |
master-bin.000001 # Query # # COMMIT |
| 1832 |
master-bin.000001 # Query # # BEGIN |
| 1833 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1834 |
master-bin.000001 # Query # # COMMIT |
| 1835 |
master-bin.000001 # Query # # BEGIN |
| 1836 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (9), (9) |
| 1837 |
master-bin.000001 # Query # # COMMIT |
| 1838 |
master-bin.000001 # Query # # BEGIN |
| 1839 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1840 |
master-bin.000001 # Query # # COMMIT |
| 1841 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1842 |
|
| 1843 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te C'; |
| 1844 |
BEGIN; |
| 1845 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1846 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1847 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1848 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1849 |
INSERT INTO tt_error_1() VALUES (5), (5); |
| 1850 |
ERROR 23000: Duplicate entry '5' for key 'tt_error_1.PRIMARY' |
| 1851 |
COMMIT; |
| 1852 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1853 |
include/show_binlog_events.inc |
| 1854 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1855 |
master-bin.000001 # Query # # BEGIN |
| 1856 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1857 |
master-bin.000001 # Query # # COMMIT |
| 1858 |
master-bin.000001 # Query # # BEGIN |
| 1859 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1860 |
master-bin.000001 # Query # # COMMIT |
| 1861 |
master-bin.000001 # Query # # BEGIN |
| 1862 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1863 |
master-bin.000001 # Query # # COMMIT |
| 1864 |
master-bin.000001 # Query # # BEGIN |
| 1865 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1866 |
master-bin.000001 # Query # # COMMIT |
| 1867 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1868 |
|
| 1869 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C'; |
| 1870 |
BEGIN; |
| 1871 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1872 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1873 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1874 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1875 |
INSERT INTO nt_error_1() VALUES (10), (10); |
| 1876 |
ERROR 23000: Duplicate entry '10' for key 'nt_error_1.PRIMARY' |
| 1877 |
COMMIT; |
| 1878 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b- |
| 1879 |
include/show_binlog_events.inc |
| 1880 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1881 |
master-bin.000001 # Query # # BEGIN |
| 1882 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1883 |
master-bin.000001 # Query # # COMMIT |
| 1884 |
master-bin.000001 # Query # # BEGIN |
| 1885 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1886 |
master-bin.000001 # Query # # COMMIT |
| 1887 |
master-bin.000001 # Query # # BEGIN |
| 1888 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1889 |
master-bin.000001 # Query # # COMMIT |
| 1890 |
master-bin.000001 # Query # # BEGIN |
| 1891 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (10), (10) |
| 1892 |
master-bin.000001 # Query # # COMMIT |
| 1893 |
master-bin.000001 # Query # # BEGIN |
| 1894 |
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1895 |
master-bin.000001 # Query # # COMMIT |
| 1896 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e- |
| 1897 |
|
| 1898 |
|
| 1899 |
|
| 1900 |
# |
| 1901 |
#2) Generates in the binlog what follows: |
| 1902 |
# |
| 1903 |
SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp R'; |
| 1904 |
BEGIN; |
| 1905 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1906 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1907 |
INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1; |
| 1908 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1909 |
ROLLBACK; |
| 1910 |
Warnings: |
| 1911 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1912 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-N-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1913 |
include/show_binlog_events.inc |
| 1914 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1915 |
master-bin.000001 # Query # # BEGIN |
| 1916 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1917 |
master-bin.000001 # Query # # COMMIT |
| 1918 |
master-bin.000001 # Query # # BEGIN |
| 1919 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1920 |
master-bin.000001 # Query # # COMMIT |
| 1921 |
master-bin.000001 # Query # # BEGIN |
| 1922 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1 |
| 1923 |
master-bin.000001 # Query # # COMMIT |
| 1924 |
master-bin.000001 # Query # # BEGIN |
| 1925 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1926 |
master-bin.000001 # Query # # COMMIT |
| 1927 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-N-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1928 |
|
| 1929 |
SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp R'; |
| 1930 |
BEGIN; |
| 1931 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1932 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1933 |
INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1; |
| 1934 |
Warnings: |
| 1935 |
Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. |
| 1936 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1937 |
ROLLBACK; |
| 1938 |
Warnings: |
| 1939 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1940 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-N-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1941 |
include/show_binlog_events.inc |
| 1942 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1943 |
master-bin.000001 # Query # # BEGIN |
| 1944 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1945 |
master-bin.000001 # Query # # COMMIT |
| 1946 |
master-bin.000001 # Query # # BEGIN |
| 1947 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1948 |
master-bin.000001 # Query # # COMMIT |
| 1949 |
master-bin.000001 # Query # # BEGIN |
| 1950 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1951 |
master-bin.000001 # Query # # COMMIT |
| 1952 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-N-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1953 |
|
| 1954 |
SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp R'; |
| 1955 |
BEGIN; |
| 1956 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1957 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1958 |
INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1959 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1960 |
ROLLBACK; |
| 1961 |
Warnings: |
| 1962 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1963 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-T-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1964 |
include/show_binlog_events.inc |
| 1965 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1966 |
master-bin.000001 # Query # # BEGIN |
| 1967 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1968 |
master-bin.000001 # Query # # COMMIT |
| 1969 |
master-bin.000001 # Query # # BEGIN |
| 1970 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1971 |
master-bin.000001 # Query # # COMMIT |
| 1972 |
master-bin.000001 # Query # # BEGIN |
| 1973 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1 |
| 1974 |
master-bin.000001 # Query # # COMMIT |
| 1975 |
master-bin.000001 # Query # # BEGIN |
| 1976 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1977 |
master-bin.000001 # Query # # COMMIT |
| 1978 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-T-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 1979 |
|
| 1980 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp R'; |
| 1981 |
BEGIN; |
| 1982 |
INSERT INTO nt_xx_1() VALUES (1); |
| 1983 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1984 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 1985 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 1986 |
ROLLBACK; |
| 1987 |
Warnings: |
| 1988 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 1989 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b- |
| 1990 |
include/show_binlog_events.inc |
| 1991 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1992 |
master-bin.000001 # Query # # BEGIN |
| 1993 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 1994 |
master-bin.000001 # Query # # COMMIT |
| 1995 |
master-bin.000001 # Query # # BEGIN |
| 1996 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 1997 |
master-bin.000001 # Query # # COMMIT |
| 1998 |
master-bin.000001 # Query # # BEGIN |
| 1999 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2000 |
master-bin.000001 # Query # # COMMIT |
| 2001 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e- |
| 2002 |
|
| 2003 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne R'; |
| 2004 |
BEGIN; |
| 2005 |
INSERT INTO nt_xx_1() VALUES (1); |
| 2006 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2007 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 2008 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2009 |
INSERT INTO nt_error_1() VALUES (11), (11); |
| 2010 |
ERROR 23000: Duplicate entry '11' for key 'nt_error_1.PRIMARY' |
| 2011 |
ROLLBACK; |
| 2012 |
Warnings: |
| 2013 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 2014 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne R << -b-b-b-b-b-b-b-b-b-b-b- |
| 2015 |
include/show_binlog_events.inc |
| 2016 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 2017 |
master-bin.000001 # Query # # BEGIN |
| 2018 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 2019 |
master-bin.000001 # Query # # COMMIT |
| 2020 |
master-bin.000001 # Query # # BEGIN |
| 2021 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2022 |
master-bin.000001 # Query # # COMMIT |
| 2023 |
master-bin.000001 # Query # # BEGIN |
| 2024 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2025 |
master-bin.000001 # Query # # COMMIT |
| 2026 |
master-bin.000001 # Query # # BEGIN |
| 2027 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (11), (11) |
| 2028 |
master-bin.000001 # Query # # COMMIT |
| 2029 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne R << -e-e-e-e-e-e-e-e-e-e-e- |
| 2030 |
|
| 2031 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te R'; |
| 2032 |
BEGIN; |
| 2033 |
INSERT INTO nt_xx_1() VALUES (1); |
| 2034 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2035 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 2036 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2037 |
INSERT INTO tt_error_1() VALUES (6), (6); |
| 2038 |
ERROR 23000: Duplicate entry '6' for key 'tt_error_1.PRIMARY' |
| 2039 |
ROLLBACK; |
| 2040 |
Warnings: |
| 2041 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 2042 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b- |
| 2043 |
include/show_binlog_events.inc |
| 2044 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 2045 |
master-bin.000001 # Query # # BEGIN |
| 2046 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 2047 |
master-bin.000001 # Query # # COMMIT |
| 2048 |
master-bin.000001 # Query # # BEGIN |
| 2049 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2050 |
master-bin.000001 # Query # # COMMIT |
| 2051 |
master-bin.000001 # Query # # BEGIN |
| 2052 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2053 |
master-bin.000001 # Query # # COMMIT |
| 2054 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e- |
| 2055 |
|
| 2056 |
SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R'; |
| 2057 |
BEGIN; |
| 2058 |
INSERT INTO nt_xx_1() VALUES (1); |
| 2059 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2060 |
INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1; |
| 2061 |
INSERT INTO nt_tmp_xx_1() VALUES (1); |
| 2062 |
INSERT INTO nt_error_1() VALUES (12), (12); |
| 2063 |
ERROR 23000: Duplicate entry '12' for key 'nt_error_1.PRIMARY' |
| 2064 |
ROLLBACK; |
| 2065 |
Warnings: |
| 2066 |
Warning # Some non-transactional changed tables couldn't be rolled back |
| 2067 |
-b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b- |
| 2068 |
include/show_binlog_events.inc |
| 2069 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 2070 |
master-bin.000001 # Query # # BEGIN |
| 2071 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) |
| 2072 |
master-bin.000001 # Query # # COMMIT |
| 2073 |
master-bin.000001 # Query # # BEGIN |
| 2074 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2075 |
master-bin.000001 # Query # # COMMIT |
| 2076 |
master-bin.000001 # Query # # BEGIN |
| 2077 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1) |
| 2078 |
master-bin.000001 # Query # # COMMIT |
| 2079 |
master-bin.000001 # Query # # BEGIN |
| 2080 |
master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (12), (12) |
| 2081 |
master-bin.000001 # Query # # COMMIT |
| 2082 |
-e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e- |
| 2083 |
|
| 2084 |
################################################################################### |
| 2085 |
# CHECK CONSISTENCY |
| 2086 |
################################################################################### |
| 2087 |
######################################################################### |
| 2088 |
# CLEAN |
| 2089 |
######################################################################### |
| 2090 |
SET @commands= 'clean'; |
| 2091 |
DROP TABLE IF EXISTS tt_xx_1; |
| 2092 |
DROP TABLE IF EXISTS nt_xx_1; |
| 2093 |
DROP TABLE IF EXISTS tt_error_1; |
| 2094 |
DROP TABLE IF EXISTS nt_error_1; |
| 2095 |
DROP TABLE IF EXISTS tt_error_2; |
| 2096 |
DROP TABLE IF EXISTS nt_error_2; |
| 2097 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_xx_1; |
| 2098 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_xx_1; |
| 2099 |
DROP TABLE IF EXISTS nt_2; |
| 2100 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_2; |
| 2101 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_2; |
| 2102 |
DROP TABLE IF EXISTS nt_1; |
| 2103 |
DROP TEMPORARY TABLE IF EXISTS tt_tmp_1; |
| 2104 |
DROP TEMPORARY TABLE IF EXISTS nt_tmp_1; |
| 2105 |
DROP TABLE IF EXISTS tt_2; |
| 2106 |
DROP TABLE IF EXISTS tt_1; |
| 2107 |
SET @commands= ''; |
| 2108 |
include/rpl_end.inc |