diff options
Diffstat (limited to 'mysql-test/r/isam.result')
| -rw-r--r-- | mysql-test/r/isam.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/isam.result b/mysql-test/r/isam.result index c5b333e06fe..448dd7833a5 100644 --- a/mysql-test/r/isam.result +++ b/mysql-test/r/isam.result @@ -1,11 +1,18 @@ +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 +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 a b @@ -46,3 +53,4 @@ Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_par t1 0 PRIMARY 1 a A 4 NULL NULL t1 1 b 1 b A 1 NULL NULL t1 1 b 2 c A 4 NULL NULL +drop table t1; |