• Rucha Deodhar's avatar
    MDEV-29212: json_overlaps() does not check nested key-value pair correctly · 11d6de70
    Rucha Deodhar authored
    Analysis: JSON_OVERLAPS() does not check nested key-value pair completely.
    If there is nested object, then it only scans and validates if two json values
    overlap until one of the value (which is of type object) is exhausted.
    This does not really check if the two values of keys are exacly the same, instead
    it only checks if key-value pair of one is present in key-value pair of the
    other
    Fix: Normalize the values (which are of type object) and compare
    using string compare. This will validate if two values
    are exactly the same.
    11d6de70
func_json.result 74.9 KB