diff options
author | Igor Babaev <igor@askmonty.org> | 2010-10-06 13:27:12 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2010-10-06 13:27:12 -0700 |
commit | 79087c9e072ea2c1af3f1372d5c37729545f618c (patch) | |
tree | 5e25d464f11921aaf51073cdf80ed4fb8a174dfe /mysql-test/r/null_key.result | |
parent | f1d42ec9407bf4c7248d13bc4d2fd1bd8daf0910 (diff) | |
download | mariadb-git-79087c9e072ea2c1af3f1372d5c37729545f618c.tar.gz |
Ported the fix for bug #57024 (a performance issue for outer joins).
Employed the same kind of optimization as in the fix for the cases
when join buffer is used.
The optimization performs early evaluation of the conditions from
on expression with table references to only outer tables of
an outer join.
Diffstat (limited to 'mysql-test/r/null_key.result')
-rw-r--r-- | mysql-test/r/null_key.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 027d1d2b93c..67725c45314 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -423,8 +423,8 @@ FOUND_ROWS() SHOW STATUS LIKE "handler_read%"; Variable_name Value Handler_read_first 0 -Handler_read_key 8 -Handler_read_next 31942 +Handler_read_key 6 +Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 5 |