← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/t/rpl_slave_grp_exec.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/t/rpl_slave_grp_exec.test
62
62
SELECT * FROM t3 ORDER BY a;
63
63
 
64
64
--connection slave
65
 
--source include/wait_for_slave_sql_to_stop.inc
 
65
# 1146 = ER_NO_SUCH_TABLE
 
66
call mtr.add_suppression("Slave SQL.*Error .Table .test.t3. doesn.t exist. on.* Error_code: 1146");
 
67
--let $slave_sql_errno= 1146
 
68
--source include/wait_for_slave_sql_error.inc
66
69
SHOW TABLES LIKE 't%';
67
70
if (`SELECT @@BINLOG_FORMAT = 'ROW'`) {
68
71
--replace_regex /AA/AA_for_row_or_XX_for_stmt_mixed/
77
80
  SELECT * FROM t2 ORDER BY a;
78
81
}
79
82
 
80
 
--source include/stop_slave.inc
 
83
--source include/stop_slave_io.inc
81
84
RENAME TABLE t3_bak TO t3;
82
85
--source include/start_slave.inc
83
86
 
107
110
UPDATE t1 SET b = 'X' WHERE a = 2;
108
111
 
109
112
--connection slave
110
 
--source include/wait_for_slave_sql_to_stop.inc
 
113
# 1146 = ER_NO_SUCH_TABLE
 
114
--let $slave_sql_errno= 1146
 
115
--source include/wait_for_slave_sql_error.inc
111
116
 
112
117
--connection master
113
118
SELECT * FROM t1 ORDER BY a;
119
124
SELECT * FROM t1 ORDER BY a;
120
125
SELECT * FROM t2 ORDER BY a;
121
126
 
122
 
--source include/stop_slave.inc
 
127
--source include/stop_slave_io.inc
123
128
RENAME TABLE t3_bak TO t3;
124
129
--source include/start_slave.inc
125
130
 
151
156
COMMIT;
152
157
 
153
158
--connection slave
154
 
--source include/wait_for_slave_sql_to_stop.inc
 
159
# 1146 = ER_NO_SUCH_TABLE
 
160
--let $slave_sql_errno= 1146
 
161
--source include/wait_for_slave_sql_error.inc
155
162
 
156
163
--connection master
157
164
SELECT * FROM t1 ORDER BY a;
163
170
SELECT * FROM t1 ORDER BY a;
164
171
SELECT * FROM t2 ORDER BY a;
165
172
 
166
 
source include/stop_slave.inc;
 
173
source include/stop_slave_io.inc;
167
174
RENAME TABLE t3_bak TO t3;
168
175
source include/start_slave.inc;
169
176
 
174
181
--sync_slave_with_master
175
182
 
176
183
# End of 5.1 test
 
184
--source include/rpl_end.inc