diff options
author | unknown <jimw@mysql.com> | 2005-05-18 11:06:34 -0700 |
---|---|---|
committer | unknown <jimw@mysql.com> | 2005-05-18 11:06:34 -0700 |
commit | f8a20dbeb6d53fc5d993e088c245e4f2f9b085c5 (patch) | |
tree | 384afb929b09dd50f92ab7de3d46902df3cb3e4e /mysql-test/r/myisam.result | |
parent | 6f7bccd1aca31045e2678159e2e931d2e94f54dd (diff) | |
parent | d104149caf5d272a8495e4bd55ec9eaf3015b408 (diff) | |
download | mariadb-git-f8a20dbeb6d53fc5d993e088c245e4f2f9b085c5.tar.gz |
Resolve merge from 4.1
BitKeeper/etc/logging_ok:
auto-union
configure.in:
Auto merged
myisam/mi_check.c:
Auto merged
mysql-test/mysql-test-run.sh:
Auto merged
client/mysqldump.c:
Resolve merge
mysql-test/r/myisam.result:
Resolve merge
mysql-test/r/mysqldump.result:
Resolve merge
mysql-test/r/olap.result:
Resolve merge
mysql-test/r/subselect.result:
Resolve merge
mysql-test/t/myisam.test:
Resolve merge
mysql-test/t/mysqldump.test:
Resolve merge
mysql-test/t/olap.test:
Resolve merge
mysql-test/t/range.test:
Resolve merge
mysql-test/t/subselect.test:
Resolve merge
ndb/src/common/util/version.c:
Resolve merge
ndb/src/ndbapi/ndberror.c:
Resolve merge
sql/item.cc:
Resolve merge
sql/item_strfunc.h:
Resolve merge
sql/sql_select.cc:
Resolve merge
sql/sql_yacc.yy:
Resolve merge
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 30e573fa31e..8239202fc04 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -1260,3 +1260,17 @@ Table Op Msg_type Msg_text test.t1 check status OK drop table t1; set global concurrent_insert=@save_concurrent_insert; +create table t1 (a int, key(a)); +insert into t1 values (1),(2),(3),(4),(NULL),(NULL),(NULL),(NULL); +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 Null Index_type Comment +t1 1 a 1 a A 8 NULL NULL YES BTREE +alter table t1 disable keys; +alter table t1 enable keys; +show keys from t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 a 1 a A 8 NULL NULL YES BTREE +drop table t1; |