diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-03-30 18:57:07 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-03-30 18:57:07 -0700 |
| commit | 9e1ca1053b5e619e1f6c727abdf787dc163ab4e6 (patch) | |
| tree | e8c3a439fd6c693e9035bc699eeb0c27d912b272 /mysql-test/t/statistics.test | |
| parent | e59e529635f5a033aff905e95a901b17fe0f9833 (diff) | |
| download | mariadb-git-9e1ca1053b5e619e1f6c727abdf787dc163ab4e6.tar.gz | |
Added the type of histogram for mwl #253.
Introduced double precision height-balanced histograms.
Diffstat (limited to 'mysql-test/t/statistics.test')
| -rw-r--r-- | mysql-test/t/statistics.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index 65412d849ed..2488e511bab 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -178,7 +178,21 @@ SELECT db_name, table_name, column_name, FROM mysql.column_stats; DELETE FROM mysql.column_stats; + +set histogram_size=8; +set histogram_type='DOUBLE_PREC_HB'; +ANALYZE TABLE t1; + +SELECT db_name, table_name, column_name, + min_value, max_value, + nulls_ratio, avg_frequency, + hist_size, HEX(histogram) + FROM mysql.column_stats; + +DELETE FROM mysql.column_stats; + set histogram_size= 0; +set histogram_type=default; ANALYZE TABLE t1; |