| 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 |
# Verify that CREATE TEMPORARY TABLE in a single STMT transaction |
| 8 |
# is not written into binlog after committing the transaction. |
| 9 |
# |
| 10 |
BEGIN; |
| 11 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 12 |
COMMIT; |
| 13 |
include/show_binlog_events.inc |
| 14 |
include/sync_slave_sql_with_master.inc |
| 15 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 16 |
[connection master] |
| 17 |
# |
| 18 |
# Verify that DROP TEMPORARY TABLE in a single STMT transaction |
| 19 |
# is not written into binlog after committing the transaction. |
| 20 |
# |
| 21 |
BEGIN; |
| 22 |
DROP TEMPORARY TABLE temp1; |
| 23 |
COMMIT; |
| 24 |
include/show_binlog_events.inc |
| 25 |
CREATE TABLE t1 (c1 INT); |
| 26 |
# |
| 27 |
# Verify that CREATE or DML against TEMPORARY TABLE in a MULTI STMTs |
| 28 |
# transaction is not written into binlog after committing the |
| 29 |
# transaction. |
| 30 |
# |
| 31 |
BEGIN; |
| 32 |
INSERT INTO t1 VALUES (1); |
| 33 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 34 |
INSERT INTO temp1 VALUES (1); |
| 35 |
INSERT INTO t1 VALUES (2); |
| 36 |
COMMIT; |
| 37 |
include/show_binlog_events.inc |
| 38 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 39 |
master-bin.000001 # Query # # BEGIN |
| 40 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) |
| 41 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) |
| 42 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 43 |
include/sync_slave_sql_with_master.inc |
| 44 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 45 |
[connection master] |
| 46 |
# |
| 47 |
# Verify that DROP TEMPORARY TABLE in a MULTI STMTs transaction |
| 48 |
# is not written into binlog after committing the transaction. |
| 49 |
# |
| 50 |
BEGIN; |
| 51 |
INSERT INTO t1 VALUES (3); |
| 52 |
INSERT INTO temp1 VALUES (2); |
| 53 |
DROP TEMPORARY TABLE temp1; |
| 54 |
INSERT INTO t1 VALUES (4); |
| 55 |
COMMIT; |
| 56 |
include/show_binlog_events.inc |
| 57 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 58 |
master-bin.000001 # Query # # BEGIN |
| 59 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3) |
| 60 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4) |
| 61 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 62 |
include/sync_slave_sql_with_master.inc |
| 63 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 64 |
[connection master] |
| 65 |
# |
| 66 |
# Verify that CREATE TEMPORARY TABLE in a single STMT transaction |
| 67 |
# is not written into binlog after rolling back the transaction. |
| 68 |
# |
| 69 |
BEGIN; |
| 70 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 71 |
ROLLBACK; |
| 72 |
Warnings: |
| 73 |
Warning 1751 The creation of some temporary tables could not be rolled back. |
| 74 |
include/show_binlog_events.inc |
| 75 |
include/sync_slave_sql_with_master.inc |
| 76 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 77 |
[connection master] |
| 78 |
# |
| 79 |
# Verify that DROP TEMPORARY TABLE in a single STMT transaction |
| 80 |
# is not written into binlog after rolling back the transaction. |
| 81 |
# |
| 82 |
BEGIN; |
| 83 |
DROP TEMPORARY TABLE temp1; |
| 84 |
ROLLBACK; |
| 85 |
Warnings: |
| 86 |
Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. |
| 87 |
include/show_binlog_events.inc |
| 88 |
# |
| 89 |
# Verify that CREATE or DML against TEMPORARY TABLE in a MULTI STMTs |
| 90 |
# transaction is not written into binlog after rolling back the |
| 91 |
# transaction. |
| 92 |
# |
| 93 |
BEGIN; |
| 94 |
INSERT INTO t1 VALUES (5); |
| 95 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 96 |
INSERT INTO temp1 VALUES (1); |
| 97 |
INSERT INTO t1 VALUES (6); |
| 98 |
ROLLBACK; |
| 99 |
Warnings: |
| 100 |
Warning 1751 The creation of some temporary tables could not be rolled back. |
| 101 |
include/show_binlog_events.inc |
| 102 |
include/sync_slave_sql_with_master.inc |
| 103 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 104 |
[connection master] |
| 105 |
# |
| 106 |
# Verify that DROP TEMPORARY TABLE in a MULTI STMTs transaction |
| 107 |
# is not written into binlog after rolling back the transaction. |
| 108 |
# |
| 109 |
BEGIN; |
| 110 |
INSERT INTO t1 VALUES (7); |
| 111 |
INSERT INTO temp1 VALUES (2); |
| 112 |
DROP TEMPORARY TABLE temp1; |
| 113 |
INSERT INTO t1 VALUES (8); |
| 114 |
ROLLBACK; |
| 115 |
Warnings: |
| 116 |
Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. |
| 117 |
include/show_binlog_events.inc |
| 118 |
include/sync_slave_sql_with_master.inc |
| 119 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 120 |
[connection master] |
| 121 |
CREATE PROCEDURE sp1 () |
| 122 |
BEGIN |
| 123 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 124 |
END// |
| 125 |
CREATE PROCEDURE sp2 () |
| 126 |
BEGIN |
| 127 |
DROP TEMPORARY TABLE temp1; |
| 128 |
END// |
| 129 |
CREATE PROCEDURE sp3 () |
| 130 |
BEGIN |
| 131 |
INSERT INTO t1 VALUES (9); |
| 132 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 133 |
INSERT INTO temp1 VALUES (1); |
| 134 |
END// |
| 135 |
CREATE PROCEDURE sp4 () |
| 136 |
BEGIN |
| 137 |
INSERT INTO t1 VALUES (10); |
| 138 |
INSERT INTO temp1 VALUES (2); |
| 139 |
DROP TEMPORARY TABLE temp1; |
| 140 |
END// |
| 141 |
# |
| 142 |
# Verify that CREATE TEMPORARY TABLE in a single STMT procedure |
| 143 |
# is not written into binlog after committing the transaction. |
| 144 |
# |
| 145 |
START TRANSACTION; |
| 146 |
CALL sp1(); |
| 147 |
COMMIT; |
| 148 |
include/show_binlog_events.inc |
| 149 |
include/sync_slave_sql_with_master.inc |
| 150 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 151 |
[connection master] |
| 152 |
# |
| 153 |
# Verify that DROP TEMPORARY TABLE in a single STMT procedure |
| 154 |
# is not written into binlog after committing the transaction. |
| 155 |
# |
| 156 |
START TRANSACTION; |
| 157 |
CALL sp2(); |
| 158 |
COMMIT; |
| 159 |
include/show_binlog_events.inc |
| 160 |
# |
| 161 |
# Verify that CREATE or DML against TEMPORARY TABLE in a PROCEDURE |
| 162 |
# is not written into binlog after committing the transaction. |
| 163 |
# |
| 164 |
START TRANSACTION; |
| 165 |
CALL sp3(); |
| 166 |
COMMIT; |
| 167 |
include/show_binlog_events.inc |
| 168 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 169 |
master-bin.000001 # Query # # BEGIN |
| 170 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (9) |
| 171 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 172 |
include/sync_slave_sql_with_master.inc |
| 173 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 174 |
[connection master] |
| 175 |
# |
| 176 |
# Verify that DROP or DML against TEMPORARY TABLE in a PROCEDURE |
| 177 |
# is not written into binlog after committing the transaction. |
| 178 |
# |
| 179 |
START TRANSACTION; |
| 180 |
CALL sp4(); |
| 181 |
COMMIT; |
| 182 |
include/show_binlog_events.inc |
| 183 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 184 |
master-bin.000001 # Query # # BEGIN |
| 185 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10) |
| 186 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 187 |
include/sync_slave_sql_with_master.inc |
| 188 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 189 |
[connection master] |
| 190 |
# |
| 191 |
# Verify that CREATE TEMPORARY TABLE in a single STMT procedure |
| 192 |
# is not written into binlog after rolling back the transaction. |
| 193 |
# |
| 194 |
START TRANSACTION; |
| 195 |
CALL sp1(); |
| 196 |
ROLLBACK; |
| 197 |
Warnings: |
| 198 |
Warning 1751 The creation of some temporary tables could not be rolled back. |
| 199 |
include/show_binlog_events.inc |
| 200 |
include/sync_slave_sql_with_master.inc |
| 201 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 202 |
[connection master] |
| 203 |
# |
| 204 |
# Verify that DROP TEMPORARY TABLE in a single STMT procedure |
| 205 |
# is not written into binlog after rolling back the transaction. |
| 206 |
# |
| 207 |
START TRANSACTION; |
| 208 |
CALL sp2(); |
| 209 |
ROLLBACK; |
| 210 |
Warnings: |
| 211 |
Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. |
| 212 |
include/show_binlog_events.inc |
| 213 |
# |
| 214 |
# Verify that CREATE or DML against TEMPORARY TABLE in a PROCEDURE |
| 215 |
# is not written into binlog after rolling back the transaction. |
| 216 |
# |
| 217 |
START TRANSACTION; |
| 218 |
CALL sp3(); |
| 219 |
ROLLBACK; |
| 220 |
Warnings: |
| 221 |
Warning 1751 The creation of some temporary tables could not be rolled back. |
| 222 |
include/show_binlog_events.inc |
| 223 |
include/sync_slave_sql_with_master.inc |
| 224 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 225 |
[connection master] |
| 226 |
# |
| 227 |
# Verify that DROP or DML against TEMPORARY TABLE in a PROCEDURE |
| 228 |
# is not written into binlog after rolling back the transaction. |
| 229 |
# |
| 230 |
START TRANSACTION; |
| 231 |
CALL sp4(); |
| 232 |
ROLLBACK; |
| 233 |
Warnings: |
| 234 |
Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. |
| 235 |
include/show_binlog_events.inc |
| 236 |
include/sync_slave_sql_with_master.inc |
| 237 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 238 |
[connection master] |
| 239 |
DROP TABLE t1; |
| 240 |
DROP PROCEDURE sp1; |
| 241 |
DROP PROCEDURE sp2; |
| 242 |
DROP PROCEDURE sp3; |
| 243 |
DROP PROCEDURE sp4; |
| 244 |
include/rpl_end.inc |