diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-09-30 21:53:59 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-09-30 21:53:59 -0700 |
| commit | 3f82e2edb81448452f647a846c1445efb918493f (patch) | |
| tree | 2b928502092db317a1c2800f78731155b20eea43 /mysql-test/r/subselect3_jcl6.result | |
| parent | 715dc5f99ddf852a5ef45bcb68c6c86298f6a7c3 (diff) | |
| download | mariadb-git-3f82e2edb81448452f647a846c1445efb918493f.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r/subselect3_jcl6.result')
| -rw-r--r-- | mysql-test/r/subselect3_jcl6.result | 2 |
1 files changed, 0 insertions, 2 deletions
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); |