Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.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 include/rpl_reset.inc
10 ==== Case 1A: Transaction filtered out ====
11 include/gtid_step_reset.inc
12 CREATE TABLE t_ignore(id INT);
13 INSERT INTO t_ignore VALUES (1);
14 DROP TABLE t_ignore;
15 CREATE TABLE t_ignore_wild(id INT);
16 INSERT INTO t_ignore_wild VALUES (1);
17 DROP TABLE t_ignore_wild;
18 include/gtid_step_assert.inc [count=6, only_count=0]
19 include/rpl_sync.inc
20 ==== Case 1B: CREATE/ALTER/DROP TEMPORARY filtered out ====
21 CREATE TEMPORARY TABLE t_ignore(a INT);
22 ALTER TABLE t_ignore ADD COLUMN b INT;
23 INSERT INTO t_ignore VALUES (1, 2);
24 DROP TEMPORARY TABLE t_ignore;
25 CREATE TEMPORARY TABLE t_ignore_wild(a INT);
26 ALTER TABLE t_ignore_wild ADD COLUMN b INT;
27 INSERT INTO t_ignore_wild VALUES (1, 2);
28 DROP TEMPORARY TABLE t_ignore_wild;
29 include/gtid_step_assert.inc [count=0, only_count=0]
30 include/rpl_sync.inc
31 ==== Case 1C: database filters on slave applier ====
32 include/gtid_step_reset.inc
33 CREATE DATABASE db_ignore;
34 USE db_ignore;
35 CREATE TABLE t1 (a INT);
36 INSERT INTO t1 VALUES (1);
37 USE test;
38 include/gtid_step_assert.inc [count=3, only_count=0]
39 include/rpl_sync.inc
40 include/assert.inc [db_ignore should not be created on slave]
41 include/assert.inc [db_ignore should not be created on second slave]
42 DROP DATABASE db_ignore;
43 include/rpl_sync.inc
44 ==== Case 1D: database filters on slave binary log ====
45 include/gtid_step_reset.inc
46 CREATE DATABASE db_binlog_ignore;
47 USE db_binlog_ignore;
48 CREATE TABLE t1 (a INT);
49 INSERT INTO t1 VALUES (1);
50 USE test;
51 include/gtid_step_assert.inc [count=3, only_count=0]
52 include/rpl_sync.inc
53 include/assert.inc [db_binlog_ignore should not be created on slave]
54 include/assert.inc [db_binlog_ignore should not be created on second slave]
55 DROP DATABASE db_binlog_ignore;
56 include/rpl_sync.inc
57 ==== Case 2A: temp table transaction not logged in row format ====
58 ---- Initialize ----
59 SET @save.binlog_format= @@global.binlog_format;
60 Warnings:
61 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
62 include/stop_slave_sql.inc
63 SET @@global.binlog_format= 'row';
64 Warnings:
65 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
66 include/start_slave_sql.inc
67 ---- Test ----
68 include/gtid_step_reset.inc
69 CREATE TEMPORARY TABLE t2 (a INT);
70 ALTER TABLE t2 ADD COLUMN b INT;
71 INSERT INTO t2 VALUES (1, 2);
72 include/gtid_step_assert.inc [count=0, only_count=0]
73 include/rpl_sync.inc
74 ---- Clean up ----
75 DROP TEMPORARY TABLE t2;
76 include/rpl_sync.inc
77 include/stop_slave_sql.inc
78 SET @@global.binlog_format= @save.binlog_format;
79 Warnings:
80 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
81 ==== Case 2B: transaction with no effect not logged in row format ====
82 ---- Initialize ----
83 SET @save.binlog_format= @@global.binlog_format;
84 Warnings:
85 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
86 SET @@global.binlog_format= 'row';
87 Warnings:
88 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
89 include/start_slave_sql.inc
90 SET @@session.binlog_format= statement;
91 Warnings:
92 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
93 CREATE TABLE t1(id INT) ENGINE = InnoDB;
94 include/rpl_sync.inc
95 INSERT INTO t1 VALUES (0);
96 ---- Test ----
97 UPDATE t1 SET id= 1 WHERE id = 0;
98 include/rpl_sync.inc
99 ---- Clean up ----
100 DROP TABLE t1;
101 include/rpl_sync.inc
102 include/stop_slave_sql.inc
103 SET @@global.binlog_format= @save.binlog_format;
104 Warnings:
105 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
106 include/start_slave_sql.inc
107 ==== Case 3: explicit empty transaction on master ====
108 SET @@SESSION.binlog_format= 'row';
109 Warnings:
110 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
111 include/gtid_step_reset.inc
112 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
113 COMMIT;
114 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
115 include/gtid_step_assert.inc [count=1, only_count=1]
116 CREATE TABLE t1 (a INT);
117 CREATE PROCEDURE p1()
118 BEGIN
119 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
120 START TRANSACTION;
121 COMMIT;
122 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
123 START TRANSACTION;
124 COMMIT;
125 END|
126 include/gtid_step_assert.inc [count=2, only_count=1]
127 CALL p1();
128 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
129 include/gtid_step_assert.inc [count=2, only_count=1]
130 DROP TABLE t1;
131 include/rpl_sync.inc
132 ==== Case 4: Nothing logged for ROLLBACK transactions ====
133 ---- Initialize ----
134 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
135 ---- Test ----
136 include/gtid_step_reset.inc
137 DROP TABLE t2;
138 ERROR 42S02: Unknown table 'test.t2'
139 INSERT INTO t1 VALUES (1, 1);
140 ERROR 21S01: Column count doesn't match value count at row 1
141 BEGIN;
142 INSERT INTO t1 VALUES (2);
143 ROLLBACK;
144 include/gtid_step_assert.inc [count=0, only_count=0]
145 ---- Clean Up ----
146 DROP TABLE t1;
147 DROP PROCEDURE p1;
148 include/rpl_end.inc