summaryrefslogtreecommitdiff
path: root/sql/item_strfunc.cc
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2018-10-07 10:19:19 -0700
committerIgor Babaev <igor@askmonty.org>2018-10-08 00:31:37 -0700
commit1ebe841fb85725c2a6aaecb3bca41ec098a5193d (patch)
tree550959f618a1f842047d7f438b679fe3e27639cf /sql/item_strfunc.cc
parent1ff22b20624f233bf3ce785bd668d9a85cd8abe5 (diff)
downloadmariadb-git-1ebe841fb85725c2a6aaecb3bca41ec098a5193d.tar.gz
MDEV-17382 Hash join algorithm should not be used to join materialized
derived table / view by equality Now rows of a materialized derived table are always put into a temporary table before join operation. If BNLH is used to join this table with the result of a partial join then both operands of the join are actually put into main memory. In most cases this is not efficient. We could avoid this by sending the rows of the derived table directly to the join operation. However this kind of data flow is not supported yet. Fixed by not allowing usage of hash join algorithm to join a materialized derived table if it's joined by an equality predicate of the form f=e where f is a field of the derived table.
Diffstat (limited to 'sql/item_strfunc.cc')
0 files changed, 0 insertions, 0 deletions