diff options
| author | unknown <svoj@may.pils.ru> | 2006-06-21 19:41:09 +0500 |
|---|---|---|
| committer | unknown <svoj@may.pils.ru> | 2006-06-21 19:41:09 +0500 |
| commit | 5b9d44fd868fb5ebf37724800f4dcf6a9549f1a3 (patch) | |
| tree | bd2e438a7edeff0a66537289cedd160add92d3dd /mysql-test/t/myisam.test | |
| parent | a1ea102599762c85a0d822bb38a2b14e7a88217e (diff) | |
| parent | 630a1ee440a6003a720acab5b89bfe604badd31f (diff) | |
| download | mariadb-git-5b9d44fd868fb5ebf37724800f4dcf6a9549f1a3.tar.gz | |
Merge may.pils.ru:/home/svoj/devel/mysql/BUG20357/mysql-4.1
into may.pils.ru:/home/svoj/devel/mysql/BUG20357/mysql-5.0
mysql-test/r/myisam.result:
Auto merged
mysql-test/t/myisam.test:
Auto merged
sql/opt_sum.cc:
Auto merged
mysql-test/mysql-test-run.sh:
Auto merged
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index a30548f46ff..56e799f00b6 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -698,6 +698,18 @@ select count(id1) from t1 where id2 = 10; drop table t1; # +# BUG##20357 - Got error 124 from storage engine using MIN and MAX functions +# in queries +# +CREATE TABLE t1(a TINYINT, KEY(a)) ENGINE=MyISAM; +INSERT INTO t1 VALUES(1); +SELECT MAX(a) FROM t1 IGNORE INDEX(a); +ALTER TABLE t1 DISABLE KEYS; +SELECT MAX(a) FROM t1; +SELECT MAX(a) FROM t1 IGNORE INDEX(a); +DROP TABLE t1; + +# # BUG#18036 - update of table joined to self reports table as crashed # CREATE TABLE t1(a CHAR(9), b VARCHAR(7)) ENGINE=MyISAM; |