← 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/extra/rpl_tests/rpl_insert_id_pk.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/extra/rpl_tests/rpl_insert_id_pk.test
1
1
###########################################################
2
 
# 2006-02-08: By JBM:  
3
 
###########################################################
4
2
# See if queries that use both auto_increment and LAST_INSERT_ID()
5
3
# are replicated well
6
4
############################################################
20
18
insert into t1 values (1),(2),(3);
21
19
insert into t1 values (null);
22
20
insert into t2 values (null,last_insert_id());
23
 
save_master_pos;
24
 
connection slave;
25
 
sync_with_master;
 
21
sync_slave_with_master;
26
22
select * from t1 ORDER BY a;
27
23
select * from t2 ORDER BY b;
28
24
connection master;
41
37
insert into t2 values (5,0);
42
38
insert into t2 values (null,last_insert_id());
43
39
SET FOREIGN_KEY_CHECKS=1;
44
 
save_master_pos;
45
 
connection slave;
46
 
sync_with_master;
 
40
sync_slave_with_master;
47
41
select * from t1;
48
42
select * from t2;
49
43
connection master;
59
53
insert into t2 values (5,0);
60
54
insert into t2 (c) select * from t1 ORDER BY a;
61
55
select * from t2 ORDER BY b;
62
 
save_master_pos;
63
 
connection slave;
64
 
sync_with_master;
 
56
sync_slave_with_master;
65
57
select * from t1 ORDER BY a;
66
58
select * from t2 ORDER BY b;
67
59
connection master;
68
60
drop table t1;
69
61
drop table t2;
70
 
save_master_pos;
71
 
connection slave;
72
 
sync_with_master;
 
62
sync_slave_with_master;
73
63
 
74
64
#
75
65
# Bug#8412: Error codes reported in binary log for CHARACTER SET,
86
76
connection master;
87
77
drop table t1;
88
78
# End of 4.1 tests
 
79
 
 
80
--source include/rpl_end.inc