diff options
| author | unknown <holyfoot@deer.(none)> | 2005-12-10 18:02:36 +0400 |
|---|---|---|
| committer | unknown <holyfoot@deer.(none)> | 2005-12-10 18:02:36 +0400 |
| commit | 48450d8a2b7a4e50d8642c1f6fb9415eac5f2e12 (patch) | |
| tree | 96ccbb674d8c34c0478e7f113661dac8941cff38 /mysql-test/r/analyze.result | |
| parent | 5aeb69296a4e134f0215da3e6bcce4956b7d76ad (diff) | |
| download | mariadb-git-48450d8a2b7a4e50d8642c1f6fb9415eac5f2e12.tar.gz | |
Fix for bug #15225 (ANALYZE temporary has no effect)
mysql-test/r/analyze.result:
test result fixed
mysql-test/t/analyze.test:
test case added
sql/sql_table.cc:
we don't need to remove temporary table from the cache,
but we need to reload it's info
Diffstat (limited to 'mysql-test/r/analyze.result')
| -rw-r--r-- | mysql-test/r/analyze.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/analyze.result b/mysql-test/r/analyze.result index 796b382f5d6..bded22c4859 100644 --- a/mysql-test/r/analyze.result +++ b/mysql-test/r/analyze.result @@ -37,3 +37,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; |