diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2018-02-21 16:01:50 +0200 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-02-21 16:01:50 +0200 |
| commit | dbbaaff0fbce203e8c785179b1c559f82f869a69 (patch) | |
| tree | 7c2f7b683ecf5de051b53cf2bbc97560a4e63c9e /mysql-test/r/subselect_cache.result | |
| parent | 5df9e8de638bcb0c0c877a56e01ae5c59062249a (diff) | |
| download | mariadb-git-10.3-MDEV-7773.tar.gz | |
MDEV-15253:Default optimizer setting changes for MariaDB 10.310.3-MDEV-7773
Milestone 1: raising join_cache_level to 4 from 2
Diffstat (limited to 'mysql-test/r/subselect_cache.result')
| -rw-r--r-- | mysql-test/r/subselect_cache.result | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/subselect_cache.result b/mysql-test/r/subselect_cache.result index 813d668c88c..6904d4a5889 100644 --- a/mysql-test/r/subselect_cache.result +++ b/mysql-test/r/subselect_cache.result @@ -2014,19 +2014,19 @@ flush status; select * from t1 where a in (select pk from t2); a b 0 0 -1 1 -2 2 0 0 -1 1 -2 2 0 0 -1 1 -2 2 0 0 -1 1 -2 2 0 0 1 1 +1 1 +1 1 +1 1 +1 1 +2 2 +2 2 +2 2 +2 2 2 2 show status like "subquery_cache%"; Variable_name Value @@ -2034,10 +2034,10 @@ Subquery_cache_hit 0 Subquery_cache_miss 0 show status like '%Handler_read%'; Variable_name Value -Handler_read_first 0 -Handler_read_key 15 +Handler_read_first 1 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 0 +Handler_read_next 10 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 |