diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 19:12:21 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 19:12:21 +0200 |
| commit | 35b831d97193d0f8f0bf0ffdaf12218cf091e568 (patch) | |
| tree | 8be7b37854293d1061d6eedc8ec3cdb0a25cc7d8 /mysql-test/main/statistics.test | |
| parent | 950e4f584da2ee937d98ea824e34aa895d737ea3 (diff) | |
| parent | 336dbe55f3efb01eb2110e56b9e1e75c3b21c106 (diff) | |
| download | mariadb-git-35b831d97193d0f8f0bf0ffdaf12218cf091e568.tar.gz | |
Merge branch 'bb-10.11-vp-MDEV-27691' into 10.11
Diffstat (limited to 'mysql-test/main/statistics.test')
| -rw-r--r-- | mysql-test/main/statistics.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/statistics.test b/mysql-test/main/statistics.test index 0487ff17c8d..525836abba8 100644 --- a/mysql-test/main/statistics.test +++ b/mysql-test/main/statistics.test @@ -605,6 +605,7 @@ set use_stat_tables='preferably'; ANALYZE TABLE Country, City, CountryLanguage; --enable_result_log +--disable_view_protocol --sorted_result SELECT UPPER(db_name), UPPER(table_name), cardinality FROM mysql.table_stats; @@ -616,6 +617,7 @@ SELECT UPPER(db_name), UPPER(table_name), SELECT UPPER(db_name), UPPER(table_name), index_name, prefix_arity, avg_frequency FROM mysql.index_stats; +--enable_view_protocol use test; @@ -669,10 +671,12 @@ ANALYZE TABLE City; FLUSH TABLES; --enable_result_log +--disable_view_protocol --source include/histogram_replaces.inc --query_vertical select UPPER(db_name),UPPER(table_name),UPPER(column_name),min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type,decode_histogram(hist_type,histogram) from mysql.column_stats where UPPER(db_name)='WORLD' and UPPER(table_name)='COUNTRYLANGUAGE' and UPPER(column_name) = 'PERCENTAGE'; --source include/histogram_replaces.inc --query_vertical select UPPER(db_name),UPPER(table_name),UPPER(column_name),min_value,max_value,nulls_ratio,avg_length,avg_frequency,hist_size,hist_type,decode_histogram(hist_type,histogram) from mysql.column_stats where UPPER(db_name)='WORLD' and UPPER(table_name)='CITY' and UPPER(column_name) = 'POPULATION'; +--enable_view_protocol set histogram_type=@SINGLE_PREC_TYPE; set histogram_size=0; |