diff options
| author | Satya B <satya.bn@sun.com> | 2009-04-07 17:06:15 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-04-07 17:06:15 +0530 |
| commit | 8502705de44c523b2807978a5308139b93ef0368 (patch) | |
| tree | 47bcfc26a04f95081ae9ff779961a649c8545b45 /mysql-test/r/myisampack.result | |
| parent | 83a78142641e243b39dba198e06de749f0d2db09 (diff) | |
| parent | c045d1dcea0b2582b38ee5476b090097182c7144 (diff) | |
| download | mariadb-git-8502705de44c523b2807978a5308139b93ef0368.tar.gz | |
merge 5.0-bugteam to 5.1-bugteam
Diffstat (limited to 'mysql-test/r/myisampack.result')
| -rw-r--r-- | mysql-test/r/myisampack.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/myisampack.result b/mysql-test/r/myisampack.result index dc7f3e396d1..fbcd8aed17a 100644 --- a/mysql-test/r/myisampack.result +++ b/mysql-test/r/myisampack.result @@ -65,3 +65,25 @@ SELECT COUNT(*) FROM t1; COUNT(*) 1024 DROP TABLE t1; +# +# Bug #43973 - backup_myisam.test fails on 6.0-bugteam +# +CREATE DATABASE mysql_db1; +CREATE TABLE mysql_db1.t1 (c1 VARCHAR(5), c2 int); +CREATE INDEX i1 ON mysql_db1.t1 (c1, c2); +INSERT INTO mysql_db1.t1 VALUES ('A',1); +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1; +FLUSH TABLE mysql_db1.t1; +# Compress the table using MYISAMPACK tool +# Run MYISAMCHK tool on the compressed table +SELECT COUNT(*) FROM mysql_db1.t1 WHERE c2 < 5; +COUNT(*) +128 +DROP TABLE mysql_db1.t1; +DROP DATABASE mysql_db1; |