summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysqlbinlog_base64.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/mysqlbinlog_base64.test')
-rw-r--r--mysql-test/t/mysqlbinlog_base64.test102
1 files changed, 0 insertions, 102 deletions
diff --git a/mysql-test/t/mysqlbinlog_base64.test b/mysql-test/t/mysqlbinlog_base64.test
deleted file mode 100644
index 3d3444cea1c..00000000000
--- a/mysql-test/t/mysqlbinlog_base64.test
+++ /dev/null
@@ -1,102 +0,0 @@
--- source include/have_binlog_format_row.inc
-#
-# Reset master to cleanup binlog
-#
-reset master;
-
-#
-# Write different events to binlog
-#
-create table t1 (a int);
-insert into t1 values (1);
-insert into t1 values (2);
-insert into t1 values (3);
-update t1 set a=a+2 where a=2;
-update t1 set a=a+2 where a=3;
-
-create table t2 (word varchar(20));
-load data infile '../../std_data/words.dat' into table t2;
-
-#
-# Save binlog
-#
-let $MYSQLD_DATADIR=`select @@datadir`;
-flush logs;
---exec $MYSQL_BINLOG --hexdump $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog_base64.sql
-
-#
-# Clear database and restore from binlog
-#
-drop table t1;
-drop table t2;
---exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/mysqlbinlog_base64.sql
-
-#
-# Verify that all binlog events have been executed
-#
-select * from t1;
-select * from t2;
-
-#
-# Verify that events larger than the default IO_CACHE buffer
-# are handled correctly (BUG#25628).
-#
-flush logs;
-drop table t2;
-create table t2 (word varchar(20));
-load data infile '../../std_data/words.dat' into table t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-insert into t2 select * from t2;
-select count(*) from t2;
-
-flush logs;
---exec $MYSQL_BINLOG --hexdump $MYSQLD_DATADIR/master-bin.000003 > $MYSQLTEST_VARDIR/tmp/mysqlbinlog_base64.sql
---exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/mysqlbinlog_base64.sql
-
-#
-# Verify that all binlog events have been executed
-#
-select count(*) from t2;
-
-#
-# Test cleanup
-#
---remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog_base64.sql
-drop table t1;
-drop table t2;
-
-#
-# BUG#12354268
-#
-# This test verifies that using --start-position with DECODE-ROWS
-# does not make mysqlbinlog to output an error stating that it
-# does not contain any FD event.
-#
-
-RESET MASTER;
-USE test;
-SET @old_binlog_format= @@binlog_format;
-SET SESSION binlog_format=ROW;
-CREATE TABLE t1(c1 INT);
---let $master_binlog= query_get_value(SHOW MASTER STATUS, File, 1)
---let $master_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
---let $MYSQLD_DATADIR= `SELECT @@datadir`
-
-INSERT INTO t1 VALUES (1);
-
-FLUSH LOGS;
-
---disable_result_log
---exec $MYSQL_BINLOG --base64-output=DECODE-ROWS --start-position=$master_pos -v $MYSQLD_DATADIR/$master_binlog
---enable_result_log
-
-DROP TABLE t1;
-SET SESSION binlog_format= @old_binlog_format;
-RESET MASTER;