Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_drop_temp_gtid.result

raw
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 # Initial setup
7 [connection master]
8 CREATE TABLE t1 (c1 INT) ENGINE=InnoDB;
9 CREATE TEMPORARY TABLE temp_t1 (c1 INT) ENGINE=InnoDB;
10 # Insert the data in the master
11 BEGIN;
12 INSERT INTO temp_t1 VALUES (1);
13 COMMIT;
14 BEGIN;
15 INSERT INTO t1 VALUES ((SELECT COUNT(*) FROM temp_t1));
16 COMMIT;
17 include/sync_slave_sql_with_master.inc
18 [connection slave]
19 # Stop the IO thread
20 include/stop_slave_io.inc
21 Warnings:
22 Warning 3022 This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
23 # Restart IO thread
24 include/start_slave_io.inc
25 # Do one more insert on master and then sync slave with master
26 [connection master]
27 BEGIN;
28 INSERT INTO t1 VALUES ((SELECT COUNT(*) FROM temp_t1));
29 COMMIT;
30 include/sync_slave_sql_with_master.inc
31 # Now compare master and slave's t1 table data
32 [connection master]
33 include/diff_tables.inc [master:t1, slave:t1]
34 # Cleanup
35 [connection master]
36 DROP TABLE t1, temp_t1;
37 include/rpl_end.inc