public enum NullsDistinct extends java.lang.Enum<NullsDistinct> implements org.h2.util.HasSQL
NULL
values in indexed columns are handled
in unique indexes, unique constraints, or by unique predicate.Enum Constant and Description |
---|
ALL_DISTINCT
NULL values of columns are distinct only if all columns have null values. |
DISTINCT
NULL values of columns are distinct. |
NOT_DISTINCT
NULL values of columns are never distinct. |
Modifier and Type | Method and Description |
---|---|
java.lang.StringBuilder |
getSQL(java.lang.StringBuilder builder,
int sqlFlags)
Appends the SQL statement of this object to the specified builder.
|
static NullsDistinct |
valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.
|
static NullsDistinct[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final NullsDistinct DISTINCT
NULL
values of columns are distinct.public static final NullsDistinct ALL_DISTINCT
NULL
values of columns are distinct only if all columns have null values.public static final NullsDistinct NOT_DISTINCT
NULL
values of columns are never distinct.public static NullsDistinct[] values()
for (NullsDistinct c : NullsDistinct.values()) System.out.println(c);
public static NullsDistinct valueOf(java.lang.String name)
name
- the name of the enum constant to be returned.java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is nullpublic java.lang.StringBuilder getSQL(java.lang.StringBuilder builder, int sqlFlags)
org.h2.util.HasSQL
getSQL
in interface org.h2.util.HasSQL
builder
- string buildersqlFlags
- formatting flags