← 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/r/rpl_row_sp002_innodb.result

  • 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/r/rpl_row_sp002_innodb.result
1
 
stop slave;
2
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3
 
reset master;
4
 
reset slave;
5
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
 
start slave;
7
 
DROP PROCEDURE IF EXISTS test.p1;
8
 
DROP PROCEDURE IF EXISTS test.p2;
9
 
DROP PROCEDURE IF EXISTS test.p3;
10
 
DROP TABLE IF EXISTS test.t3;
11
 
DROP TABLE IF EXISTS test.t1;
12
 
DROP TABLE IF EXISTS test.t2;
 
1
include/master-slave.inc
 
2
[connection master]
13
3
CREATE TABLE test.t1 (a INT AUTO_INCREMENT KEY, t CHAR(6)) ENGINE=INNODB;
14
4
CREATE TABLE test.t2 (a INT AUTO_INCREMENT KEY, f INT, FOREIGN KEY(a) REFERENCES test.t1(a) ON DELETE CASCADE) ENGINE=INNODB;
15
5
create procedure test.p1(IN i CHAR(6))
231
221
98      NONE
232
222
SET AUTOCOMMIT=1;
233
223
SET FOREIGN_KEY_CHECKS=0;
234
 
DROP PROCEDURE IF EXISTS test.p3;
235
 
DROP PROCEDURE IF EXISTS test.p1;
236
 
DROP PROCEDURE IF EXISTS test.p2;
237
 
DROP TABLE IF EXISTS test.t1;
238
 
DROP TABLE IF EXISTS test.t2;
239
 
DROP TABLE IF EXISTS test.t3;
 
224
DROP PROCEDURE test.p3;
 
225
DROP PROCEDURE test.p1;
 
226
DROP PROCEDURE test.p2;
 
227
DROP TABLE test.t1;
 
228
DROP TABLE test.t2;
 
229
DROP TABLE test.t3;
 
230
include/rpl_end.inc