~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/slave/tests/t/basic.test

  • Committer: patrick crews
  • Date: 2011-03-09 20:04:11 UTC
  • mto: (2231.1.1 build) (2239.2.2 build)
  • mto: This revision was merged to the branch mainline in revision 2232.
  • Revision ID: gleebix@gmail.com-20110309200411-868y1ssdbf5fqhcp
Updated dbqp magic so that we can execute slave tests.  We have to use .cnf files vs. .opt files, but this is the future anyway ; )  Added basic test + include file to ensure slave is sync'd prior to checking it

Show diffs side-by-side

added added

removed removed

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