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