-
Committer:
Sergey Petrunya
-
Date:
2011-09-02 19:44:28 UTC
-
mto:
This revision was merged to the branch mainline in
revision
3178.
-
Revision ID:
psergey@askmonty.org-20110902194428-2gqnm9kvqf0d3yt8
BUG#836507: Crash in setup_sj_materialization_part1() with semijoin+materialization
- setup_sj_materialization() code failed to take into account that it can be that
the first [in join order ordering] table inside semi-join-materialization nest
is also an inner table wrt an outer join (that is embedded in the semi-join).
This can happen when all of the tables that are inside the semi-join but not inside
the outer join are constant.
- Made a trivial to not assume that table's embedding join nest is the semi-join
nest: instead, walk up the outer join nests until we reach the semi-join nest.