← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Daniel Nichter
  • Date: 2011-10-23 16:01:37 UTC
  • mto: This revision was merged to the branch mainline in revision 2448.
  • Revision ID: daniel@percona.com-20111023160137-7ac3blgz8z4tf8za
Add Administration Getting Started and Logging.  Capitalize SQL clause keywords.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/slave/tests/t/basic.test
 
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
SHOW CREATE TABLE t1;
 
9
INSERT INTO t1 VALUES (),(),();
 
10
SELECT * FROM t1;
 
11
# We wait a bit for the slave
 
12
# Might need a proper include file / test later
 
13
--sleep 3 
 
14
--echo Connecting to slave...
 
15
connect (slave_con,127.0.0.1,root,,test, $BOT0_S1);
 
16
echo Using connection slave_con...;
 
17
connection slave_con;
 
18
--sleep 3
 
19
--echo Checking slave contents...
 
20
--source include/wait_for_slave_plugin_to_sync.inc
 
21
 
 
22
SHOW CREATE TABLE t1;
 
23
SELECT * FROM t1;
 
24
 
 
25
--echo Switching to default connection
 
26
connection default;
 
27
disconnect slave_con;
 
28
 
 
29
# cleanup
 
30
DROP TABLE t1;