~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
ImportĀ upstreamĀ versionĀ 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
15
15
CREATE TABLE t1 (a INT, b LONG);
16
16
INSERT INTO t1 VALUES (1,1), (2,2);
17
17
INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
18
 
let $VERSION=`select version()`;
19
 
--replace_result $VERSION VERSION
20
 
--replace_column 2 # 5 #
21
 
--replace_regex /table_id: [0-9]+/table_id: #/
22
18
# Different number of binlog events are generated by different engines
23
19
--disable_result_log
24
 
SHOW BINLOG EVENTS;
 
20
source include/show_binlog_events.inc;
25
21
--enable_result_log
26
22
sync_slave_with_master;
27
23
--echo **** On Slave ****
28
 
--replace_result $MASTER_MYPORT MASTER_PORT
29
 
--replace_column 1 # 7 # 8 # 9 # 22 # 23 # 33 #
30
 
--query_vertical SHOW SLAVE STATUS
31
 
--replace_result $VERSION VERSION
32
 
--replace_column 2 # 5 #
33
 
--replace_regex /table_id: [0-9]+/table_id: #/
 
24
source include/show_binlog_events.inc;
 
25
 
34
26
# Different number of binlog events are generated by different engines
35
27
--disable_result_log
36
 
SHOW BINLOG EVENTS;
 
28
source include/show_binlog_events.inc;
37
29
--enable_result_log
38
30
--exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql
39
31
--exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql