Uses of Class
org.h2.result.SortOrder

Packages that use SortOrder

Package	Description
org.h2.command.query	Contains queries.
org.h2.expression.aggregate	Aggregate functions.
org.h2.expression.analysis	Base classes for data analysis operations and implementations of window functions.
org.h2.index	Various table index implementations, as well as cursors to navigate in an index.
org.h2.mvstore.db	Helper classes to use the MVStore in the H2 database.
org.h2.result	Implementation of row and internal result sets.
org.h2.table	Classes related to a table and table meta data.

Uses of SortOrder in org.h2.command.query

Fields in org.h2.command.query declared as SortOrder

Modifier and Type	Field	Description
(package private) SortOrder	Query.sort	A sort order represents an ORDER BY clause in a query.

Methods in org.h2.command.query that return SortOrder

Modifier and Type	Method	Description
SortOrder	Select.getSortOrder()

Uses of SortOrder in org.h2.expression.aggregate

Fields in org.h2.expression.aggregate declared as SortOrder

Modifier and Type	Field	Description
private SortOrder	Aggregate.orderBySort

Uses of SortOrder in org.h2.expression.analysis

Fields in org.h2.expression.analysis declared as SortOrder

Modifier and Type	Field	Description
protected SortOrder	DataAnalysisOperation.overOrderBySort	Sort order for OVER

Methods in org.h2.expression.analysis that return SortOrder

Modifier and Type	Method	Description
protected static SortOrder	DataAnalysisOperation.createOrder(SessionLocal session, java.util.ArrayList<QueryOrderBy> orderBy, int offset)	Create sort order.
protected SortOrder	DataAnalysisOperation.getOverOrderBySort()	Returns the sort order for OVER clause.

Methods in org.h2.expression.analysis with parameters of type SortOrder

Modifier and Type	Method	Description
private java.util.Iterator<Value[]>	WindowFrame.complexIterator(java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, int startIndex, int endIndex, boolean reverse)
private static Value[]	WindowFrame.getCompareRow(SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, WindowFrameBound bound, boolean add)	Appends bound value to the current row and produces row for comparison operations.
private int	WindowFrame.getEndIndex(SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow)	Returns end index of this frame,
static int	WindowFrame.getEndIndex(Window over, SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow)	Returns end index for the specified frame, or default end index if frame is null.
private int	WindowFrame.getIndex(SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, WindowFrameBound bound, boolean forFollowing)	Returns starting or ending index of a window frame.
int	WindowFrame.getStartIndex(SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow)	Returns start index of this frame,
java.util.Iterator<Value[]>	WindowFrame.iterator(SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, boolean reverse)	Returns iterator.
static java.util.Iterator<Value[]>	WindowFrame.iterator(Window over, SessionLocal session, java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, boolean reverse)	Returns iterator for the specified frame, or default iterator if frame is null.
private static int	WindowFrame.toGroupEnd(java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int offset, int maxOffset)
private static int	WindowFrame.toGroupStart(java.util.ArrayList<Value[]> orderedRows, SortOrder sortOrder, int offset, int minOffset)

Uses of SortOrder in org.h2.index

Methods in org.h2.index with parameters of type SortOrder

Modifier and Type	Method	Description
double	DualIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
abstract double	Index.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)	Estimate the cost to search for rows given the search mask.
double	LinkedIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	MetaIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	RangeIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	ViewIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	VirtualConstructedTableIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
protected long	Index.getCostRangeIndex(int[] masks, long rowCount, TableFilter[] filters, int filter, SortOrder sortOrder, boolean isScanIndex, AllColumnsForPlan allColumnsSet)	Calculate the cost for the given mask as if this index was a typical b-tree range index.

Constructors in org.h2.index with parameters of type SortOrder

Constructor	Description
ViewIndex(TableView view, ViewIndex index, SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder)	Constructor for plan item generation.

Uses of SortOrder in org.h2.mvstore.db

Methods in org.h2.mvstore.db with parameters of type SortOrder

Modifier and Type	Method	Description
double	MVDelegateIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	MVPrimaryIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	MVSecondaryIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
double	MVSpatialIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
static ResultExternal	MVTempResult.of(Database database, Expression[] expressions, boolean distinct, int[] distinctIndexes, int visibleColumnCount, int resultColumnCount, SortOrder sort)	Creates MVStore-based temporary result.

Constructors in org.h2.mvstore.db with parameters of type SortOrder

Constructor	Description
MVSortedTempResult(Database database, Expression[] expressions, boolean distinct, int[] distinctIndexes, int visibleColumnCount, int resultColumnCount, SortOrder sort)	Creates a new sorted temporary result.

Uses of SortOrder in org.h2.result

Fields in org.h2.result declared as SortOrder

Modifier and Type	Field	Description
private SortOrder	LocalResult.sort
private SortOrder	LocalResult.withTiesSortOrder

Methods in org.h2.result with parameters of type SortOrder

Modifier and Type	Method	Description
void	LocalResult.setSortOrder(SortOrder sort)	Sets sort order to be used by this result.
void	LocalResult.setWithTies(SortOrder withTiesSortOrder)	Enables inclusion of tied rows to result and sets the sort order for tied rows.

Uses of SortOrder in org.h2.table

Methods in org.h2.table with parameters of type SortOrder

Modifier and Type	Method	Description
PlanItem	Table.getBestPlanItem(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)	Get the best plan for the given search mask.
PlanItem	TableView.getBestPlanItem(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
Index	Table.getScanIndex(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)	Get the scan index for this table.
Index	TableView.getScanIndex(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)