diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-07-10 22:12:23 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-07-10 22:12:23 -0700 |
| commit | cb0a5c84b63a24d143160e38995cb35268f8eef4 (patch) | |
| tree | 8206bc6461f436386059a40a425961a1f8220cb3 /mysql-test/r/statistics.result | |
| parent | 47fae7f08fd0437cd555bbd6b2533a4117340c8d (diff) | |
| download | mariadb-git-cb0a5c84b63a24d143160e38995cb35268f8eef4.tar.gz | |
Made the output of the newly added test cases from statistics.test
platform independent.
Adjusted results of funcs_1.is_columns_mysql_embedded.
Diffstat (limited to 'mysql-test/r/statistics.result')
| -rw-r--r-- | mysql-test/r/statistics.result | 80 |
1 files changed, 45 insertions, 35 deletions
diff --git a/mysql-test/r/statistics.result b/mysql-test/r/statistics.result index a4e60e266d0..680712e5f4a 100644 --- a/mysql-test/r/statistics.result +++ b/mysql-test/r/statistics.result @@ -1159,42 +1159,52 @@ WORLD_INNODB COUNTRYLANGUAGE PRIMARY 2 1.0000 WORLD_INNODB COUNTRYLANGUAGE Percentage 1 2.7640 use test; DROP DATABASE world; -SELECT * FROM mysql.table_stat; -db_name table_name cardinality -world_innodb Country 239 -world_innodb City 4079 -world_innodb CountryLanguage 984 -SELECT * FROM mysql.column_stat; -db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency -world_innodb Country Code ABW ZWE 0.0000 3.0000 1.0000 -world_innodb Country Name Afghanistan Zimbabwe 0.0000 10.1088 1.0000 -world_innodb Country SurfaceArea 0.40 17075400.00 0.0000 4.0000 1.0042 -world_innodb Country Population 0 1277558000 0.0000 4.0000 1.0575 -world_innodb Country Capital 1 4074 0.0293 4.0000 1.0000 -world_innodb City ID 1 4079 0.0000 4.0000 1.0000 -world_innodb City Name A Coruña (La Coruña) Ürgenc 0.0000 8.6416 1.0195 -world_innodb City Country ABW ZWE 0.0000 3.0000 17.5819 -world_innodb City Population 42 10500000 0.0000 4.0000 1.0467 -world_innodb CountryLanguage Country ABW ZWE 0.0000 3.0000 4.2232 -world_innodb CountryLanguage Language Abhyasi [South]Mande 0.0000 7.1778 2.1532 -world_innodb CountryLanguage Percentage 0.0 99.9 0.0000 4.0000 2.7640 -SELECT * FROM mysql.index_stat; -db_name table_name index_name prefix_arity avg_frequency -world_innodb Country PRIMARY 1 1.0000 -world_innodb Country Name 1 1.0000 -world_innodb City PRIMARY 1 1.0000 -world_innodb City Population 1 1.0467 -world_innodb City Country 1 17.5819 -world_innodb CountryLanguage PRIMARY 1 4.2232 -world_innodb CountryLanguage PRIMARY 2 1.0000 -world_innodb CountryLanguage Percentage 1 2.7640 +SELECT UPPER(db_name), UPPER(table_name), cardinality +FROM mysql.table_stat; +UPPER(db_name) UPPER(table_name) cardinality +WORLD_INNODB COUNTRY 239 +WORLD_INNODB CITY 4079 +WORLD_INNODB COUNTRYLANGUAGE 984 +SELECT UPPER(db_name), UPPER(table_name), +column_name, min_value, max_value, nulls_ratio, avg_length, avg_frequency +FROM mysql.column_stat; +UPPER(db_name) UPPER(table_name) column_name min_value max_value nulls_ratio avg_length avg_frequency +WORLD_INNODB COUNTRY Code ABW ZWE 0.0000 3.0000 1.0000 +WORLD_INNODB COUNTRY Name Afghanistan Zimbabwe 0.0000 10.1088 1.0000 +WORLD_INNODB COUNTRY SurfaceArea 0.40 17075400.00 0.0000 4.0000 1.0042 +WORLD_INNODB COUNTRY Population 0 1277558000 0.0000 4.0000 1.0575 +WORLD_INNODB COUNTRY Capital 1 4074 0.0293 4.0000 1.0000 +WORLD_INNODB CITY ID 1 4079 0.0000 4.0000 1.0000 +WORLD_INNODB CITY Name A Coruña (La Coruña) Ürgenc 0.0000 8.6416 1.0195 +WORLD_INNODB CITY Country ABW ZWE 0.0000 3.0000 17.5819 +WORLD_INNODB CITY Population 42 10500000 0.0000 4.0000 1.0467 +WORLD_INNODB COUNTRYLANGUAGE Country ABW ZWE 0.0000 3.0000 4.2232 +WORLD_INNODB COUNTRYLANGUAGE Language Abhyasi [South]Mande 0.0000 7.1778 2.1532 +WORLD_INNODB COUNTRYLANGUAGE Percentage 0.0 99.9 0.0000 4.0000 2.7640 +SELECT UPPER(db_name), UPPER(table_name), +index_name, prefix_arity, avg_frequency +FROM mysql.index_stat; +UPPER(db_name) UPPER(table_name) index_name prefix_arity avg_frequency +WORLD_INNODB COUNTRY PRIMARY 1 1.0000 +WORLD_INNODB COUNTRY Name 1 1.0000 +WORLD_INNODB CITY PRIMARY 1 1.0000 +WORLD_INNODB CITY Population 1 1.0467 +WORLD_INNODB CITY Country 1 17.5819 +WORLD_INNODB COUNTRYLANGUAGE PRIMARY 1 4.2232 +WORLD_INNODB COUNTRYLANGUAGE PRIMARY 2 1.0000 +WORLD_INNODB COUNTRYLANGUAGE Percentage 1 2.7640 DROP DATABASE world_innodb; -SELECT * FROM mysql.table_stat; -db_name table_name cardinality -SELECT * FROM mysql.column_stat; -db_name table_name column_name min_value max_value nulls_ratio avg_length avg_frequency -SELECT * FROM mysql.index_stat; -db_name table_name index_name prefix_arity avg_frequency +SELECT UPPER(db_name), UPPER(table_name), cardinality +FROM mysql.table_stat; +UPPER(db_name) UPPER(table_name) cardinality +SELECT UPPER(db_name), UPPER(table_name), +column_name, min_value, max_value, nulls_ratio, avg_length, avg_frequency +FROM mysql.column_stat; +UPPER(db_name) UPPER(table_name) column_name min_value max_value nulls_ratio avg_length avg_frequency +SELECT UPPER(db_name), UPPER(table_name), +index_name, prefix_arity, avg_frequency +FROM mysql.index_stat; +UPPER(db_name) UPPER(table_name) index_name prefix_arity avg_frequency DELETE FROM mysql.table_stat; DELETE FROM mysql.column_stat; DELETE FROM mysql.index_stat; |