Debian Codegraph @

mysql-test/suite/binlog/t/binlog_parallel_replication_ddl.test

raw
1 # Check binlog properties of various DDL:s.
2 # Motivated by MDEV-27365.
3 #
4 --source include/have_log_bin.inc
5 --source include/have_binlog_format_mixed.inc
6
7 RESET MASTER;
8
9 # MDEV-27365 CREATE-or-REPLACE SEQUENCE bilogged without DDL flag
10 # Prove it is logged with the DDL flag.
11 CREATE OR REPLACE SEQUENCE s1;
12
13 # This one has been always correct.
14 DROP SEQUENCE s1;
15 FLUSH LOGS;
16
17 --let $MYSQLD_DATADIR= `select @@datadir`
18 --exec $MYSQL_BINLOG --base64-output=decode-rows $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
19
20 --let SEARCH_PATTERN= GTID [0-9]+-[0-9]+-[0-9]+
21 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
22 --source include/search_pattern_in_file.inc
23
24 --echo The same as above number of samples must be found:
25 --let SEARCH_PATTERN= GTID [0-9]+-[0-9]+-[0-9]+ ddl
26 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
27 --source include/search_pattern_in_file.inc
28 --remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog.sql
29
30 --echo End of the tests