← Back to branch summary

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

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mfrom: (1.1.5)
  • Revision ID: package-import@ubuntu.com-20120222223355-or06x1euyk8n0ldi
Tags: 5.1.61-0ubuntu0.10.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
* Dropped patches unnecessary with 5.1.61:
  - debian/patches/90_mysql_safer_strmov.dpatch
  - debian/patches/51_ssl_test_certs.dpatch
  - debian/patches/52_CVE-2009-4030.dpatch
  - debian/patches/53_CVE-2009-4484.dpatch
  - debian/patches/54_CVE-2008-7247.dpatch
  - debian/patches/55_CVE-2010-1621.dpatch
  - debian/patches/56_CVE-2010-1850.dpatch
  - debian/patches/57_CVE-2010-1849.dpatch
  - debian/patches/58_CVE-2010-1848.dpatch
  - debian/patches/59_CVE-2010-1626.dpatch
  - debian/patches/60_CVE-2010-2008.dpatch
  - debian/patches/60_CVE-2010-3677.dpatch
  - debian/patches/60_CVE-2010-3678.dpatch
  - debian/patches/60_CVE-2010-3679.dpatch
  - debian/patches/60_CVE-2010-3680.dpatch
  - debian/patches/60_CVE-2010-3681.dpatch
  - debian/patches/60_CVE-2010-3682.dpatch
  - debian/patches/60_CVE-2010-3683.dpatch
  - debian/patches/60_CVE-2010-3833.dpatch
  - debian/patches/60_CVE-2010-3834.dpatch
  - debian/patches/60_CVE-2010-3835.dpatch
  - debian/patches/60_CVE-2010-3836.dpatch
  - debian/patches/60_CVE-2010-3837.dpatch
  - debian/patches/60_CVE-2010-3838.dpatch
  - debian/patches/60_CVE-2010-3839.dpatch
  - debian/patches/60_CVE-2010-3840.dpatch
  - debian/patches/61_disable_longfilename_test.dpatch
  - debian/patches/62_alter_table_fix.dpatch
  - debian/patches/63_cherrypick-upstream-49479.dpatch
  - debian/patches/10_readline_build_fix.dpatch
* debian/mysql-client-5.1.docs: removed EXCEPTIONS-CLIENT file
* debian/mysql-server-5.1.docs,debian/libmysqlclient16.docs,
  debian/libmysqlclient-dev.docs: removed, no longer necessary.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
 
1
-- source include/have_binlog_format_mixed_or_statement.inc
 
2
-- source include/not_ndb_default.inc
 
3
-- source include/master-slave.inc
 
4
 
 
5
set @saved_binlog_format = @@global.binlog_format;
 
6
 
 
7
# Test that the slave temporarily switches to ROW when seeing binrow
 
8
# events when it is in STATEMENT or MIXED mode
 
9
 
 
10
SET BINLOG_FORMAT=MIXED;
 
11
SET GLOBAL BINLOG_FORMAT=MIXED;
 
12
SELECT @@GLOBAL.BINLOG_FORMAT, @@SESSION.BINLOG_FORMAT;
 
13
 
 
14
--echo **** On Master ****
 
15
CREATE TABLE t1 (a INT, b LONG);
 
16
INSERT INTO t1 VALUES (1,1), (2,2);
 
17
INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
 
18
let $VERSION=`select version()`;
 
19
--replace_result $VERSION VERSION
 
20
--replace_column 2 # 5 #
 
21
--replace_regex /table_id: [0-9]+/table_id: #/
 
22
# Different number of binlog events are generated by different engines
 
23
--disable_result_log
 
24
SHOW BINLOG EVENTS;
 
25
--enable_result_log
 
26
sync_slave_with_master;
 
27
--echo **** On Slave ****
 
28
--replace_result $MASTER_MYPORT MASTER_PORT
 
29
--replace_column 1 # 7 # 8 # 9 # 22 # 23 # 33 #
 
30
--query_vertical SHOW SLAVE STATUS
 
31
--replace_result $VERSION VERSION
 
32
--replace_column 2 # 5 #
 
33
--replace_regex /table_id: [0-9]+/table_id: #/
 
34
# Different number of binlog events are generated by different engines
 
35
--disable_result_log
 
36
SHOW BINLOG EVENTS;
 
37
--enable_result_log
 
38
--exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql
 
39
--exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql
 
40
 
 
41
connection master;
 
42
DROP TABLE IF EXISTS t1;
 
43
 
 
44
# Let's compare. Note: If they match test will pass, if they do not match
 
45
# the test will show that the diff statement failed and not reject file
 
46
# will be created. You will need to go to the mysql-test dir and diff
 
47
# the files your self to see what is not matching
 
48
 
 
49
diff_files $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql;
 
50
 
 
51
# If all is good, we can remove the files
 
52
 
 
53
remove_file $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql;
 
54
remove_file $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql;
 
55
 
 
56
# Restoring to the original values
 
57
SET GLOBAL BINLOG_FORMAT=@saved_binlog_format;