diff options
| -rw-r--r-- | mysql-test/r/statistics.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/statistics.test | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/statistics.result b/mysql-test/r/statistics.result index a7543cd9117..6c00f7a5299 100644 --- a/mysql-test/r/statistics.result +++ b/mysql-test/r/statistics.result @@ -1423,6 +1423,7 @@ ANALYZE TABLE CountryLanguage; set histogram_size=254; set histogram_type='DOUBLE_PREC_HB'; ANALYZE TABLE City; +FLUSH TABLES; select db_name,table_name,column_name,min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type,hex(histogram),decode_histogram(histogram,hist_type) from mysql.column_stats where table_name='CountryLanguage' and column_name = 'Percentage';; db_name world table_name CountryLanguage diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index 97db984d4c8..ee44d1ed228 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -572,6 +572,7 @@ ANALYZE TABLE CountryLanguage; set histogram_size=254; set histogram_type='DOUBLE_PREC_HB'; ANALYZE TABLE City; +FLUSH TABLES; --enable_result_log --query_vertical select db_name,table_name,column_name,min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type,hex(histogram),decode_histogram(histogram,hist_type) from mysql.column_stats where table_name='CountryLanguage' and column_name = 'Percentage'; |