List:Commits« Previous MessageNext Message »
From:Øystein Grøvlen Date:June 17 2011 10:23am
Subject:Re: bzr commit into mysql-trunk branch (roy.lyseng:3385) Bug#12640083
View as plain text  
Approved, with the following suggestions:

- Simplify test case
- Add EXPLAIN

--
Øystein

On 16/06/2011 12:56, Roy Lyseng wrote:
> #At file:///home/rl136806/mysql/repo/mysql-review/ based on
> revid:jorgen.loland@stripped
>
>   3385 Roy Lyseng	2011-06-16
>        Bug#12640083: Same query executed as WHERE subquery gives different
>                      results on IN() compare
>
>        The query that returns with an empty result is using the
>        MaterializeScan semi-join strategy, and it has an outer join
>        operation inside the materialized subquery. As has happened before,
>        there are remnants of outer join execution in the join_tab that is
>        reused for reading the materialized tables, in this case it was the
>        first_unmatched field that needed clearing.
>
>        mysql-test/include/subquery_sj.inc
>          Added test case for bug#12640083.
>
>        mysql-test/r/subquery_sj_all.result
>        mysql-test/r/subquery_sj_all_jcl6.result
>        mysql-test/r/subquery_sj_all_jcl7.result
>        mysql-test/r/subquery_sj_dupsweed.result
>        mysql-test/r/subquery_sj_dupsweed_jcl6.result
>        mysql-test/r/subquery_sj_dupsweed_jcl7.result
>        mysql-test/r/subquery_sj_firstmatch.result
>        mysql-test/r/subquery_sj_firstmatch_jcl6.result
>        mysql-test/r/subquery_sj_firstmatch_jcl7.result
>        mysql-test/r/subquery_sj_loosescan.result
>        mysql-test/r/subquery_sj_loosescan_jcl6.result
>        mysql-test/r/subquery_sj_loosescan_jcl7.result
>        mysql-test/r/subquery_sj_mat.result
>        mysql-test/r/subquery_sj_mat_jcl6.result
>        mysql-test/r/subquery_sj_mat_jcl7.result
>        mysql-test/r/subquery_sj_mat_nosj.result
>        mysql-test/r/subquery_sj_none.result
>        mysql-test/r/subquery_sj_none_jcl6.result
>        mysql-test/r/subquery_sj_none_jcl7.result
>          Added test case result for bug#12640083.
>
>        sql/sql_select.cc
>          In sub_select_sjm(), cleared the flag last_tab->first_unmatched.
>

...
Thread
bzr commit into mysql-trunk branch (roy.lyseng:3385) Bug#12640083Roy Lyseng16 Jun
  • Re: bzr commit into mysql-trunk branch (roy.lyseng:3385) Bug#12640083Øystein Grøvlen19 Jun
    • Re: bzr commit into mysql-trunk branch (roy.lyseng:3385) Bug#12640083Roy Lyseng20 Jun