mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
a64991df9d
This patch fixes two issues: First, it fixes test failure due to GTID List events having inconsistent ordering of domain ids. In particular, this patch ensures that a GTID list log event will have its GTIDs ordered by domain id (ascending) followed by sequence number (ascending). Second, it fixes an assert which could use an unintialized variable. Reviewed By: ============ Andrei Elkin <andrei.elkin@mariadb.com>
44 lines
1.2 KiB
Plaintext
44 lines
1.2 KiB
Plaintext
#
|
|
# Purpose:
|
|
# This test validates that GTIDs are ordered when mysqlbinlog outputs
|
|
# Gtid_list events.
|
|
#
|
|
# Methodology:
|
|
# Write multiple events to the binlog with different domain ids and server
|
|
# ids, and ensure that the Gtid_list event GTIDs are ordered first by domain id
|
|
# (ascending), and then sequence number (ascending).
|
|
#
|
|
# References:
|
|
# MDEV-4989: Support for GTID in mysqlbinlog
|
|
#
|
|
--source include/have_log_bin.inc
|
|
|
|
RESET MASTER;
|
|
SET @@session.gtid_domain_id= 0;
|
|
SET @@session.server_id= 1;
|
|
CREATE TABLE t1 (a int);
|
|
SET @@session.gtid_domain_id= 1;
|
|
SET @@session.server_id= 2;
|
|
CREATE TABLE t2 (a int);
|
|
SET @@session.server_id= 1;
|
|
INSERT INTO t2 VALUES (1);
|
|
SET @@session.gtid_domain_id= 2;
|
|
SET @@session.server_id= 3;
|
|
CREATE TABLE t3 (a int);
|
|
FLUSH LOGS;
|
|
FLUSH LOGS;
|
|
|
|
--let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 2)
|
|
--let $MYSQLD_DATADIR=`select @@datadir`
|
|
--let SEARCH_FILE=$MYSQLTEST_VARDIR/tmp/tmp_binlog.out
|
|
|
|
--echo # MYSQL_BINLOG MYSQLD_DATADIR/binlog_file > SEARCH_FILE
|
|
--exec $MYSQL_BINLOG $MYSQLD_DATADIR/$binlog_file > $SEARCH_FILE
|
|
|
|
--let SEARCH_PATTERN= Gtid list \[0-1-1,\n# 1-2-1,\n# 1-1-2,\n# 2-3-1\]
|
|
--source include/search_pattern_in_file.inc
|
|
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t3;
|