Debian Codegraph @

mysql-test/suite/engines/funcs/t/rpl_000015.test

raw
1 #####################
2 # Change Author: JBM
3 # Change Date: 2006-01-17
4 # Change: added order by in select
5 #####################
6 --source include/master-slave.inc
7
8 reset master;
9 show master status;
10 save_master_pos;
11 connection slave;
12 --source include/stop_slave.inc
13 reset slave;
14 --let $status_items= Slave_IO_Running, Slave_SQL_Running, Last_SQL_Errno, Last_SQL_Error, Exec_Master_Log_Pos
15 --source include/show_slave_status.inc
16
17 change master to master_host='127.0.0.1';
18 # The following needs to be cleaned up when change master is fixed
19 --source include/show_slave_status.inc
20 --replace_result $MASTER_MYPORT MASTER_PORT
21 eval change master to master_host='127.0.0.1',master_user='root',
22 master_password='',master_port=$MASTER_MYPORT;
23 --source include/start_slave.inc
24 sync_with_master;
25 --source include/show_slave_status.inc
26
27 connection master;
28
29 create table t1 (n int, PRIMARY KEY(n));
30 insert into t1 values (10),(45),(90);
31 --sync_slave_with_master
32
33 SELECT * FROM t1 ORDER BY n;
34 connection master;
35 SELECT * FROM t1 ORDER BY n;
36 drop table t1;
37 --sync_slave_with_master
38 --source include/rpl_end.inc