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/null_key.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/null_key.result')
| -rw-r--r-- | mysql-test/r/null_key.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 4b4a4b80dee..cd553b77738 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -181,12 +181,12 @@ insert into t2 values (7),(8); explain select * from t2 straight_join t1 where t1.a=t2.a and b is null; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ALL NULL NULL NULL NULL 2 Using where -1 SIMPLE t1 ref a,b a 10 test.t2.a,const 2 Using where; Using index +1 SIMPLE t1 hash_range a,b #hash#a:b 10:5 test.t2.a,const 2 Using where; Using join buffer (flat, BNLH join) drop index b on t1; explain select * from t2,t1 where t1.a=t2.a and b is null; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ALL NULL NULL NULL NULL 2 Using where -1 SIMPLE t1 ref a a 10 test.t2.a,const 2 Using where; Using index +1 SIMPLE t1 hash_index a #hash#a:a 10:10 test.t2.a,const 15 Using where; Using index; Using join buffer (flat, BNLH join) select * from t2,t1 where t1.a=t2.a and b is null; a a b 7 7 NULL @@ -409,30 +409,30 @@ EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.b=t3.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 4 -1 SIMPLE t2 ref idx idx 5 test.t1.a 1 Using where -1 SIMPLE t3 ref idx idx 5 test.t2.b 1 Using where; Using index +1 SIMPLE t2 hash_ALL idx #hash#idx 5 test.t1.a 2 Using where; Using join buffer (flat, BNLH join) +1 SIMPLE t3 hash_index idx #hash#idx:idx 5:5 test.t2.b 15972 Using where; Using index; Using join buffer (incremental, BNLH join) FLUSH STATUS ; SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.b=t3.b; a a b b 1 1 1 NULL -2 NULL NULL NULL 3 3 1 NULL +2 NULL NULL NULL 4 NULL NULL NULL SELECT FOUND_ROWS(); FOUND_ROWS() 4 SHOW STATUS LIKE "handler_read%"; Variable_name Value -Handler_read_first 0 -Handler_read_key 6 +Handler_read_first 1 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 2 +Handler_read_next 15972 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 5 +Handler_read_rnd_next 8 DROP TABLE t1,t2,t3,t4; CREATE TABLE t1 ( a int(11) default NULL, |