diff options
Diffstat (limited to 'mysql-test/r/bdb.result')
| -rw-r--r-- | mysql-test/r/bdb.result | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result index a7ddff5c532..e553105fcc7 100644 --- a/mysql-test/r/bdb.result +++ b/mysql-test/r/bdb.result @@ -167,10 +167,10 @@ optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK show keys from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 0 PRIMARY 1 id A 39 NULL NULL -t1 1 parent_id 1 parent_id A 9 NULL NULL -t1 1 level 1 level A 3 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 id A 39 NULL NULL BTREE +t1 1 parent_id 1 parent_id A 9 NULL NULL BTREE +t1 1 level 1 level A 3 NULL NULL BTREE drop table t1; CREATE TABLE t1 ( gesuchnr int(11) DEFAULT '0' NOT NULL, @@ -217,8 +217,8 @@ analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK show keys from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 1 skr 1 a A 3 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 skr 1 a A 3 NULL NULL YES BTREE drop table t1; create table t1 (a int,b varchar(20),key(a)) type=bdb; insert into t1 values (1,""), (2,"testing"); @@ -381,13 +381,13 @@ drop table t1; CREATE TABLE t1 (a int not null, b int not null,c int not null, key(a),primary key(a,b), unique(c),key(a),unique(b)); 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 NULL NULL NULL -t1 0 PRIMARY 2 b A 0 NULL NULL -t1 0 b 1 b A 0 NULL NULL -t1 0 c 1 c A 0 NULL NULL -t1 1 a 1 a A NULL NULL NULL -t1 1 a_2 1 a A NULL NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 a A NULL NULL NULL BTREE +t1 0 PRIMARY 2 b A 0 NULL NULL BTREE +t1 0 c 1 c A 0 NULL NULL BTREE +t1 0 b 1 b A 0 NULL NULL BTREE +t1 1 a 1 a A NULL NULL NULL BTREE +t1 1 a_2 1 a A NULL NULL NULL BTREE drop table t1; create table t1 (col1 int not null, col2 char(4) not null, primary key(col1)); alter table t1 type=BDB; @@ -784,8 +784,8 @@ optimize table t1; Table Op Msg_type Msg_text test.t1 optimize status OK show keys from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 0 PRIMARY 1 a A 2 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 a A 2 NULL NULL BTREE drop table t1; create table t1 (i int, j int )TYPE=BDB; insert into t1 values (1,2); |