From 3f82e2edb81448452f647a846c1445efb918493f Mon Sep 17 00:00:00 2001 From: Igor Babaev Date: Fri, 30 Sep 2011 21:53:59 -0700 Subject: The previous correction of the cost estimate to access a joined table in the function best_access_path revealed another bug: currently table scans on NULL keys used for NOT IN subqueries cannot work together with employment of join caches for inner tables of these subqueries. Otherwise the result can be wrong as it could be seen with the result of the test case constructed for bug #37894 in the file subselect3_jcl6.result. --- mysql-test/r/subselect3_jcl6.result | 2 -- 1 file changed, 2 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/r/subselect3_jcl6.result b/mysql-test/r/subselect3_jcl6.result index e9cf259dbb3..03713c2598a 100644 --- a/mysql-test/r/subselect3_jcl6.result +++ b/mysql-test/r/subselect3_jcl6.result @@ -822,8 +822,6 @@ LEFT JOIN t1 AS INNR ON ( INNR2.int_key = INNR.int_key ) WHERE INNR.varchar_key > 'n{' ); varchar_nokey -NULL -p DROP TABLE t1; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1), (2), (11); -- cgit v1.2.1