summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/t/rpl_loaddatalocal.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_loaddatalocal.test')
-rw-r--r--mysql-test/suite/rpl/t/rpl_loaddatalocal.test14
1 files changed, 0 insertions, 14 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_loaddatalocal.test b/mysql-test/suite/rpl/t/rpl_loaddatalocal.test
index 30c9ff1e9e2..d3a5c9f7cc6 100644
--- a/mysql-test/suite/rpl/t/rpl_loaddatalocal.test
+++ b/mysql-test/suite/rpl/t/rpl_loaddatalocal.test
@@ -67,7 +67,6 @@ sync_with_master;
#
--echo ==== Bug22504 Initialize ====
---echo [on master]
--connection master
SET sql_mode='ignore_space';
@@ -81,17 +80,14 @@ eval load data local infile '$MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' i
--remove_file $MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile
SELECT * FROM t1 ORDER BY a;
---echo [on slave]
sync_slave_with_master;
SELECT * FROM t1 ORDER BY a;
--echo ==== Clean up ====
---echo [on master]
connection master;
DROP TABLE t1;
---echo [on slave]
sync_slave_with_master;
--echo
@@ -99,7 +95,6 @@ sync_slave_with_master;
--echo "return wrong query string when parse 'load data infile' sql statement"
--echo
---echo [master]
connection master;
let $MYSQLD_DATADIR= `select @@datadir`;
SELECT @@SESSION.sql_mode INTO @old_mode;
@@ -148,7 +143,6 @@ SET sql_mode='PIPES_AS_CONCAT,ANSI_QUOTES,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIE
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
eval LOAD DATA LOCAL INFILE '$MYSQLD_DATADIR/bug43746.sql' INTO TABLE t1;
---echo [slave]
sync_slave_with_master;
--echo
@@ -156,7 +150,6 @@ sync_slave_with_master;
--echo "LOAD DATA LOCAL INFILE not executed on slave with SBR"
--echo
---echo [master]
connection master;
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
@@ -168,12 +161,10 @@ eval LOAD DATA LOCAL INFILE '$MYSQLD_DATADIR/bug59267.sql' INTO TABLE t1;
SELECT 'Master', COUNT(*) FROM t1;
---echo [slave]
--sync_slave_with_master
SELECT 'Slave', COUNT(*) FROM t1;
# cleanup
---echo [master]
connection master;
--remove_file $MYSQLD_DATADIR/bug43746.sql
@@ -182,7 +173,6 @@ connection master;
DROP TABLE t1;
SET SESSION sql_mode=@old_mode;
---echo [slave]
sync_slave_with_master;
connection master;
@@ -192,7 +182,6 @@ connection master;
--echo "statement improperly replicated crashes slave sql thread"
--echo
---echo [master]
connection master;
let $MYSQLD_DATADIR= `select @@datadir`;
@@ -218,20 +207,17 @@ SELECT * FROM t1;
sleep 1;
---echo [slave]
sync_slave_with_master;
SELECT * FROM t1;
--remove_file $MYSQLD_DATADIR/bug60580.csv
---echo [master]
connection master;
DROP VIEW v1;
DROP TABLE t1, t2, t3;
---echo [slave]
sync_slave_with_master;
connection master;