| 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; |