← 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/t/archive.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/t/archive.test
1623
1623
SELECT COUNT(t1.a) FROM t1, t1 a, t1 b, t1 c, t1 d, t1 e;
1624
1624
DROP TABLE t1;
1625
1625
SET @@join_buffer_size= @save_join_buffer_size;
 
1626
 
 
1627
#
 
1628
# BUG#47012 archive tables are not upgradeable, and server crashes on any access
 
1629
#
 
1630
let $MYSQLD_DATADIR= `SELECT @@datadir`;
 
1631
copy_file std_data/bug47012.frm $MYSQLD_DATADIR/test/t1.frm;
 
1632
copy_file std_data/bug47012.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
 
1633
copy_file std_data/bug47012.ARM $MYSQLD_DATADIR/test/t1.ARM;
 
1634
 
 
1635
--error ER_TABLE_NEEDS_UPGRADE
 
1636
SHOW CREATE TABLE t1;
 
1637
 
 
1638
--error ER_TABLE_NEEDS_UPGRADE
 
1639
SELECT * FROM t1;
 
1640
 
 
1641
--error ER_TABLE_NEEDS_UPGRADE
 
1642
INSERT INTO t1 (col1, col2) VALUES (1, "value");
 
1643
 
 
1644
REPAIR TABLE t1;
 
1645
DROP TABLE t1;
 
1646
remove_file $MYSQLD_DATADIR/test/t1.ARM;
 
1647
 
 
1648
--echo #
 
1649
--echo # BUG#48757 - missing .ARZ file causes server crash
 
1650
--echo #
 
1651
CREATE TABLE t1(a INT) ENGINE=ARCHIVE;
 
1652
FLUSH TABLE t1;
 
1653
--remove_file $MYSQLD_DATADIR/test/t1.ARZ
 
1654
--error ER_FILE_NOT_FOUND
 
1655
SELECT * FROM t1;
 
1656
--error ER_BAD_TABLE_ERROR
 
1657
DROP TABLE t1;
 
1658
 
 
1659
 
 
1660
--echo #
 
1661
--echo # BUG#46565 - repair of partition fail for archive engine
 
1662
--echo #
 
1663
--echo # Installing corrupted table files for t1.
 
1664
# bug46565 was created, filled and damaged as following:
 
1665
# CREATE TABLE bug46565(a INT) ENGINE=archive;
 
1666
# INSERT INTO bug46565 VALUES(1);
 
1667
# FLUSH TABLE bug46565;
 
1668
# INSERT INTO bug46565 VALUES(2),(3);
 
1669
# FLUSH TABLE bug46565;
 
1670
# dd if=bug46565.ARZ of=std_data/bug46565.ARZ bs=1 count=8670
 
1671
copy_file std_data/bug46565.frm $MYSQLD_DATADIR/test/t1.frm;
 
1672
copy_file std_data/bug46565.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
 
1673
--error ER_CRASHED_ON_USAGE
 
1674
SELECT * FROM t1;
 
1675
REPAIR TABLE t1;
 
1676
--error ER_CRASHED_ON_USAGE
 
1677
SELECT * FROM t1;
 
1678
REPAIR TABLE t1 EXTENDED;
 
1679
SELECT * FROM t1;
 
1680
DROP TABLE t1;
 
1681
 
 
1682
--echo #
 
1683
--echo # BUG#57162 - valgrind errors, random data when returning
 
1684
--echo #             ordered data from archive tables
 
1685
--echo #
 
1686
SET sort_buffer_size=32804;
 
1687
CREATE TABLE t1(a INT, b CHAR(255), c CHAR(255), d CHAR(255),
 
1688
  e CHAR(255), f INT) ENGINE=ARCHIVE DEFAULT CHARSET utf8;
 
1689
INSERT INTO t1 VALUES(-1,'b','c','d','e',1);
 
1690
INSERT INTO t1 SELECT * FROM t1;
 
1691
INSERT INTO t1 SELECT * FROM t1;
 
1692
INSERT INTO t1 SELECT t1.* FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6;
 
1693
SELECT * FROM t1 ORDER BY f LIMIT 1;
 
1694
DROP TABLE t1;
 
1695
SET sort_buffer_size=DEFAULT;
 
1696
 
 
1697
--echo #
 
1698
--echo # BUG#11758979 - 51252: ARCHIVE TABLES CAUSE 100% CPU USAGE
 
1699
--echo #                       AND HANG IN SHOW TABLE STATUS
 
1700
--echo # (to be executed with valgrind)
 
1701
CREATE TABLE t1(a BLOB, b VARCHAR(200)) ENGINE=ARCHIVE;
 
1702
INSERT INTO t1 VALUES(NULL, '');
 
1703
FLUSH TABLE t1;
 
1704
--echo # we need this select to workaround BUG#11764364
 
1705
SELECT * FROM t1;
 
1706
CHECKSUM TABLE t1 EXTENDED;
 
1707
FLUSH TABLE t1;
 
1708
OPTIMIZE TABLE t1;
 
1709
DROP TABLE t1;