Debian Codegraph @

mysql-test/suite/rpl/t/rpl_stm_create_drop_temporary_in_event.test

raw
1 # ==== Purpose ====
2 #
3 # Verify that CREATE/DROP TEMPORARY TABLE in an EVENT is written into binlog
4 # after executing the event when @@session.binlog_format=STATEMENT.
5 #
6 # ==== Implementation ====
7 #
8 # 1. SET @@session.binlog_format=STATEMENT;
9 # 2. Verify that CREATE TEMPORARY TABLE in a single STMT EVENT
10 # is written into binlog after executing the event when
11 # @@session.binlog_format=STATEMENT.
12 # 3. Verify that DROP TEMPORARY TABLE in a single STMT EVENT
13 # is written into binlog after executing the event when
14 # @@session.binlog_format=STATEMENT.
15 # 4. Verify that DROP TEMPORARY TABLE in a MULTI STMTs EVENT
16 # is written into binlog after executing the event when
17 # @@session.binlog_format=STATEMENT.
18 # 5. Verify that DROP TEMPORARY TABLE in a MULTI STMTs EVENT
19 # is written into binlog after executing the event when
20 # @@session.binlog_format=STATEMENT.
21 #
22 # ==== References ====
23 #
24 # WL#8872: Allow CREATE TEMPORARY/DROP TEMPORARY in transaction when GTID_MODE=ON in RBR
25
26 --source include/have_binlog_format_statement.inc
27 --source include/set_privilege_checks_user_as_system_user.inc
28 --source include/master-slave.inc
29
30 --let $naptime= 4
31 --echo #
32 --echo # Verify that CREATE TEMPORARY TABLE in a single STMT EVENT
33 --echo # is written into binlog after executing the event when
34 --echo # @@session.binlog_format=STATEMENT.
35 --echo #
36 --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1)
37 DELIMITER |;
38 CREATE EVENT event1
39 ON SCHEDULE EVERY 2 SECOND
40 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
41 ON COMPLETION NOT PRESERVE
42 DO BEGIN
43 CREATE TEMPORARY TABLE temp1 (i INT);
44 END;|
45 DELIMITER ;|
46
47 --sleep $naptime
48 --let $binlog_start= $saved_master_pos
49 # print the top five events.
50 --let $binlog_limit= 5
51 --source include/show_binlog_events.inc
52
53 --source include/sync_slave_sql_with_master.inc
54 --let $var_value= query_get_value(SHOW STATUS LIKE 'Replica_open_temp_tables', Value, 1)
55 --let $assert_text= Replica_open_temp_tables shall be 0
56 --let $assert_cond= $var_value = 0
57 --source include/assert.inc
58
59 --source include/rpl_connection_master.inc
60 --echo #
61 --echo # Verify that DROP TEMPORARY TABLE in a single STMT EVENT
62 --echo # is written into binlog after executing the event when
63 --echo # @@session.binlog_format=STATEMENT.
64 --echo #
65 --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1)
66 DELIMITER |;
67 CREATE EVENT event1
68 ON SCHEDULE EVERY 2 SECOND
69 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
70 ON COMPLETION NOT PRESERVE
71 DO BEGIN
72 CREATE TEMPORARY TABLE temp1 (i INT);
73 DROP TEMPORARY TABLE temp1;
74 END;|
75 DELIMITER ;|
76
77 --sleep $naptime
78 --let $binlog_start= $saved_master_pos
79 # print the top six events.
80 --let $binlog_limit= 6
81 --source include/show_binlog_events.inc
82
83 CREATE TABLE t1 (i INT);
84 --echo #
85 --echo # Verify that CREATE TEMPORARY TABLE in a MULTI STMTs EVENT
86 --echo # is written into binlog after executing the event when
87 --echo # @@session.binlog_format=STATEMENT.
88 --echo #
89 --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1)
90 DELIMITER |;
91 CREATE EVENT event1
92 ON SCHEDULE EVERY 2 SECOND
93 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
94 ON COMPLETION NOT PRESERVE
95 DO BEGIN
96 CREATE TEMPORARY TABLE temp1 (i INT);
97 INSERT INTO temp1 VALUES (1);
98 INSERT INTO t1 VALUES (2);
99 END;|
100 DELIMITER ;|
101
102 --sleep $naptime
103 --let $binlog_start= $saved_master_pos
104 # print the top thirteen events.
105 --let $binlog_limit= 13
106 --source include/show_binlog_events.inc
107
108 --source include/sync_slave_sql_with_master.inc
109 --let $var_value= query_get_value(SHOW STATUS LIKE 'Replica_open_temp_tables', Value, 1)
110 --let $assert_text= Replica_open_temp_tables shall be 0
111 --let $assert_cond= $var_value = 0
112 --source include/assert.inc
113
114 --source include/rpl_connection_master.inc
115 --echo #
116 --echo # Verify that DROP TEMPORARY TABLE in a MULTI STMTs EVENT
117 --echo # is written into binlog after executing the event when
118 --echo # @@session.binlog_format=STATEMENT.
119 --echo #
120 --let $saved_master_pos=query_get_value('SHOW MASTER STATUS', Position, 1)
121 DELIMITER |;
122 CREATE EVENT event1
123 ON SCHEDULE EVERY 2 SECOND
124 STARTS NOW() ENDS NOW() + INTERVAL 1 SECOND
125 ON COMPLETION NOT PRESERVE
126 DO BEGIN
127 CREATE TEMPORARY TABLE temp1 (i INT);
128 INSERT INTO temp1 VALUES (1);
129 DROP TEMPORARY TABLE temp1;
130 INSERT INTO t1 VALUES (4);
131 END;|
132 DELIMITER ;|
133
134 --sleep $naptime
135 --let $binlog_start= $saved_master_pos
136 # print the top fourteen events.
137 --let $binlog_limit= 14
138 --source include/show_binlog_events.inc
139
140 --source include/sync_slave_sql_with_master.inc
141 --let $var_value= query_get_value(SHOW STATUS LIKE 'Replica_open_temp_tables', Value, 1)
142 --let $assert_text= Replica_open_temp_tables shall be 0
143 --let $assert_cond= $var_value = 0
144 --source include/assert.inc
145
146 # Cleanup
147 --source include/rpl_connection_master.inc
148 DROP TABLE t1;
149
150 --source include/rpl_end.inc