All Implemented Interfaces:
NamedWriteable, Writeable, Resolvable, EvaluatorMapper

public class MvIntersects extends BinaryScalarFunction implements EvaluatorMapper
Function that takes two multivalued expressions and checks if any values of one expression(subset) are present(equals) in the other (superset).

Given Set A = {"a","b","c"} and Set B = {"c","d"}, the relationship between first (row) and second (column) arguments is:

  • A, B ⇒ true (A ∩ B is a non-empty set)
  • B, A ⇒ true (A ∩ B is a non-empty set)
  • A, A ⇒ true (A ∩ A is a non-empty set
  • B, B ⇒ true (B ∩ B is a non-empty set
  • A, null ⇒ false (A ∩ ∅ is an empty set)
  • null, A ⇒ false (∅ ∩ A is an empty set)
  • B, null ⇒ false (B ∩ ∅ is an empty set)
  • null, B ⇒ false (∅ ∩ B is an empty set)
  • null, null ⇒ false (∅ ∩ ∅ is an empty set)