diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-09-04 01:25:34 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-09-04 01:25:34 +0300 |
| commit | 8efe675defa2e40cf7300b167e2dfe922caeea7b (patch) | |
| tree | c0eafd444d485cadb6d63aa0e7039389526e282c /mysql-test | |
| parent | e6088385c582e5a5c645fe4cf5fcb64d83beb9df (diff) | |
| download | mariadb-git-8efe675defa2e40cf7300b167e2dfe922caeea7b.tar.gz | |
Ensure that libmysqlclient doesn't use raid
Fix problem with MyISAM and rows of length 65517-65520
Docs/manual.texi:
Changelog
include/raid.h:
Ensure that libmysqlclient doesn't use raid
libmysql/Makefile.am:
Ensure that libmysqlclient doesn't use raid
libmysql_r/Makefile.am:
Ensure that libmysqlclient doesn't use raid
myisam/mi_check.c:
Fix problem with rows of length 65517-65520
myisam/mi_dynrec.c:
Fix problem with rows of length 65517-65520
mysql-test/r/myisam.result:
Test for myisam tables with problematic row lengths
mysql-test/t/myisam.test:
Test for myisam tables with problematic row lengths
sql/log_event.cc:
Portability fix
strings/ctype-euc_kr.c:
Portability fix
strings/ctype-sjis.c:
Portability fix
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/isam.result | 10 | ||||
| -rw-r--r-- | mysql-test/r/myisam.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/isam.test | 19 | ||||
| -rw-r--r-- | mysql-test/t/myisam.test | 20 |
4 files changed, 59 insertions, 0 deletions
diff --git a/mysql-test/r/isam.result b/mysql-test/r/isam.result new file mode 100644 index 00000000000..ba12ca05feb --- /dev/null +++ b/mysql-test/r/isam.result @@ -0,0 +1,10 @@ +Table Op Msg_type Msg_text +test.t1 check status OK +Table Op Msg_type Msg_text +test.t1 repair status OK +Table Op Msg_type Msg_text +test.t1 check status OK +Table Op Msg_type Msg_text +test.t1 repair status OK +Table Op Msg_type Msg_text +test.t1 check status OK diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 694d7429a14..1152ca24f38 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -1,2 +1,12 @@ Table Op Msg_type Msg_text test.t1 check status OK +Table Op Msg_type Msg_text +test.t1 check status OK +Table Op Msg_type Msg_text +test.t1 repair status OK +Table Op Msg_type Msg_text +test.t1 check status OK +Table Op Msg_type Msg_text +test.t1 repair status OK +Table Op Msg_type Msg_text +test.t1 check status OK diff --git a/mysql-test/t/isam.test b/mysql-test/t/isam.test new file mode 100644 index 00000000000..1cf068b42ba --- /dev/null +++ b/mysql-test/t/isam.test @@ -0,0 +1,19 @@ +# +# Test possible problem with rows that are about 65535 bytes long +# + +create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)); + +let $1=100; +while ($1) +{ + eval insert into t1 (b) values(repeat(char(65+$1),65540-$1)); + dec $1; +} +check table t1; +repair table t1; +delete from t1 where (a & 1); +check table t1; +repair table t1; +check table t1; +drop table t1; diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 84feb5de6d7..0dc7f84efc5 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -16,3 +16,23 @@ INSERT INTO t1 VALUES ('HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH INSERT INTO t1 VALUES ('WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW'); CHECK TABLE t1; drop table t1; + +# +# Test problem with rows that are 65517-65520 bytes long +# + +create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)); + +let $1=100; +while ($1) +{ + eval insert into t1 (b) values(repeat(char(65+$1),65550-$1)); + dec $1; +} +check table t1; +repair table t1; +delete from t1 where (a & 1); +check table t1; +repair table t1; +check table t1; +drop table t1; |