• Galina Shalygina's avatar
    MDEV-16765: Missing rows with pushdown condition defined with CASE using Item_cond · 0de3c423
    Galina Shalygina authored
    The bug appears because of the wrong pushdown into the WHERE clause of the
    materialized derived table/view work. For the excl_dep_on_grouping_fields()
    method that checks if the condition can be pushed into the WHERE clause
    the case when Item_cond is used is missing. For Item_cond elements this
    method always returns positive result (that condition can be pushed).
    So this condition is pushed even if is shouldn't be pushed.
    
    To fix it new Item_cond::excl_dep_on_grouping_fields() method is added.
    0de3c423
item_cmpfunc.h 91.4 KB