diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-11-18 13:32:21 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-11-18 13:32:21 -0800 |
| commit | 8ea398292e9c5ae8e8efcaccde8e781317855d13 (patch) | |
| tree | ca2390aa38ca6d8e8c14bf23cd248e4dd2bf0a5f /sql/opt_subselect.cc | |
| parent | 6ed9c1364302ea998aa265e67aa7714dc3f365c2 (diff) | |
| download | mariadb-git-8ea398292e9c5ae8e8efcaccde8e781317855d13.tar.gz | |
Fixed LP bug #891995.
This bug in the function setup_semijoin_dups_elimination() could
lead to invalid choice of the sequence of tables for which semi-join
duplicate elimination was applied.
Diffstat (limited to 'sql/opt_subselect.cc')
| -rw-r--r-- | sql/opt_subselect.cc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/opt_subselect.cc b/sql/opt_subselect.cc index a954811bdfa..efaac11f53b 100644 --- a/sql/opt_subselect.cc +++ b/sql/opt_subselect.cc @@ -3921,8 +3921,8 @@ int setup_semijoin_dups_elimination(JOIN *join, ulonglong options, if (j != join->const_tables && js_tab->use_quick != 2 && j <= no_jbuf_after && ((js_tab->type == JT_ALL && join_cache_level != 0) || - (join_cache_level > 2 && (tab->type == JT_REF || - tab->type == JT_EQ_REF)))) + (join_cache_level > 2 && (js_tab->type == JT_REF || + js_tab->type == JT_EQ_REF)))) { /* Looks like we'll be using join buffer */ first_table= join->const_tables; |