diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2019-02-17 22:46:10 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2019-02-18 13:37:57 +0300 |
commit | 15a77a1a2ce2d9608101e8f440580c23d9508c54 (patch) | |
tree | d065a1c74091e8e595f21084a6cf09ee21df176a /mysql-test/main/selectivity.test | |
parent | 19c6a7bbd75d8a72716ecba3aa32d4e9f13daebb (diff) | |
download | mariadb-git-15a77a1a2ce2d9608101e8f440580c23d9508c54.tar.gz |
MDEV-18608: Defaults for 10.4: histogram size should be set
Change the defaults:
-histogram_size=0
+histogram_size=254
-histogram_type=SINGLE_PREC_HB
+histogram_type=DOUBLE_PREC_HB
Adjust the testcases:
- Some have ignorable changes in EXPLAIN outputs and
more counter increments due to EITS table reads.
- Testcases that meaningfully depend on the old defaults
are changed to use the old values.
Diffstat (limited to 'mysql-test/main/selectivity.test')
-rw-r--r-- | mysql-test/main/selectivity.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/selectivity.test b/mysql-test/main/selectivity.test index 3df49456332..eb3f6e2893a 100644 --- a/mysql-test/main/selectivity.test +++ b/mysql-test/main/selectivity.test @@ -14,6 +14,8 @@ set use_stat_tables='preferably'; set @save_optimizer_use_condition_selectivity=@@optimizer_use_condition_selectivity; set @save_histogram_size=@@histogram_size; set @save_histogram_type=@@histogram_type; +set histogram_size=0; +set histogram_type='single_prec_hb'; # check that statistics on nulls is used |