summaryrefslogtreecommitdiff
path: root/mysql-test/r/join_cache.result
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2012-01-20 02:11:53 +0400
committerSergey Petrunya <psergey@askmonty.org>2012-01-20 02:11:53 +0400
commit9f60aa27f707dea88e8882c5aaf096dce35a3a72 (patch)
treeb34dbc9872bdb7a2d090d1e144b20536a3fc5f7c /mysql-test/r/join_cache.result
parent8bedf1ea1c328fabea14a1ce232794d73814b6d7 (diff)
downloadmariadb-git-9f60aa27f707dea88e8882c5aaf096dce35a3a72.tar.gz
BUG#912513: Wrong result (missing rows) with join_cache_hashed+materialization+semijoin=on
- equality substitution code was geared towards processing WHERE/ON clauses. that is, it assumed that it was doing substitions on the code that = wasn't attached to any particular join_tab yet = was going to be fed to make_join_select() which would take the condition apart and attach various parts of it to tables inside/outside semi-joins. - However, somebody added equality substition for ref access. That is, if we have a ref access on TBL.key=expr, they would do equality substition in 'expr'. This possibility wasn't accounted for. - Fixed equality substition code by adding a mode that does equality substition under assumption that the processed expression will be attached to a certain particular table TBL.
Diffstat (limited to 'mysql-test/r/join_cache.result')
0 files changed, 0 insertions, 0 deletions