Uses of Class
org.h2.result.SortOrder
Packages that use SortOrder
Package
Description
Contains queries.
Aggregate functions.
Base classes for data analysis operations and implementations of window functions.
Various table index implementations, as well as cursors to navigate in an index.
Helper classes to use the MVStore in the H2 database.
Implementation of row and internal result sets.
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 SortOrderModifier and TypeFieldDescription(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 -
Uses of SortOrder in org.h2.expression.aggregate
Fields in org.h2.expression.aggregate declared as SortOrder -
Uses of SortOrder in org.h2.expression.analysis
Fields in org.h2.expression.analysis declared as SortOrderModifier and TypeFieldDescriptionprotected SortOrder
DataAnalysisOperation.overOrderBySort
Sort order for OVERMethods in org.h2.expression.analysis that return SortOrderModifier and TypeMethodDescriptionprotected static SortOrder
DataAnalysisOperation.createOrder
(SessionLocal session, 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 SortOrderModifier and TypeMethodDescriptionWindowFrame.complexIterator
(ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, int startIndex, int endIndex, boolean reverse) private static Value[]
WindowFrame.getCompareRow
(SessionLocal session, 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, ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow) Returns end index of this frame,static int
WindowFrame.getEndIndex
(Window over, SessionLocal session, 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, 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, ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow) Returns start index of this frame,WindowFrame.iterator
(SessionLocal session, ArrayList<Value[]> orderedRows, SortOrder sortOrder, int currentRow, boolean reverse) Returns iterator.WindowFrame.iterator
(Window over, SessionLocal session, 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
(ArrayList<Value[]> orderedRows, SortOrder sortOrder, int offset, int maxOffset) private static int
WindowFrame.toGroupStart
(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 SortOrderModifier and TypeMethodDescriptiondouble
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 final 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 SortOrderModifierConstructorDescriptionViewIndex
(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 SortOrderModifier and TypeMethodDescriptiondouble
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 SortOrderModifierConstructorDescription(package private)
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 SortOrderModifier and TypeFieldDescriptionprivate SortOrder
LocalResult.sort
private SortOrder
LocalResult.withTiesSortOrder
Methods in org.h2.result with parameters of type SortOrderModifier and TypeMethodDescriptionvoid
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 SortOrderModifier and TypeMethodDescriptionTable.getBestPlanItem
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Get the best plan for the given search mask.TableView.getBestPlanItem
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Table.getScanIndex
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Get the scan index for this table.TableView.getScanIndex
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)