All Implemented Interfaces:
NamedWriteable, Writeable, Resolvable, EvaluatorMapper

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

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

  • A, B ⇒ true (A ⊆ B)
  • B, A ⇒ false (A ⊈ B)
  • A, A ⇒ true (A ≡ A)
  • B, B ⇒ true (B ≡ B)
  • A, null ⇒ true (B ⊆ ∅)
  • null, A ⇒ false (∅ ⊈ B)
  • B, null ⇒ true (B ⊆ ∅)
  • null, B ⇒ false (∅ ⊈ B)
  • null, null ⇒ true (∅ ≡ ∅)