diff options
author | unknown <monty@hundin.mysql.fi> | 2002-01-02 22:02:03 +0200 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2002-01-02 22:02:03 +0200 |
commit | 301cdf9f240106978b04d4f8044b24e4a3fa6d00 (patch) | |
tree | 0041cf05ee45a8b92584dd5d81ef8b4c5c1f9283 /mysql-test/r/bdb.result | |
parent | b47495360cbd21fa80efc72c18e9892ffeebd1ed (diff) | |
parent | 62c4fa399e0c7acb1e7dfdae4ceac4b61daeb744 (diff) | |
download | mariadb-git-301cdf9f240106978b04d4f8044b24e4a3fa6d00.tar.gz |
merge
Docs/manual.texi:
Auto merged
sql/item_func.h:
Auto merged
sql/lex.h:
Auto merged
sql/mysqld.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_table.cc:
Auto merged
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); |