← 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.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.test
1
1
###########################################################
2
 
# 2006-02-01: By JBM: Added 1022, ORDER BY 
3
 
###########################################################
4
2
# See if queries that use both auto_increment and LAST_INSERT_ID()
5
3
# are replicated well
6
4
############################################################
14
12
--echo #
15
13
 
16
14
use test;
17
 
--disable_warnings
18
 
drop table if exists t1, t2, t3;
19
 
--enable_warnings
20
15
 
21
16
--echo #
22
17
--echo # See if queries that use both auto_increment and LAST_INSERT_ID()
42
37
insert into t1 values (1),(2),(3);
43
38
insert into t1 values (null);
44
39
insert into t2 values (null,last_insert_id());
45
 
save_master_pos;
46
 
connection slave;
47
 
sync_with_master;
 
40
sync_slave_with_master;
48
41
select * from t1 ORDER BY a;
49
42
select * from t2 ORDER BY b;
50
43
connection master;
63
56
insert into t2 values (5,0);
64
57
insert into t2 values (null,last_insert_id());
65
58
SET FOREIGN_KEY_CHECKS=1;
66
 
save_master_pos;
67
 
connection slave;
68
 
sync_with_master;
 
59
sync_slave_with_master;
69
60
select * from t1;
70
61
select * from t2;
71
62
connection master;
83
74
insert into t2 values (5,0);
84
75
insert into t2 (c) select * from t1 ORDER BY a;
85
76
select * from t2 ORDER BY b;
86
 
save_master_pos;
87
 
connection slave;
88
 
sync_with_master;
 
77
sync_slave_with_master;
89
78
select * from t1 ORDER BY a;
90
79
select * from t2 ORDER BY b;
91
80
connection master;
92
81
drop table t1;
93
82
drop table t2;
94
 
save_master_pos;
95
 
connection slave;
96
 
sync_with_master;
 
83
sync_slave_with_master;
97
84
 
98
85
--echo #
99
86
--echo # Bug#8412: Error codes reported in binary log for CHARACTER SET,
208
195
 
209
196
select * from t1;
210
197
select * from t2;
211
 
save_master_pos;
212
 
connection slave;
213
 
sync_with_master;
 
198
sync_slave_with_master;
214
199
select * from t1;
215
200
select * from t2;
216
201
connection master;
548
533
drop table t1, t2;
549
534
drop procedure foo;
550
535
SET @@global.concurrent_insert= @old_concurrent_insert;
551
 
sync_slave_with_master;
 
536
 
 
537
--source include/rpl_end.inc