← 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/rpl/r/rpl_slow_query_log.result

  • 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/rpl/r/rpl_slow_query_log.result
 
1
include/master-slave.inc
 
2
[connection master]
 
3
CALL mtr.add_suppression("Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT");
 
4
include/stop_slave.inc
 
5
SET @old_log_output= @@log_output;
 
6
SET GLOBAL log_output= 'TABLE';
 
7
SET @old_long_query_time= @@long_query_time;
 
8
SET GLOBAL long_query_time= 2;
 
9
TRUNCATE mysql.slow_log;
 
10
include/start_slave.inc
 
11
CREATE TABLE t1 (a int, b int);
 
12
INSERT INTO t1 values(1, 1);
 
13
INSERT INTO t1 values(1, sleep(3));
 
14
TRUNCATE mysql.slow_log;
 
15
SELECT 1, sleep(3);
 
16
1       sleep(3)
 
17
1       0
 
18
SELECT 1;
 
19
1
 
20
1
 
21
TRUNCATE mysql.slow_log;
 
22
SET TIMESTAMP= 1;
 
23
SELECT 2, sleep(3);
 
24
2       sleep(3)
 
25
2       0
 
26
SELECT 2;
 
27
2
 
28
2
 
29
TRUNCATE mysql.slow_log;
 
30
SET @old_slow_query_log= @@slow_query_log;
 
31
SET GLOBAL slow_query_log= 'OFF';
 
32
SELECT 3, sleep(3);
 
33
3       sleep(3)
 
34
3       0
 
35
SELECT 3;
 
36
3
 
37
3
 
38
TRUNCATE mysql.slow_log;
 
39
SET GLOBAL slow_query_log= @old_slow_query_log;
 
40
DROP TABLE t1;
 
41
include/stop_slave.inc
 
42
SET GLOBAL long_query_time= @old_long_query_time;
 
43
SET GLOBAL log_output= @old_log_output;
 
44
include/start_slave.inc
 
45
include/rpl_reset.inc
 
46
SET @old_log_output= @@log_output;
 
47
SET GLOBAL log_output= 'TABLE';
 
48
SET GLOBAL long_query_time= 2;
 
49
SET @old_long_query_time= @@long_query_time;
 
50
SET SESSION long_query_time= 2;
 
51
TRUNCATE mysql.slow_log;
 
52
include/stop_slave.inc
 
53
SET @old_log_output= @@log_output;
 
54
SET GLOBAL log_output= 'TABLE';
 
55
SET @old_long_query_time= @@long_query_time;
 
56
SET GLOBAL long_query_time= 2;
 
57
TRUNCATE mysql.slow_log;
 
58
include/start_slave.inc
 
59
CREATE TABLE t1 (a int, b int);
 
60
********************************************************************
 
61
**** INSERT one row that exceeds long_query_time
 
62
**** Outcome: query ends up in both master and slave slow log
 
63
********************************************************************
 
64
INSERT INTO t1 values(1, sleep(3));
 
65
### Assertion is good. Both Master and Slave exhibit the 
 
66
### same number of queries in slow log: 1
 
67
TRUNCATE mysql.slow_log;
 
68
TRUNCATE mysql.slow_log;
 
69
********************************************************************
 
70
**** Now do inserts again, but first add an index to the table.
 
71
**** Outcome: Note that the slave contains the same one entry (as 
 
72
****          the master does)  whereas before the patch it did not.
 
73
********************************************************************
 
74
ALTER TABLE t1 ADD INDEX id1(a);
 
75
INSERT INTO t1 values(1, sleep(3));
 
76
### Assertion is good. Both Master and Slave exhibit the 
 
77
### same number of queries in slow log: 1
 
78
SET @@global.log_output= @old_log_output;
 
79
SET @@global.long_query_time= @old_long_query_time;
 
80
DROP TABLE t1;
 
81
SET @@global.log_output= @old_log_output;
 
82
SET @@global.long_query_time= @old_long_query_time;
 
83
include/rpl_end.inc