summaryrefslogtreecommitdiff
path: root/mysql-test/r/analyze.result
diff options
context:
space:
mode:
authorunknown <holyfoot@mysql.com>2006-05-03 16:33:42 +0500
committerunknown <holyfoot@mysql.com>2006-05-03 16:33:42 +0500
commit0a9c02f106239afcdb6da40d9ddfb3cec1d42049 (patch)
treee3564797fb0dc8dbca6b1ef64e64cdaccc2ea868 /mysql-test/r/analyze.result
parent853f5413f631146c42b97409aef5f1ac4ad3614a (diff)
parent050a9f3f3fdfaf166369264445d7540f4ea62df7 (diff)
downloadmariadb-git-0a9c02f106239afcdb6da40d9ddfb3cec1d42049.tar.gz
merging
mysql-test/mysql-test-run.pl: Auto merged mysql-test/mysql-test-run.sh: Auto merged mysql-test/r/analyze.result: Auto merged mysql-test/t/analyze.test: Auto merged mysql-test/t/mysql_client_test.test: Auto merged mysql-test/t/mysqltest.test: Auto merged
Diffstat (limited to 'mysql-test/r/analyze.result')
-rw-r--r--mysql-test/r/analyze.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/analyze.result b/mysql-test/r/analyze.result
index 65c6955a959..fc267cb598d 100644
--- a/mysql-test/r/analyze.result
+++ b/mysql-test/r/analyze.result
@@ -46,4 +46,12 @@ Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_
execute stmt1;
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
deallocate prepare stmt1;
+create temporary table t1(a int, index(a));
+insert into t1 values('1'),('2'),('3'),('4'),('5');
+analyze table t1;
+Table Op Msg_type Msg_text
+test.t1 analyze status OK
+show index 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 5 NULL NULL YES BTREE
drop table t1;