• Igor Babaev's avatar
    MDEV-17382 Hash join algorithm should not be used to join materialized · bd219043
    Igor Babaev authored
               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.
    bd219043
innodb_mrr_cpk.result 9.18 KB