• igor@olga.mysql.com's avatar
    Fixed bug #27932: the function LOCATE returned NULL if any · 0f0d4720
    igor@olga.mysql.com authored
    of its arguments was evaluated to NULL, while the predicate
    LOCATE(str,NULL) IS NULL erroneously was evaluated to FALSE.
    
    This happened because the Item_func_locate::fix_length_and_dec
    method by mistake set the value of the maybe_null flag for 
    the function item to 0. In consequence of this the function 
    was considered as the one that could not ever return NULL.
    0f0d4720
item_func.cc 137 KB