• Igor Babaev's avatar
    MDEV-26553 NOT IN subquery construct crashing 10.1 and up · ac963142
    Igor Babaev authored
    This bug was introduced by commit be00e279
    The commit was applied for the task MDEV-6480 that allowed to remove top
    level disjuncts from WHERE conditions if the range optimizer evaluated them
    as always equal to FALSE/NULL.
    If such disjuncts are removed the WHERE condition may become an AND formula
    and if this formula contains multiple equalities the field JOIN::item_equal
    must be updated to refer to these equalities. The above mentioned commit
    forgot to do this and it could cause crashes for some queries.
    
    Approved by Oleksandr Byelkin <sanja@mariadb.com>
    ac963142
sql_select.cc 878 KB