rpl_gtid/t/rpl_gtids_table.test

6 # Verify that we can store gtids into gtid_executed table for transactions
21 SHOW CREATE TABLE mysql.gtid_executed;
25 --echo # global.gtid_executed and is stored into gtid_executed table on
38 --echo # Store gtids MASTER_UUID:1:3 in gtid_executed table on binlog rotation
41 SELECT * FROM mysql.gtid_executed;
44 --echo # Verify that these gtids can be reported from global.gtid_executed and
45 --echo # are stored into gtid_executed table on next rotation for normal DDLs.
53 --echo # Store gtids MASTER_UUID:1-4 in gtid_executed table on binlog rotation
59 SELECT * FROM mysql.gtid_executed;
62 --echo # Verify that these gtids can be reported from global.gtid_executed
63 --echo # and are stored into gtid_executed table for compound statement with
93 --echo # Store gtids MASTER_UUID:1-8 in gtid_executed table on binlog rotation
99 SELECT * FROM mysql.gtid_executed;
103 --echo # global.gtid_executed correctly and are stored into
104 --echo # gtid_executed table on next binlog rotation.
113 --echo # global.gtid_executed correctly and is stored into gtid_executed
129 --echo # Store gtids MASTER_UUID:1-11 in gtid_executed table on binlog rotation
132 SELECT * FROM mysql.gtid_executed;
136 --echo # global.gtid_executed and is not stored into gtid_executed table
146 --echo # Store gtids MASTER_UUID:1-11 in gtid_executed table on binlog rotation
150 SELECT * FROM mysql.gtid_executed;
162 --echo # already in global.gtid_executed, although not in gtid_executed table.
174 --echo # The gtid_executed table would only have GTID for Innodb transactions
177 #SELECT * FROM mysql.gtid_executed;
179 --echo # Store gtids MASTER_UUID:1-11 in gtid_executed table on binlog rotation
184 SELECT * FROM mysql.gtid_executed;
188 --echo # global.gtid_executed immediately and stored into gtid_executed table
198 --echo # Store gtids MASTER_UUID:1-11:17 in gtid_executed table
204 SELECT * FROM mysql.gtid_executed;
218 --echo # into gtid_executed table on next binlog rotation.
225 --echo # in gtid_executed table on binlog rotation.
229 --eval SELECT * FROM mysql.gtid_executed where source_uuid="$master_uuid"
231 --eval SELECT * FROM mysql.gtid_executed where source_uuid="$slave_uuid"