diff options
| author | unknown <mhansson/martin@linux-st28.site> | 2007-01-29 16:16:20 +0100 |
|---|---|---|
| committer | unknown <mhansson/martin@linux-st28.site> | 2007-01-29 16:16:20 +0100 |
| commit | a693c17168d0326cfb30f49d37ac62fed6cd1f2c (patch) | |
| tree | 373811acb1cd1383e2199bd137da6954bc4b2010 /mysql-test/t/key.test | |
| parent | de63c6d45efd92ea2b6691d7a714d8661e124fa5 (diff) | |
| parent | 190efb06e7c9fe96bb4f4294f3b0ddbc4eef12de (diff) | |
| download | mariadb-git-a693c17168d0326cfb30f49d37ac62fed6cd1f2c.tar.gz | |
Merge mhansson@bk-internal:/home/bk/mysql-5.1-opt
into linux-st28.site:/home/martin/mysql/src/5.1o-bug20604-tp
mysql-test/t/key.test:
Auto merged
Diffstat (limited to 'mysql-test/t/key.test')
| -rw-r--r-- | mysql-test/t/key.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test index 0a5eb17f6f5..1a53344c8ef 100644 --- a/mysql-test/t/key.test +++ b/mysql-test/t/key.test @@ -442,3 +442,14 @@ alter table t1 drop index i3, drop index i2, drop index i1; alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1); drop table t1; + +# +# Bug #20604: Test for disabled keys with aggregate functions and FORCE INDEX. +# + +CREATE TABLE t1( a TINYINT, KEY(a) ) ENGINE=MyISAM; +INSERT INTO t1 VALUES( 1 ); +ALTER TABLE t1 DISABLE KEYS; +EXPLAIN SELECT MAX(a) FROM t1 FORCE INDEX(a); + +drop table t1; |