diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
| commit | 851b31bcc47b742cd3b39ad06176b0e8be591c18 (patch) | |
| tree | 93da42af4bd22fc448df71777bedb0a4690478ba /mysql-test/main/statistics.test | |
| parent | 618d82064618bda06bcd080af5b664b3d173dbe3 (diff) | |
| parent | a4234f0410008e14aa2ad7ad56973127f3046d5c (diff) | |
| download | mariadb-git-851b31bcc47b742cd3b39ad06176b0e8be591c18.tar.gz | |
Merge branch 'bb-10.8-vp-MDEV-27691' into 10.8
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; |