~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/archive.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mfrom: (1.2.3)
  • Revision ID: package-import@ubuntu.com-20120222141605-5xu64xtalgrxgoie
Tags: 5.1.61-0ubuntu0.10.10.1
* 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/61_CVE-2010-3833.dpatch
  - debian/patches/61_CVE-2010-3834.dpatch
  - debian/patches/61_CVE-2010-3835.dpatch
  - debian/patches/61_CVE-2010-3836.dpatch
  - debian/patches/61_CVE-2010-3837.dpatch
  - debian/patches/61_CVE-2010-3838.dpatch
  - debian/patches/61_CVE-2010-3839.dpatch
  - debian/patches/61_CVE-2010-3840.dpatch
  - debian/patches/60_abi-check-include.dpatch
  - debian/patches/62_disable_longfilename_test.dpatch
  - debian/patches/90_fix_testsuite_for_installed_env.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:
12756
12756
1
12757
12757
2
12758
12758
DROP TABLE t1;
 
12759
#
 
12760
# BUG#57162 - valgrind errors, random data when returning
 
12761
#             ordered data from archive tables
 
12762
#
 
12763
SET sort_buffer_size=32804;
 
12764
CREATE TABLE t1(a INT, b CHAR(255), c CHAR(255), d CHAR(255),
 
12765
e CHAR(255), f INT) ENGINE=ARCHIVE DEFAULT CHARSET utf8;
 
12766
INSERT INTO t1 VALUES(-1,'b','c','d','e',1);
 
12767
INSERT INTO t1 SELECT * FROM t1;
 
12768
INSERT INTO t1 SELECT * FROM t1;
 
12769
INSERT INTO t1 SELECT t1.* FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6;
 
12770
SELECT * FROM t1 ORDER BY f LIMIT 1;
 
12771
a       b       c       d       e       f
 
12772
-1      b       c       d       e       1
 
12773
DROP TABLE t1;
 
12774
SET sort_buffer_size=DEFAULT;
 
12775
#
 
12776
# BUG#11758979 - 51252: ARCHIVE TABLES CAUSE 100% CPU USAGE
 
12777
#                       AND HANG IN SHOW TABLE STATUS
 
12778
# (to be executed with valgrind)
 
12779
CREATE TABLE t1(a BLOB, b VARCHAR(200)) ENGINE=ARCHIVE;
 
12780
INSERT INTO t1 VALUES(NULL, '');
 
12781
FLUSH TABLE t1;
 
12782
# we need this select to workaround BUG#11764364
 
12783
SELECT * FROM t1;
 
12784
a       b
 
12785
NULL    
 
12786
CHECKSUM TABLE t1 EXTENDED;
 
12787
Table   Checksum
 
12788
test.t1 286155052
 
12789
FLUSH TABLE t1;
 
12790
OPTIMIZE TABLE t1;
 
12791
Table   Op      Msg_type        Msg_text
 
12792
test.t1 optimize        status  OK
 
12793
DROP TABLE t1;