diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-07-21 00:43:37 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-07-21 00:43:37 -0700 |
| commit | 4a03a1d777f2c2c4c921a5b52df5da362950b468 (patch) | |
| tree | 58fc77a84ca87e850e9f03f88660044d1e010d96 /mysql-test/r/subselect_mat.result | |
| parent | 2e8542f4620fd64e65eb6e41122bbe166c242a01 (diff) | |
| download | mariadb-git-4a03a1d777f2c2c4c921a5b52df5da362950b468.tar.gz | |
Fixed LP bug #813447.
Do not make substitution of a single-row table if it is an inner
table of an outer join with on expression containing an expensive
subquery.
Diffstat (limited to 'mysql-test/r/subselect_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_mat.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/subselect_mat.result b/mysql-test/r/subselect_mat.result index 4afac70d927..50b4bd36c9f 100644 --- a/mysql-test/r/subselect_mat.result +++ b/mysql-test/r/subselect_mat.result @@ -1409,7 +1409,7 @@ EXPLAIN SELECT i FROM t1 LEFT JOIN t2 ON (j) IN (SELECT k FROM t3); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 system NULL NULL NULL NULL 1 -1 PRIMARY t2 system NULL NULL NULL NULL 1 +1 PRIMARY t2 ALL NULL NULL NULL NULL 1 Using where 2 SUBQUERY t3 system NULL NULL NULL NULL 0 const row not found SELECT i FROM t1 LEFT JOIN t2 ON (j) IN (SELECT k FROM t3); i @@ -1418,7 +1418,7 @@ EXPLAIN SELECT i FROM t1 LEFT JOIN t2 ON (j) IN (SELECT max(k) FROM t3); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 system NULL NULL NULL NULL 1 -1 PRIMARY t2 system NULL NULL NULL NULL 1 +1 PRIMARY t2 ALL NULL NULL NULL NULL 1 Using where 2 SUBQUERY t3 system NULL NULL NULL NULL 0 const row not found SELECT i FROM t1 LEFT JOIN t2 ON (j) IN (SELECT max(k) FROM t3); i @@ -1437,10 +1437,10 @@ SELECT * FROM t2 LEFT JOIN t2 t3 ON (8, 4) IN (SELECT c1, c1 FROM t1)"; EXECUTE st1; c2 c2 -10 10 +10 NULL EXECUTE st1; c2 c2 -10 10 +10 NULL DROP TABLE t1, t2; # # Testcase backport: BUG#46548 IN-subqueries return 0 rows with materialization=on |