1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
--echo Populating master server
CREATE TABLE t1 (a int not null auto_increment, primary key(a));
INSERT INTO t1 VALUES (),(),();
SELECT * FROM t1;
--echo Connecting to slave...
connect (slave_con,127.0.0.1,root,,test, $TESTBOT0_SERVER1);
echo Using connection slave_con...;
connection slave_con;
--echo Checking slave contents...
--source include/wait_for_slave_plugin_to_sync.inc
SHOW CREATE TABLE t1;
SELECT * FROM t1;
--echo Switching to default connection
connection default;
disconnect slave_con;
# cleanup
DROP TABLE t1;
|