diff options
| author | unknown <svoj@may.pils.ru> | 2006-06-21 17:51:16 +0500 |
|---|---|---|
| committer | unknown <svoj@may.pils.ru> | 2006-06-21 17:51:16 +0500 |
| commit | bf76f070dd4150728e01acf770120add6325bd06 (patch) | |
| tree | 93b5c1cb3c5a5dedfc2ac0c6086f138d52350ea0 /mysql-test/t | |
| parent | 49042de5b2ef0ea6799941334385f4352d3e64ef (diff) | |
| parent | 5c0cdea62341da75f0560216af1b363b156ed1ab (diff) | |
| download | mariadb-git-bf76f070dd4150728e01acf770120add6325bd06.tar.gz | |
Merge april:devel/BitKeeper/mysql-4.1
into may.pils.ru:/home/svoj/devel/mysql/BUG20357/mysql-4.1
sql/opt_sum.cc:
Auto merged
mysql-test/r/myisam.result:
SCCS merged
mysql-test/t/myisam.test:
SCCS merged
Diffstat (limited to 'mysql-test/t')
| -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 5f948973141..ca49db40ae4 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -706,6 +706,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; |