diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-07-15 02:58:34 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-07-15 02:58:34 +0400 |
| commit | 56a23357ae8e62b92b9dcdfa79336881c32f138a (patch) | |
| tree | 895fdd1b527d8b6ccbff59692514a26c4c290750 /mysql-test/r/subselect_sj2_mat.result | |
| parent | 932d51665623624fd768c5f62164b439d7cba810 (diff) | |
| download | mariadb-git-56a23357ae8e62b92b9dcdfa79336881c32f138a.tar.gz | |
BUG#803457: Wrong result with semijoin + view + outer join in maria-5.3-subqueries-mwl90
(This is not a real fix for this bug, even though it makes it to no longer repeat)
- Semi-join subquery predicates, i.e. ... WHERE outer_expr IN (SELECT ...) may have null-rejecting properties,
may allow to convert outer joins into inner.
- When convert_subq_to_sj() injected IN-equality into parent's WHERE/ON clause, it didn't call
$new_cond->top_level_item(), which would cause null-rejecting properties to be lost.
- Fixed, now the mentioned outer-to-inner conversion will really take place.
Diffstat (limited to 'mysql-test/r/subselect_sj2_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2_mat.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_sj2_mat.result b/mysql-test/r/subselect_sj2_mat.result index c680fd2ba67..5a5d0065d64 100644 --- a/mysql-test/r/subselect_sj2_mat.result +++ b/mysql-test/r/subselect_sj2_mat.result @@ -279,8 +279,8 @@ from t0 where a in id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t0 ALL NULL NULL NULL NULL 10 1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 9 func 1 -2 SUBQUERY t1 index NULL a 5 NULL 10 Using index -2 SUBQUERY t2 ref a a 5 test.t1.a 1 Using where; Using index +2 SUBQUERY t1 index a a 5 NULL 10 Using where; Using index +2 SUBQUERY t2 ref a a 5 test.t1.a 1 Using index 2 SUBQUERY t3 ref a a 5 test.t1.a 1 Using index drop table t0, t1,t2,t3; CREATE TABLE t1 ( |