← Back to branch summary

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

« 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 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/archive.test
1678
1678
REPAIR TABLE t1 EXTENDED;
1679
1679
SELECT * FROM t1;
1680
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;