• Igor Babaev's avatar
    MDEV-30538 Plans for SELECT and multi-table UPDATE/DELETE unexpectedly differ · bef20b5f
    Igor Babaev authored
    This patch allowed transformation of EXISTS subqueries into equivalent
    IN predicands at the top level of WHERE conditions for multi-table UPDATE
    and DELETE statements. There was no reason to prohibit the transformation
    for such statements. The transformation provides more opportunities of
    using semi-join optimizations.
    
    Approved by Oleksandr Byelkin <sanja@mariadb.com>
    bef20b5f
multi_update.result 45.4 KB