Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 include/rpl_default_connections.inc
9 #
10 # First part
11 #
12 [connection master]
13 CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB;
14 CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM;
15 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
16 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
17 # Error cases ER_BAD_TABLE_ERROR.
18 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1';
19 ## Expecting error ER_BAD_TABLE_ERROR after the statement
20 DROP TABLE trans_t1, non_trans_t1, non_existent;
21 ERROR 42S02: Unknown table 'test.non_existent'
22 ROLLBACK;
23 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:2';
24 ## Expecting error ER_BAD_TABLE_ERROR after the statement
25 DROP TABLE trans_t1, non_existent;
26 ERROR 42S02: Unknown table 'test.non_existent'
27 ROLLBACK;
28 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:3';
29 ## Expecting error ER_BAD_TABLE_ERROR after the statement
30 DROP TABLE non_trans_t1, non_existent;
31 ERROR 42S02: Unknown table 'test.non_existent'
32 ROLLBACK;
33 # Non-error cases
34 SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:4';
35 DROP TABLE trans_t1, non_trans_t1;
36 SET GTID_NEXT= AUTOMATIC;
37 CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB;
38 #
39 # Second part
40 #
41 CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=MyISAM;
42 DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_non_trans_t1;
43 include/sync_slave_sql_with_master.inc
44 [connection master]
45 CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=InnoDB;
46 DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_trans_t1;
47 include/sync_slave_sql_with_master.inc
48 #
49 # Third part
50 #
51 [connection master]
52 SET SESSION sql_log_bin= 0;
53 call mtr.add_suppression("Error: table .* does not exist in the InnoDB internal");
54 SET SESSION sql_log_bin= 1;
55 CREATE DATABASE test2;
56 CREATE DATABASE test3;
57 use test;
58 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
59 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
60 USE test2;
61 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
62 USE test3;
63 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
64 CREATE TEMPORARY TABLE temp_trans_t2 (c1 INT) ENGINE=InnoDB;
65 [connection master1]
66 use test;
67 CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB;
68 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
69 USE test2;
70 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
71 USE test3;
72 CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM;
73 CREATE TEMPORARY TABLE temp_non_trans_t2 (c1 INT) ENGINE=MyISAM;
74 include/sync_slave_sql_with_master.inc
75 include/stop_slave_io.inc
76 include/rpl_stop_server.inc [server_number=1]
77 include/rpl_start_server.inc [server_number=1]
78 [connection slave]
79 include/start_slave_io.inc
80 [connection master]
81 include/sync_slave_io_with_master.inc
82 include/assert.inc [Replica_open_temp_tables should be 0]
83 [connection master]
84 USE test;
85 DROP TABLE trans_t1;
86 DROP DATABASE test2;
87 DROP DATABASE test3;
88 include/rpl_end.inc