diff options
Diffstat (limited to 'mysql-test/t/mysqlbinlog2.test')
-rw-r--r-- | mysql-test/t/mysqlbinlog2.test | 187 |
1 files changed, 0 insertions, 187 deletions
diff --git a/mysql-test/t/mysqlbinlog2.test b/mysql-test/t/mysqlbinlog2.test deleted file mode 100644 index 740c4078f20..00000000000 --- a/mysql-test/t/mysqlbinlog2.test +++ /dev/null @@ -1,187 +0,0 @@ -# Test for the new options --start-datetime, stop-datetime, -# and a few others. - -# TODO: Need to look at making row based version once new binlog client is complete. --- source include/have_binlog_format_mixed_or_statement.inc --- source include/binlog_start_pos.inc - ---disable_warnings -drop table if exists t1; ---enable_warnings -reset master; - -# We need this for getting fixed timestamps inside of this test. -# I use a date in the future to keep a growing timestamp along the -# binlog (including the Start_log_event). This test will work -# unchanged everywhere, because mysql-test-run has fixed TZ, which it -# exports (so mysqlbinlog has same fixed TZ). -set @a=UNIX_TIMESTAMP("2020-01-21 15:32:22"); -set timestamp=@a; -create table t1 (a int auto_increment not null primary key, b char(3)); -insert into t1 values(null, "a"); -insert into t1 values(null, "b"); -set timestamp=@a+2; ---let $binlog_pos_760=query_get_value(SHOW MASTER STATUS, Position, 1) -insert into t1 values(null, "c"); ---let $binlog_pos_951=query_get_value(SHOW BINLOG EVENTS in 'master-bin.000001' from $binlog_pos_760, Pos, 4) -set timestamp=@a+4; -insert into t1 values(null, "d"); -insert into t1 values(null, "e"); - -flush logs; -set timestamp=@a+1; # this could happen on a slave -insert into t1 values(null, "f"); ---let $binlog_pos_135=query_get_value(SHOW BINLOG EVENTS in 'master-bin.000002', Pos, 3) ---let $binlog_pos_203=query_get_value(SHOW BINLOG EVENTS in 'master-bin.000002', Pos, 4) - -# delimiters are for easier debugging in future - ---disable_query_log -select "--- Local --" as ""; ---enable_query_log - -# -# We should use --short-form everywhere because in other case output will -# be time dependent (the Start events). Better than nothing. -# -let $MYSQLD_DATADIR= `select @@datadir`; ---exec $MYSQL_BINLOG --short-form --base64-output=never $MYSQLD_DATADIR/master-bin.000001 - ---disable_query_log -select "--- offset --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form --offset=2 $MYSQLD_DATADIR/master-bin.000001 ---disable_query_log -select "--- start-position --" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos $MYSQLD_DATADIR/master-bin.000001 ---disable_query_log -select "--- stop-position --" as ""; ---enable_query_log -let $stop_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --stop-position=$stop_pos $MYSQLD_DATADIR/master-bin.000001 ---disable_query_log -select "--- start and stop positions ---" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; -let $stop_pos= `select @binlog_start_pos + 770`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos --stop-position=$stop_pos $MYSQLD_DATADIR/master-bin.000001 ---disable_query_log -select "--- start-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--start-datetime=2020-01-21 15:32:24" $MYSQLD_DATADIR/master-bin.000001 ---disable_query_log -select "--- stop-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--stop-datetime=2020-01-21 15:32:24" $MYSQLD_DATADIR/master-bin.000001 - ---disable_query_log -select "--- Local with 2 binlogs on command line --" as ""; ---enable_query_log - -# This is to verify that some options apply only to first, or last binlog - -flush logs; ---exec $MYSQL_BINLOG --short-form $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 - ---disable_query_log -select "--- offset --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form --offset=2 $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 ---disable_query_log -select "--- start-position --" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 ---disable_query_log -select "--- stop-position --" as ""; ---enable_query_log -let $stop_pos= `select @binlog_start_pos + 69`; ---exec $MYSQL_BINLOG --short-form --stop-position=$stop_pos $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 ---disable_query_log -select "--- start-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--start-datetime=2020-01-21 15:32:24" $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 ---disable_query_log -select "--- stop-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--stop-datetime=2020-01-21 15:32:24" $MYSQLD_DATADIR/master-bin.000001 $MYSQLD_DATADIR/master-bin.000002 - ---disable_query_log -select "--- Remote --" as ""; ---enable_query_log - ---exec $MYSQL_BINLOG --short-form --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 - ---disable_query_log -select "--- offset --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form --offset=2 --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 ---disable_query_log -select "--- start-position --" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 ---disable_query_log -select "--- stop-position --" as ""; ---enable_query_log -let $stop_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --stop-position=$stop_pos --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 ---disable_query_log -select "--- start and stop positions ---" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; -let $stop_pos= `select @binlog_start_pos + 770`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos --stop-position $stop_pos --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 ---disable_query_log -select "--- start-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--start-datetime=2020-01-21 15:32:24" --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 ---disable_query_log -select "--- stop-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--stop-datetime=2020-01-21 15:32:24" --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 - ---disable_query_log -select "--- Remote with 2 binlogs on command line --" as ""; ---enable_query_log - ---exec $MYSQL_BINLOG --short-form --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 - ---disable_query_log -select "--- offset --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form --offset=2 --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 ---disable_query_log -select "--- start-position --" as ""; ---enable_query_log -let $start_pos= `select @binlog_start_pos + 653`; ---exec $MYSQL_BINLOG --short-form --start-position=$start_pos --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 ---disable_query_log -select "--- stop-position --" as ""; ---enable_query_log -let $stop_pos= `select @binlog_start_pos + 28`; ---exec $MYSQL_BINLOG --short-form --stop-position=$stop_pos --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 ---disable_query_log -select "--- start-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--start-datetime=20200121153224" --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 ---disable_query_log -select "--- stop-datetime --" as ""; ---enable_query_log ---exec $MYSQL_BINLOG --short-form "--stop-datetime=2020/01/21 15@32@24" --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT master-bin.000001 master-bin.000002 - ---disable_query_log -select "--- to-last-log --" as ""; ---enable_query_log - ---exec $MYSQL_BINLOG --short-form --read-from-remote-server --user=root --host=127.0.0.1 --port=$MASTER_MYPORT --to-last-log master-bin.000001 - -# clean up ---disable_query_log -select "--- end of test --" as ""; ---enable_query_log -drop table t1; - -# End of 4.1 tests |