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/t/analyze.test | |
| 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/t/analyze.test')
| -rw-r--r-- | mysql-test/t/analyze.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/analyze.test b/mysql-test/t/analyze.test index 5d653b65579..a4694c32d3c 100644 --- a/mysql-test/t/analyze.test +++ b/mysql-test/t/analyze.test @@ -48,4 +48,13 @@ execute stmt1; execute stmt1; deallocate prepare stmt1; +# +# bug#15225 (ANALYZE temporary has no effect) +# +create temporary table t1(a int, index(a)); +insert into t1 values('1'),('2'),('3'),('4'),('5'); +analyze table t1; +show index from t1; +drop table t1; + # End of 4.1 tests |