bzr commit into mysql-5.1 branch (mats:2670)

[Mats Kindahl]

#At file:///home/bzr/merges/merge-5.1-rpl/

 2670 Mats Kindahl	2008-10-07
      Post-merge fixes.
modified:
  mysql-test/extra/rpl_tests/rpl_log.test
  mysql-test/suite/rpl/r/rpl_row_log.result
  mysql-test/suite/rpl/r/rpl_row_log_innodb.result
  mysql-test/suite/rpl/r/rpl_stm_log.result
  mysql-test/suite/rpl/t/rpl_binlog_query_filter_rules.test
  mysql-test/suite/rpl/t/rpl_misc_functions.test

per-file messages:
  mysql-test/extra/rpl_tests/rpl_log.test
    Removing extreneous start slave.
    Added missing drop of table t1.
  mysql-test/suite/rpl/t/rpl_binlog_query_filter_rules.test
    Replaced $MYSQLTEST_VARDIR/log with $MYSQLD_DATADIR
  mysql-test/suite/rpl/t/rpl_misc_functions.test
    Using temporary table instead to remove need for drop table.
=== modified file 'mysql-test/extra/rpl_tests/rpl_log.test'
--- a/mysql-test/extra/rpl_tests/rpl_log.test	2008-10-06 08:27:36 +0000
+++ b/mysql-test/extra/rpl_tests/rpl_log.test	2008-10-07 08:25:12 +0000
@@ -70,11 +70,7 @@ eval create table t3 (a int)ENGINE=$engi
 connection master;
 select * from t1 order by 1 asc;
 
-save_master_pos;
-connection slave;
-source include/start_slave.inc;
-
-sync_with_master;
+sync_slave_with_master;
 #check t1 on slave to ensure whether it's identical with on master
 select * from t1 order by 1 asc;
 flush logs;
@@ -142,4 +138,4 @@ drop table t1;
 # End of 4.1 tests
 
 sync_slave_with_master;
-
+drop table t1;

=== modified file 'mysql-test/suite/rpl/r/rpl_row_log.result'
--- a/mysql-test/suite/rpl/r/rpl_row_log.result	2008-10-06 08:27:36 +0000
+++ b/mysql-test/suite/rpl/r/rpl_row_log.result	2008-10-07 08:25:12 +0000
@@ -113,7 +113,6 @@ Aberdeen
 Abernathy
 aberrant
 aberration
-include/start_slave.inc
 select * from t1 order by 1 asc;
 word
 Aarhus
@@ -306,3 +305,4 @@ a	b
 5	1
 6	1
 drop table t1;
+drop table t1;

=== modified file 'mysql-test/suite/rpl/r/rpl_row_log_innodb.result'
--- a/mysql-test/suite/rpl/r/rpl_row_log_innodb.result	2008-10-06 08:27:36 +0000
+++ b/mysql-test/suite/rpl/r/rpl_row_log_innodb.result	2008-10-07 08:25:12 +0000
@@ -113,7 +113,6 @@ Aberdeen
 Abernathy
 aberrant
 aberration
-include/start_slave.inc
 select * from t1 order by 1 asc;
 word
 Aarhus
@@ -306,3 +305,4 @@ a	b
 5	1
 6	1
 drop table t1;
+drop table t1;

=== modified file 'mysql-test/suite/rpl/r/rpl_stm_log.result'
--- a/mysql-test/suite/rpl/r/rpl_stm_log.result	2008-10-06 08:27:36 +0000
+++ b/mysql-test/suite/rpl/r/rpl_stm_log.result	2008-10-07 08:25:12 +0000
@@ -109,7 +109,6 @@ Aberdeen
 Abernathy
 aberrant
 aberration
-include/start_slave.inc
 select * from t1 order by 1 asc;
 word
 Aarhus
@@ -287,3 +286,4 @@ a	b
 5	1
 6	1
 drop table t1;
+drop table t1;

=== modified file 'mysql-test/suite/rpl/t/rpl_binlog_query_filter_rules.test'
--- a/mysql-test/suite/rpl/t/rpl_binlog_query_filter_rules.test	2008-09-03 10:01:18 +0000
+++ b/mysql-test/suite/rpl/t/rpl_binlog_query_filter_rules.test	2008-10-07 08:25:12 +0000
@@ -16,8 +16,9 @@ reset master;
 create table t1 (a int);
 insert into t1 values (1);
 
+let $MYSQLD_DATADIR= `select @@datadir`;
 flush logs;
---exec $MYSQL_BINLOG  $MYSQLTEST_VARDIR/log/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/bug36099.sql
+--exec $MYSQL_BINLOG  $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/bug36099.sql
 
 drop table t1;
 --exec $MYSQL -e "source $MYSQLTEST_VARDIR/tmp/bug36099.sql"

=== modified file 'mysql-test/suite/rpl/t/rpl_misc_functions.test'
--- a/mysql-test/suite/rpl/t/rpl_misc_functions.test	2007-12-12 17:19:24 +0000
+++ b/mysql-test/suite/rpl/t/rpl_misc_functions.test	2008-10-07 08:25:12 +0000
@@ -23,7 +23,7 @@ insert into t1 values(4, connection_id()
 select * into outfile 'rpl_misc_functions.outfile' from t1;
 let $MYSQLD_DATADIR= `select @@datadir`;
 sync_slave_with_master;
-create table t2 like t1; 
+create temporary table t2 like t1; 
 # read the values from the master table
 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
 eval load data local infile '$MYSQLD_DATADIR/test/rpl_misc_functions.outfile' into table t2;