• evgen@moonbone.local's avatar
    Bug#22331: Wrong WHERE in EXPLAIN EXTENDED when all expressions were optimized · 7afa5f1c
    evgen@moonbone.local authored
    away.
    
    During optimization stage the WHERE conditions can be changed or even
    be removed at all if they know for sure to be true of false. Thus they aren't
    showed in the EXPLAIN EXTENDED which prints conditions after optimization.
    
    Now if all elements of an Item_cond were removed this Item_cond is substituted
    for an Item_int with the int value of the Item_cond.
    If there were conditions that were totally optimized away then values of the
    saved cond_value and having_value will be printed instead.
    7afa5f1c
subselect.result 134 KB