diff options
| author | monty@bitch.mysql.fi <> | 2001-11-28 02:55:52 +0200 |
|---|---|---|
| committer | monty@bitch.mysql.fi <> | 2001-11-28 02:55:52 +0200 |
| commit | d0ccff50907e7b04f0d14ad95f359dc23e6dc294 (patch) | |
| tree | 40e5d73c964ca6aeb5e0e7d4294e70216edaa397 /mysql-test/r/isam.result | |
| parent | d3288575de18b38179961a8acf93ba883a90e652 (diff) | |
| download | mariadb-git-d0ccff50907e7b04f0d14ad95f359dc23e6dc294.tar.gz | |
New improved IO_CACHE
Diffstat (limited to 'mysql-test/r/isam.result')
| -rw-r--r-- | mysql-test/r/isam.result | 20 |
1 files changed, 4 insertions, 16 deletions
diff --git a/mysql-test/r/isam.result b/mysql-test/r/isam.result index d80f47d3483..baeda5537e5 100644 --- a/mysql-test/r/isam.result +++ b/mysql-test/r/isam.result @@ -1,21 +1,9 @@ drop table if exists t1,t2; -create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)); -check table t1; -Table Op Msg_type Msg_text -test.t1 check status OK -repair table t1; -Table Op Msg_type Msg_text -test.t1 repair status OK +create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)) type=isam; delete from t1 where (a & 1); -check table t1; -Table Op Msg_type Msg_text -test.t1 check status OK -repair table t1; -Table Op Msg_type Msg_text -test.t1 repair status OK -check table t1; -Table Op Msg_type Msg_text -test.t1 check status OK +select sum(length(b)) from t1; +sum(length(b)) +3274494 drop table t1; create table t1 (a int not null auto_increment,b int, primary key (a)) type=isam; insert into t1 values (1,1),(NULL,2),(3,3),(NULL,4); |