diff options
| author | unknown <ingo@mysql.com> | 2005-04-16 17:44:04 +0200 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2005-04-16 17:44:04 +0200 |
| commit | dacff5a90853c0e0742c45c1f3c8196fd9344137 (patch) | |
| tree | bb4b9d6f5e49dee4f4c907036559f22a97181a7e /mysql-test | |
| parent | 4528fd15278cfefc98cf106ee299cf41ccc3d01e (diff) | |
| parent | b753fd96b29dabc0085205238b570f9f5486567a (diff) | |
| download | mariadb-git-dacff5a90853c0e0742c45c1f3c8196fd9344137.tar.gz | |
Merge mysql.com:/home/mydev/mysql-4.1
into mysql.com:/home/mydev/mysql-4.1-bug9188
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/myisam.result | 8 | ||||
| -rw-r--r-- | mysql-test/t/myisam.test | 10 |
2 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index eaed7c620e3..5b69ce68a79 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -573,3 +573,11 @@ truncate table t1; ERROR HY000: MyISAM table 't1' is in use (most likely by a MERGE table). Try FLUSH TABLES. insert into t1 values (1); drop table t1,t2; +create table t1 (c1 int, c2 varchar(4) not null default '', +key(c2(3))) default charset=utf8; +insert into t1 values (1,'A'), (2, 'B'), (3, 'A'); +update t1 set c2='A B' where c1=2; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +drop table t1; diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 0babd1f9401..46a6499adad 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -550,3 +550,13 @@ truncate table t1; insert into t1 values (1); drop table t1,t2; +# +# bug9188 - Corruption Can't open file: 'table.MYI' (errno: 145) +# +create table t1 (c1 int, c2 varchar(4) not null default '', + key(c2(3))) default charset=utf8; +insert into t1 values (1,'A'), (2, 'B'), (3, 'A'); +update t1 set c2='A B' where c1=2; +check table t1; +drop table t1; + |