Function ArrayOverlaps

pkg/sql/sem/tree/eval.go:387–407

ArrayOverlaps return true if there is even one element common between the left and right arrays.

(
	ctx context.Context, cmpCtx CompareContext, array, other *DArray,
)

// ArrayOverlaps return true if there is even one element
// common between the left and right arrays.
func ArrayOverlaps(
	ctx context.Context, cmpCtx CompareContext, array, other *DArray,
) (*DBool, error) {
	if !array.ParamTyp.Equivalent(other.ParamTyp) {
		return nil, pgerror.New(pgcode.DatatypeMismatch, "cannot compare arrays with different element types")
	}
	for _, needle := range array.Array {
		// Nulls don't compare to each other in && syntax.
		if needle == DNull {
			continue
		}
		for _, hay := range other.Array {
			if cmp, err := needle.Compare(ctx, cmpCtx, hay); err != nil {
				return DBoolFalse, err
			} else if cmp == 0 {
				return DBoolTrue, nil
			}
		}
	}
	return DBoolFalse, nil
}

// JSONExistsAny return true if any value in dArray is exist in the json
func JSONExistsAny(json DJSON, dArray *DArray) (*DBool, error) {