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 OVERMethods 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)
-