Top Description Fields Constructors Methods
org.h2.mode

public final Enum DefaultNullOrdering

extends Enum<DefaultNullOrdering>
Class Inheritance
Static Imports
org.h2.result.SortOrder.DESCENDING, .SortOrder.NULLS_FIRST, .SortOrder.NULLS_LAST

Default ordering of NULL values.

Field Summary

Modifier and TypeField and Description
private final int
private final int
public static final DefaultNullOrdering
FIRST

NULL values are sorted before other values, no matter if ascending or descending order is used.

public static final DefaultNullOrdering
HIGH

NULL values are considered as larger than other values during sorting.

public static final DefaultNullOrdering
LAST

NULL values are sorted after other values, no matter if ascending or descending order is used.

public static final DefaultNullOrdering
LOW

NULL values are considered as smaller than other values during sorting.

private final int
private final int
private static final DefaultNullOrdering[]

Constructor Summary

AccessConstructor and Description
private
DefaultNullOrdering(int defaultAscNulls, int defaultDescNulls)

Method Summary

Modifier and TypeMethod and Description
public int
addExplicitNullOrdering(int
sort type bit mask
sortType
)

Returns a sort type bit mask with org.h2.result.SortOrder#NULLS_FIRST or org.h2.result.SortOrder#NULLS_LAST explicitly set

public int

Returns:

the result of the comparison (-1 meaning the first expression should appear before the second, 0 if they are equal)
compareNull
(boolean
whether the first expression is null
aNull
,
int
the sort bit mask to use
sortType
)

Compare two expressions where one of them is NULL.

public static DefaultNullOrdering
public static DefaultNullOrdering

Returns:

default ordering of NULL values for the specified ordinal number
valueOf
(int
ordinal number
ordinal
)

Returns default ordering of NULL values for the specified ordinal number.

public static DefaultNullOrdering[]
Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

defaultAscNullsback to summary
private final int defaultAscNulls
defaultDescNullsback to summary
private final int defaultDescNulls
FIRSTback to summary
public static final DefaultNullOrdering FIRST

NULL values are sorted before other values, no matter if ascending or descending order is used.

HIGHback to summary
public static final DefaultNullOrdering HIGH

NULL values are considered as larger than other values during sorting.

LASTback to summary
public static final DefaultNullOrdering LAST

NULL values are sorted after other values, no matter if ascending or descending order is used.

LOWback to summary
public static final DefaultNullOrdering LOW

NULL values are considered as smaller than other values during sorting.

nullAscback to summary
private final int nullAsc
nullDescback to summary
private final int nullDesc
VALUESback to summary
private static final DefaultNullOrdering[] VALUES

Constructor Detail

DefaultNullOrderingback to summary
private DefaultNullOrdering(int defaultAscNulls, int defaultDescNulls)

Method Detail

addExplicitNullOrderingback to summary
public int addExplicitNullOrdering(int sortType)

Returns a sort type bit mask with org.h2.result.SortOrder#NULLS_FIRST or org.h2.result.SortOrder#NULLS_LAST explicitly set

Parameters
sortType:int

sort type bit mask

Returns:int

bit mask with org.h2.result.SortOrder#NULLS_FIRST or org.h2.result.SortOrder#NULLS_LAST explicitly set

compareNullback to summary
public int compareNull(boolean aNull, int sortType)

Compare two expressions where one of them is NULL.

Parameters
aNull:boolean

whether the first expression is null

sortType:int

the sort bit mask to use

Returns:int

the result of the comparison (-1 meaning the first expression should appear before the second, 0 if they are equal)

valueOfback to summary
public static DefaultNullOrdering valueOf(String name)
valueOfback to summary
public static DefaultNullOrdering valueOf(int ordinal)

Returns default ordering of NULL values for the specified ordinal number.

Parameters
ordinal:int

ordinal number

Returns:DefaultNullOrdering

default ordering of NULL values for the specified ordinal number

See Also
ordinal()
valuesback to summary
public static DefaultNullOrdering[] values()