diff options
| author | serg@serg.mylan <> | 2004-01-21 21:43:41 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-01-21 21:43:41 +0100 |
| commit | e7a37d41b084f5479fc824c9258c189be7dfd468 (patch) | |
| tree | a4551da14164e53b019f30aa32bb9bc0fc5bc83f | |
| parent | 6ecd67981a1bcaa22fe6dd5b09e25c3739c93f94 (diff) | |
| download | mariadb-git-e7a37d41b084f5479fc824c9258c189be7dfd468.tar.gz | |
test case for MyISAM sort-repair bug
| -rw-r--r-- | mysql-test/r/myisam.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/myisam.test | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index e113a48f4da..11e8ef4fcd7 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -385,3 +385,9 @@ check table t1; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; +create table t1 ( a text not null, key a (a(20))); +insert into t1 values ('aaa '),('aaa'); +repair table t1; +Table Op Msg_type Msg_text +test.t1 repair status OK +drop table t1; diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 12853cd67ca..7ad038bcad0 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -385,3 +385,12 @@ insert into t1 (b) values (repeat('z',100)); update t1 set b="test" where left(b,1) > 'n'; check table t1; drop table t1; + +# +# sort-repair bug +# +create table t1 ( a text not null, key a (a(20))); +insert into t1 values ('aaa '),('aaa'); +repair table t1; +drop table t1; + |