| 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 EVENT |
| 8 |
# is written into binlog after executing the event when |
| 9 |
# @@session.binlog_format=STATEMENT. |
| 10 |
# |
| 11 |
CREATE EVENT event1 |
| 12 |
ON SCHEDULE EVERY 2 SECOND |
| 13 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 14 |
ON COMPLETION NOT PRESERVE |
| 15 |
DO BEGIN |
| 16 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 17 |
END;| |
| 18 |
include/show_binlog_events.inc |
| 19 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 20 |
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1 |
| 21 |
ON SCHEDULE EVERY 2 SECOND |
| 22 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 23 |
ON COMPLETION NOT PRESERVE |
| 24 |
DO BEGIN |
| 25 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 26 |
END |
| 27 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT) |
| 28 |
include/sync_slave_sql_with_master.inc |
| 29 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 30 |
[connection master] |
| 31 |
# |
| 32 |
# Verify that DROP TEMPORARY TABLE in a single STMT EVENT |
| 33 |
# is written into binlog after executing the event when |
| 34 |
# @@session.binlog_format=STATEMENT. |
| 35 |
# |
| 36 |
CREATE EVENT event1 |
| 37 |
ON SCHEDULE EVERY 2 SECOND |
| 38 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 39 |
ON COMPLETION NOT PRESERVE |
| 40 |
DO BEGIN |
| 41 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 42 |
DROP TEMPORARY TABLE temp1; |
| 43 |
END;| |
| 44 |
include/show_binlog_events.inc |
| 45 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 46 |
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1 |
| 47 |
ON SCHEDULE EVERY 2 SECOND |
| 48 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 49 |
ON COMPLETION NOT PRESERVE |
| 50 |
DO BEGIN |
| 51 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 52 |
DROP TEMPORARY TABLE temp1; |
| 53 |
END |
| 54 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT) |
| 55 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `temp1` /* generated by server */ |
| 56 |
CREATE TABLE t1 (i INT); |
| 57 |
# |
| 58 |
# Verify that CREATE TEMPORARY TABLE in a MULTI STMTs EVENT |
| 59 |
# is written into binlog after executing the event when |
| 60 |
# @@session.binlog_format=STATEMENT. |
| 61 |
# |
| 62 |
CREATE EVENT event1 |
| 63 |
ON SCHEDULE EVERY 2 SECOND |
| 64 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 65 |
ON COMPLETION NOT PRESERVE |
| 66 |
DO BEGIN |
| 67 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 68 |
INSERT INTO temp1 VALUES (1); |
| 69 |
INSERT INTO t1 VALUES (2); |
| 70 |
END;| |
| 71 |
include/show_binlog_events.inc |
| 72 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 73 |
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT event1 |
| 74 |
ON SCHEDULE EVERY 2 SECOND |
| 75 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 76 |
ON COMPLETION NOT PRESERVE |
| 77 |
DO BEGIN |
| 78 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 79 |
INSERT INTO temp1 VALUES (1); |
| 80 |
INSERT INTO t1 VALUES (2); |
| 81 |
END |
| 82 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT) |
| 83 |
master-bin.000001 # Query # # BEGIN |
| 84 |
master-bin.000001 # Query # # use `test`; INSERT INTO temp1 VALUES (1) |
| 85 |
master-bin.000001 # Query # # COMMIT |
| 86 |
master-bin.000001 # Query # # BEGIN |
| 87 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) |
| 88 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 89 |
include/sync_slave_sql_with_master.inc |
| 90 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 91 |
[connection master] |
| 92 |
# |
| 93 |
# Verify that DROP TEMPORARY TABLE in a MULTI STMTs EVENT |
| 94 |
# is written into binlog after executing the event when |
| 95 |
# @@session.binlog_format=STATEMENT. |
| 96 |
# |
| 97 |
CREATE EVENT event1 |
| 98 |
ON SCHEDULE EVERY 2 SECOND |
| 99 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 100 |
ON COMPLETION NOT PRESERVE |
| 101 |
DO BEGIN |
| 102 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 103 |
INSERT INTO temp1 VALUES (1); |
| 104 |
DROP TEMPORARY TABLE temp1; |
| 105 |
INSERT INTO t1 VALUES (4); |
| 106 |
END;| |
| 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`; CREATE DEFINER=`root`@`localhost` EVENT event1 |
| 110 |
ON SCHEDULE EVERY 2 SECOND |
| 111 |
STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND |
| 112 |
ON COMPLETION NOT PRESERVE |
| 113 |
DO BEGIN |
| 114 |
CREATE TEMPORARY TABLE temp1 (i INT); |
| 115 |
INSERT INTO temp1 VALUES (1); |
| 116 |
DROP TEMPORARY TABLE temp1; |
| 117 |
INSERT INTO t1 VALUES (4); |
| 118 |
END |
| 119 |
master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE temp1 (i INT) |
| 120 |
master-bin.000001 # Query # # BEGIN |
| 121 |
master-bin.000001 # Query # # use `test`; INSERT INTO temp1 VALUES (1) |
| 122 |
master-bin.000001 # Query # # COMMIT |
| 123 |
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `temp1` /* generated by server */ |
| 124 |
master-bin.000001 # Query # # BEGIN |
| 125 |
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4) |
| 126 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 127 |
include/sync_slave_sql_with_master.inc |
| 128 |
include/assert.inc [Replica_open_temp_tables shall be 0] |
| 129 |
[connection master] |
| 130 |
DROP TABLE t1; |
| 131 |
include/rpl_end.inc |