diff options
Diffstat (limited to 'mysql-test/r/isam.result')
| -rw-r--r-- | mysql-test/r/isam.result | 37 |
1 files changed, 36 insertions, 1 deletions
diff --git a/mysql-test/r/isam.result b/mysql-test/r/isam.result index 448dd7833a5..d80f47d3483 100644 --- a/mysql-test/r/isam.result +++ b/mysql-test/r/isam.result @@ -1,3 +1,4 @@ +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 @@ -15,42 +16,76 @@ test.t1 repair status OK check table t1; Table Op Msg_type Msg_text test.t1 check status OK +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); +delete from t1 where a=4 or a=2; +insert into t1 values (NULL,4),(NULL,5),(6,6); +select * from t1; a b 1 1 5 5 3 3 4 4 6 6 +delete from t1 where a=6; +replace t1 values (3,1); +replace t1 values (3,3); +ALTER TABLE t1 add c int; +insert into t1 values (NULL,6,6); +select * from t1; a b c 1 1 NULL 5 5 NULL 3 3 NULL 4 4 NULL 6 6 6 +drop table t1; +create table t1 (a int,b text, index(a)) type=isam; +Column 'a' is used with UNIQUE or INDEX but is not defined as NOT NULL +create table t1 (a int,b text, index(b)) type=isam; +BLOB column 'b' can't be used in key specification with the used table type +create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) type=isam; +Incorrect table definition; There can only be one auto column and it must be defined as a key +create table t1 (ordid int(8), unique (ordid)) type=isam; +Column 'ordid' is used with UNIQUE or INDEX but is not defined as NOT NULL +drop table if exists t1; +create table t1 (a int not null primary key, b int not null,c int not null, key(b,c)); +insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4); +create table t2 type=isam select * from t1; +optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK +check table t1,t2; Table Op Msg_type Msg_text test.t1 check status OK test.t2 check error The handler for the table doesn't support check/repair +repair table t1,t2; Table Op Msg_type Msg_text test.t1 repair status OK test.t2 repair error The handler for the table doesn't support check/repair +check table t2,t1; Table Op Msg_type Msg_text test.t2 check error The handler for the table doesn't support check/repair test.t1 check status OK +lock tables t1 write; +check table t2,t1; Table Op Msg_type Msg_text test.t2 check error Table 't2' was not locked with LOCK TABLES test.t1 check status OK +show columns from t1; Field Type Null Key Default Extra a int(11) PRI 0 b int(11) MUL 0 c int(11) 0 +show full columns from t1; Field Type Null Key Default Extra Privileges a int(11) PRI 0 select,insert,update,references b int(11) MUL 0 select,insert,update,references c int(11) 0 select,insert,update,references +show index from t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment 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; +drop table t1,t2; |