Package org.h2.engine

Enum Class Mode.UniqueIndexNullsHandling

java.lang.Object
java.lang.Enum<Mode.UniqueIndexNullsHandling>
org.h2.engine.Mode.UniqueIndexNullsHandling
All Implemented Interfaces:
Serializable, Comparable<Mode.UniqueIndexNullsHandling>, Constable
Enclosing class:
Mode

public static enum Mode.UniqueIndexNullsHandling extends Enum<Mode.UniqueIndexNullsHandling>
Determines how rows with NULL values in indexed columns are handled in unique indexes.
  • Enum Constant Details

    • ALLOW_DUPLICATES_WITH_ANY_NULL

      public static final Mode.UniqueIndexNullsHandling ALLOW_DUPLICATES_WITH_ANY_NULL
      Multiple rows with identical values in indexed columns with at least one indexed NULL value are allowed in unique index.
    • ALLOW_DUPLICATES_WITH_ALL_NULLS

      public static final Mode.UniqueIndexNullsHandling ALLOW_DUPLICATES_WITH_ALL_NULLS
      Multiple rows with identical values in indexed columns with all indexed NULL values are allowed in unique index.
    • FORBID_ANY_DUPLICATES

      public static final Mode.UniqueIndexNullsHandling FORBID_ANY_DUPLICATES
      Multiple rows with identical values in indexed columns are not allowed in unique index.
  • Method Details

    • values

      public static Mode.UniqueIndexNullsHandling[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared
    • valueOf

      public static Mode.UniqueIndexNullsHandling valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null