← Back to branch summary

~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-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 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

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