summaryrefslogtreecommitdiff
path: root/mysql-test/r/null_key.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2010-10-06 13:27:12 -0700
committerIgor Babaev <igor@askmonty.org>2010-10-06 13:27:12 -0700
commit79087c9e072ea2c1af3f1372d5c37729545f618c (patch)
tree5e25d464f11921aaf51073cdf80ed4fb8a174dfe /mysql-test/r/null_key.result
parentf1d42ec9407bf4c7248d13bc4d2fd1bd8daf0910 (diff)
downloadmariadb-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.result4
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