diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-01-07 00:34:30 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-01-07 00:34:30 -0800 |
| commit | d0dc6e07f6b33447465db149d84cff86020afc34 (patch) | |
| tree | 25fe922e772834ede5236c20e6cad44a99015e34 /mysql-test/t/statistics.test | |
| parent | 6f91e434f79287a6d31204e981813f7c62f608cc (diff) | |
| download | mariadb-git-d0dc6e07f6b33447465db149d84cff86020afc34.tar.gz | |
Made statistics.test platform independent.
Diffstat (limited to 'mysql-test/t/statistics.test')
| -rw-r--r-- | mysql-test/t/statistics.test | 22 |
1 files changed, 16 insertions, 6 deletions
diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index 0a32fcde881..81108c9846d 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -239,9 +239,14 @@ set optimizer_use_stat_tables='preferably'; ANALYZE TABLE Country, City, CountryLanguage; --enable_result_log -SELECT * FROM test.table_stat; -SELECT * FROM test.column_stat; -SELECT * FROM test.index_stat; +SELECT UPPER(db_name), UPPER(table_name), cardinality + FROM test.table_stat; +SELECT UPPER(db_name), UPPER(table_name), + column_name, min_value, max_value, nulls_ratio, avg_length, avg_frequency + FROM test.column_stat; +SELECT UPPER(db_name), UPPER(table_name), + index_name, prefix_arity, avg_frequency + FROM test.index_stat; use test; @@ -271,9 +276,14 @@ set optimizer_use_stat_tables='preferably'; ANALYZE TABLE Country, City, CountryLanguage; --enable_result_log -SELECT * FROM test.table_stat; -SELECT * FROM test.column_stat; -SELECT * FROM test.index_stat; +SELECT UPPER(db_name), UPPER(table_name), cardinality + FROM test.table_stat; +SELECT UPPER(db_name), UPPER(table_name), + column_name, min_value, max_value, nulls_ratio, avg_length, avg_frequency + FROM test.column_stat; +SELECT UPPER(db_name), UPPER(table_name), + index_name, prefix_arity, avg_frequency + FROM test.index_stat; use test; |