• 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
func_str.test 40.2 KB