• Galina Shalygina's avatar
    MDEV-23878 Wrong result with semi-join and splittable derived table · 4bc1860e
    Galina Shalygina authored
    Due to this bug a wrong result might be expected from queries with
    an IN subquery predicate in the WHERE clause and a derived table in the
    FROM clause to which split optimization could be applied.
    
    The function JOIN::fix_all_splittings_in_plan() used the value of the
    bitmap JOIN::sjm_lookup_tables() such as it had been left after the
    search for the best plan for the select containing the splittable
    derived table. That value could not be guaranteed to be correct. So the
    recalculation of this bitmap is needed to exclude the plans with key
    accesses from SJM lookup tables.
    
    Approved by Igor Babaev <igor@maridb.com>
    4bc1860e
derived_split_innodb.test 12.9 KB