diff options
| author | unknown <monty@work.mysql.com> | 2001-09-04 01:04:32 +0200 |
|---|---|---|
| committer | unknown <monty@work.mysql.com> | 2001-09-04 01:04:32 +0200 |
| commit | 54e33e272d75345b09190052bb0c7d52cce56fc8 (patch) | |
| tree | aaf42ebc12881df70581f25e72e0a95304a405ae /mysql-test | |
| parent | 5160501770aafc0b2b9ee287e5a8b7627b1b51bb (diff) | |
| parent | 3b7bd02ebd175fd1e14e6e57e59e60af0a36f68f (diff) | |
| download | mariadb-git-54e33e272d75345b09190052bb0c7d52cce56fc8.tar.gz | |
Merge work.mysql.com:/home/bk/mysql
into work.mysql.com:/home/bk/mysql-4.0
Docs/manual.texi:
Auto merged
client/mysqldump.c:
Auto merged
libmysql/Makefile.am:
Auto merged
libmysql_r/Makefile.am:
Auto merged
myisam/mi_check.c:
Auto merged
sql/log_event.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
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; |