Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_log_status_with_ongoing_bgc.result

raw
1 #
2 # 1. Initial setup
3 RESET MASTER;
4 CREATE TABLE t1(c1 INT);
5 INSERT INTO t1 VALUES(1);
6 INSERT INTO t1 VALUES(2);
7 FLUSH BINARY LOGS;
8 #
9 # 2. Execute an INSERT query and pause after it acquires commit_lock
10 [START] INSERT INTO t1 VALUES (3);
11 #
12 # 3. Execute a SELECT query on performance_schema.log_status and wait
13 # until it is waiting for MYSQL_BIN_LOG::prep_xids_cond
14 SELECT REPLACE(LOCAL->"$.gtid_executed", '"', '') INTO @ps_log_status FROM performance_schema.log_status;
15 #
16 # 4. Resume the INSERT query
17 [END] INSERT INTO t1 VALUES (3);
18 #
19 # 5. Let the SELECT query complete
20 #
21 # 6. Verify that the correct GTID set is received from
22 # performance_schema.log_status
23 include/assert.inc [Gtid_executed is updated with GTID 4]
24 #
25 # 7. Cleanup
26 DROP TABLE t1;