~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_insert_id.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
2
2
# Setup
3
3
#
4
4
use test;
5
 
drop table if exists t1, t2, t3;
6
5
#
7
6
# See if queries that use both auto_increment and LAST_INSERT_ID()
8
7
# are replicated well
9
8
#
10
9
# We also check how the foreign_key_check variable is replicated
11
10
#
12
 
stop slave;
13
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
14
 
reset master;
15
 
reset slave;
16
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
17
 
start slave;
 
11
include/master-slave.inc
 
12
[connection master]
18
13
SET @old_concurrent_insert= @@global.concurrent_insert;
19
14
SET @@global.concurrent_insert= 0;
20
15
create table t1(a int auto_increment, key(a)) engine=myisam;
531
526
drop table t1, t2;
532
527
drop procedure foo;
533
528
SET @@global.concurrent_insert= @old_concurrent_insert;
 
529
include/rpl_end.inc