diff options
| author | svoj@june.mysql.com <> | 2006-12-26 18:04:31 +0400 |
|---|---|---|
| committer | svoj@june.mysql.com <> | 2006-12-26 18:04:31 +0400 |
| commit | 838fe3a04e4c6a337a93517c3314d10c39d60318 (patch) | |
| tree | 9584207888694080633b6c7e869db17a30d89399 | |
| parent | bd929199b3c4479fa6e1ca00a0e3942e1841e465 (diff) | |
| parent | 591712f53fb0c81bbec4a0b2eb087088280c1468 (diff) | |
| download | mariadb-git-838fe3a04e4c6a337a93517c3314d10c39d60318.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG25048/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG25048/mysql-5.1-engines
| -rw-r--r-- | mysql-test/include/index_merge_ror.inc | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/include/index_merge_ror.inc b/mysql-test/include/index_merge_ror.inc index b9f5c7b95da..2764cbea468 100644 --- a/mysql-test/include/index_merge_ror.inc +++ b/mysql-test/include/index_merge_ror.inc @@ -272,3 +272,18 @@ select count(a) from t2 ignore index(a,b) where a='AAAAAAAA' and b='AAAAAAAA'; insert into t2 values ('ab', 'ab', 'uh', 'oh'); explain select a from t2 where a='ab'; drop table t2; + +# +# BUG#25048 - ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to +# repair it +# +CREATE TABLE t1(c1 INT, c2 INT DEFAULT 0, c3 CHAR(255) DEFAULT '', +KEY(c1), KEY(c2), KEY(c3)); +INSERT INTO t1(c1) VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0), +(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0); +INSERT INTO t1 VALUES(0,0,0); +CREATE TABLE t2(c1 int); +INSERT INTO t2 VALUES(1); +DELETE t1 FROM t1,t2 WHERE t1.c1=0 AND t1.c2=0; +SELECT * FROM t1; +DROP TABLE t1,t2; |