← Back to branch summary

~vadim-tk/percona-server/percona-galera-5.1.57

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/include/rpl_mixed_check_select.inc

  • Committer: root
  • Date: 2011-07-10 16:09:24 UTC
  • Revision ID: root@r815.office.percona.com-20110710160924-fyffqsbaclgu6vui
Initial port

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/include/rpl_mixed_check_select.inc
 
1
#########################################
 
2
# Author: Serge Kozlov skozlov@mysql.com
 
3
# Date: 07/10/2006
 
4
# Purpose: Showing data from work tables on master and on slave
 
5
# Requirements: 
 
6
#########################################
 
7
 
 
8
--echo ==========MASTER==========
 
9
SELECT COUNT(*) FROM t1;
 
10
SELECT * FROM t1 ORDER BY a;
 
11
SELECT COUNT(*) FROM t2;
 
12
SELECT * FROM t2 ORDER BY a;
 
13
sync_slave_with_master;
 
14
--echo ==========SLAVE===========
 
15
USE test_rpl;
 
16
SELECT COUNT(*) FROM t1;
 
17
SELECT * FROM t1 ORDER BY a;
 
18
SELECT COUNT(*) FROM t2;
 
19
SELECT * FROM t2 ORDER BY a;
 
20
connection master;
 
21