Uses of Class
org.h2.table.TableFilter
-
Packages that use TableFilter Package Description org.h2.command This package contains the parser and the base classes for prepared SQL statements.org.h2.command.dml Contains DML (data manipulation language) and related SQL statements.org.h2.command.query Contains queries.org.h2.constraint Database constraints such as check constraints, unique constraints, and referential constraints.org.h2.expression Expressions include mathematical operations, simple values, and others.org.h2.expression.aggregate Aggregate functions.org.h2.expression.analysis Base classes for data analysis operations and implementations of window functions.org.h2.expression.condition Condition expressions.org.h2.expression.function 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 TableFilter in org.h2.command
Methods in org.h2.command that return TableFilter Modifier and Type Method Description private TableFilter
Parser. buildTableFilter(Table table, java.lang.String alias, java.util.ArrayList<java.lang.String> derivedColumnNames, IndexHints indexHints)
private TableFilter
Parser. readCorrelation(TableFilter tableFilter)
private TableFilter
Parser. readDerivedTableWithCorrelation()
private TableFilter
Parser. readSimpleTableFilter()
private TableFilter
Parser. readTablePrimary()
private TableFilter
Parser. readTableReference()
Methods in org.h2.command with parameters of type TableFilter Modifier and Type Method Description private void
Parser. addJoin(TableFilter top, TableFilter join, boolean outer, Expression on)
Add one join to another.private Expression
Parser. addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private Prepared
Parser. parseMergeInto(TableFilter targetTableFilter, int start)
private MergeUsing
Parser. parseMergeUsing(TableFilter targetTableFilter, int start)
private TableFilter
Parser. readCorrelation(TableFilter tableFilter)
private Expression
Parser. readJoinSpecification(TableFilter filter1, TableFilter filter2, boolean rightJoin)
private Column
Parser. readTableColumn(TableFilter filter)
private java.lang.String
Parser. readTableColumn(TableFilter filter, java.lang.String tableAlias)
private SetClauseList
Parser. readUpdateSetClause(TableFilter filter)
-
Uses of TableFilter in org.h2.command.dml
Fields in org.h2.command.dml declared as TableFilter Modifier and Type Field Description private TableFilter
Update. fromTableFilter
(package private) TableFilter
MergeUsing. sourceTableFilter
Source table filter.(package private) TableFilter
FilteredDataChangeStatement. targetTableFilter
The target table filter.(package private) TableFilter
MergeUsing. targetTableFilter
Target table filter.Methods in org.h2.command.dml that return TableFilter Modifier and Type Method Description TableFilter
MergeUsing. getSourceTableFilter()
TableFilter
FilteredDataChangeStatement. getTableFilter()
TableFilter
MergeUsing. getTargetTableFilter()
Methods in org.h2.command.dml with parameters of type TableFilter Modifier and Type Method Description void
Update. setFromTableFilter(TableFilter tableFilter)
void
MergeUsing. setSourceTableFilter(TableFilter sourceTableFilter)
void
FilteredDataChangeStatement. setTableFilter(TableFilter tableFilter)
void
MergeUsing. setTargetTableFilter(TableFilter targetTableFilter)
Constructors in org.h2.command.dml with parameters of type TableFilter Constructor Description MergeUsing(SessionLocal session, TableFilter targetTableFilter)
-
Uses of TableFilter in org.h2.command.query
Fields in org.h2.command.query declared as TableFilter Modifier and Type Field Description private TableFilter[]
AllColumnsForPlan. filters
private TableFilter[]
Optimizer. filters
private TableFilter
Optimizer. topFilter
(package private) TableFilter
Select. topTableFilter
The main (top) table filter.Fields in org.h2.command.query with type parameters of type TableFilter Modifier and Type Field Description private java.util.ArrayList<TableFilter>
Select. filters
private java.util.ArrayList<TableFilter>
Select. topFilters
Methods in org.h2.command.query that return TableFilter Modifier and Type Method Description TableFilter
Optimizer. getTopFilter()
TableFilter
Select. getTopTableFilter()
Methods in org.h2.command.query that return types with arguments of type TableFilter Modifier and Type Method Description java.util.ArrayList<TableFilter>
Select. getTopFilters()
Methods in org.h2.command.query with parameters of type TableFilter Modifier and Type Method Description private int
Select. addExpandedColumn(TableFilter filter, int index, java.util.HashMap<Column,ExpressionColumn> except, java.lang.String schema, java.lang.String alias, Column c)
void
Select. addTableFilter(TableFilter filter, boolean isTop)
Add a table to the query.private void
Select. disableLazyForJoinSubqueries(TableFilter top)
private int
Select. expandColumnList(TableFilter filter, int index, boolean forAlias, java.util.HashMap<Column,ExpressionColumn> except)
private static boolean
Select. getPlanFromFilter(java.lang.StringBuilder builder, int sqlFlags, TableFilter f, boolean isJoin)
private boolean
Select. isGroupSortedIndex(TableFilter tableFilter, Index index)
abstract void
Query. setEvaluatable(TableFilter tableFilter, boolean b)
Change the evaluatable flag.void
Select. setEvaluatable(TableFilter tableFilter, boolean b)
void
SelectUnion. setEvaluatable(TableFilter tableFilter, boolean b)
void
TableValueConstructor. setEvaluatable(TableFilter tableFilter, boolean b)
private void
Select. setEvaluatableRecursive(TableFilter f)
private void
Optimizer. shuffleAll(TableFilter[] f)
private boolean
Optimizer. shuffleTwo(TableFilter[] f)
private boolean
Optimizer. testPlan(TableFilter[] list)
Constructors in org.h2.command.query with parameters of type TableFilter Constructor Description AllColumnsForPlan(TableFilter[] filters)
Optimizer(TableFilter[] filters, Expression condition, SessionLocal session)
-
Uses of TableFilter in org.h2.constraint
Fields in org.h2.constraint declared as TableFilter Modifier and Type Field Description private TableFilter
ConstraintCheck. filter
Methods in org.h2.constraint with parameters of type TableFilter Modifier and Type Method Description void
ConstraintCheck. setTableFilter(TableFilter filter)
-
Uses of TableFilter in org.h2.expression
Methods in org.h2.expression that return TableFilter Modifier and Type Method Description TableFilter
ExpressionColumn. getTableFilter()
Methods in org.h2.expression with parameters of type TableFilter Modifier and Type Method Description void
Expression. addFilterConditions(TableFilter filter)
Add conditions to a table filter if they can be evaluated.static void
ExpressionVisitor. allColumnsForTableFilters(TableFilter[] filters, AllColumnsForPlan allColumnsSet)
Get the set of columns of all tables.void
Expression. createIndexConditions(SessionLocal session, TableFilter filter)
Create index conditions if possible and attach them to the table filter.void
ExpressionColumn. createIndexConditions(SessionLocal session, TableFilter filter)
void
ValueExpression. createIndexConditions(SessionLocal session, TableFilter filter)
void
Alias. setEvaluatable(TableFilter tableFilter, boolean b)
void
ArrayConstructorByQuery. setEvaluatable(TableFilter tableFilter, boolean value)
abstract void
Expression. setEvaluatable(TableFilter tableFilter, boolean value)
Tell the expression columns whether the table filter can return values now.void
ExpressionColumn. setEvaluatable(TableFilter tableFilter, boolean b)
void
ExpressionList. setEvaluatable(TableFilter tableFilter, boolean b)
void
Operation0. setEvaluatable(TableFilter tableFilter, boolean value)
void
Operation1_2. setEvaluatable(TableFilter tableFilter, boolean value)
void
Operation1. setEvaluatable(TableFilter tableFilter, boolean value)
void
Operation2. setEvaluatable(TableFilter tableFilter, boolean value)
void
OperationN. setEvaluatable(TableFilter tableFilter, boolean value)
void
SimpleCase. setEvaluatable(TableFilter tableFilter, boolean value)
void
Subquery. setEvaluatable(TableFilter tableFilter, boolean b)
void
Wildcard. setEvaluatable(TableFilter tableFilter, boolean b)
-
Uses of TableFilter in org.h2.expression.aggregate
Methods in org.h2.expression.aggregate with parameters of type TableFilter Modifier and Type Method Description void
AbstractAggregate. setEvaluatable(TableFilter tableFilter, boolean b)
void
Aggregate. setEvaluatable(TableFilter tableFilter, boolean b)
-
Uses of TableFilter in org.h2.expression.analysis
Methods in org.h2.expression.analysis with parameters of type TableFilter Modifier and Type Method Description void
DataAnalysisOperation. setEvaluatable(TableFilter tableFilter, boolean b)
void
Window. setEvaluatable(TableFilter tableFilter, boolean value)
Tell the expression columns whether the table filter can return values now.void
WindowFunction. setEvaluatable(TableFilter tableFilter, boolean b)
-
Uses of TableFilter in org.h2.expression.condition
Methods in org.h2.expression.condition with parameters of type TableFilter Modifier and Type Method Description void
ConditionAndOr. addFilterConditions(TableFilter filter)
void
ConditionAndOrN. addFilterConditions(TableFilter filter)
void
ConditionLocalAndGlobal. addFilterConditions(TableFilter filter)
void
BetweenPredicate. createIndexConditions(SessionLocal session, TableFilter filter)
void
BooleanTest. createIndexConditions(SessionLocal session, TableFilter filter)
void
CompareLike. createIndexConditions(SessionLocal session, TableFilter filter)
void
Comparison. createIndexConditions(SessionLocal session, TableFilter filter)
(package private) static void
Comparison. createIndexConditions(TableFilter filter, Expression left, Expression right, int compareType)
void
ConditionAndOr. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionAndOrN. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionIn. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionInConstantSet. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionInParameter. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionInQuery. createIndexConditions(SessionLocal session, TableFilter filter)
void
ConditionLocalAndGlobal. createIndexConditions(SessionLocal session, TableFilter filter)
void
NullPredicate. createIndexConditions(SessionLocal session, TableFilter filter)
private static void
NullPredicate. createNullIndexCondition(TableFilter filter, ExpressionColumn c)
void
BetweenPredicate. setEvaluatable(TableFilter tableFilter, boolean value)
void
CompareLike. setEvaluatable(TableFilter tableFilter, boolean b)
void
Comparison. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionAndOr. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionAndOrN. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionIn. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionInConstantSet. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionInParameter. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionInQuery. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionLocalAndGlobal. setEvaluatable(TableFilter tableFilter, boolean b)
void
ConditionNot. setEvaluatable(TableFilter tableFilter, boolean b)
void
IsJsonPredicate. setEvaluatable(TableFilter tableFilter, boolean b)
void
PredicateWithSubquery. setEvaluatable(TableFilter tableFilter, boolean value)
void
SimplePredicate. setEvaluatable(TableFilter tableFilter, boolean b)
-
Uses of TableFilter in org.h2.expression.function
Methods in org.h2.expression.function with parameters of type TableFilter Modifier and Type Method Description void
Function0_1. setEvaluatable(TableFilter tableFilter, boolean value)
void
JavaFunction. setEvaluatable(TableFilter tableFilter, boolean b)
-
Uses of TableFilter in org.h2.index
Methods in org.h2.index with parameters of type TableFilter 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 TableFilter Constructor Description ViewIndex(TableView view, ViewIndex index, SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder)
Constructor for plan item generation. -
Uses of TableFilter in org.h2.mvstore.db
Methods in org.h2.mvstore.db with parameters of type TableFilter 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)
-
Uses of TableFilter in org.h2.result
Methods in org.h2.result with parameters of type TableFilter Modifier and Type Method Description Column
SortOrder. getColumn(int index, TableFilter filter)
Get the column for the given table filter, if the sort column is for this filter. -
Uses of TableFilter in org.h2.table
Fields in org.h2.table declared as TableFilter Modifier and Type Field Description private TableFilter[]
Plan. allFilters
private TableFilter
TableFilter. commonJoinColumnsFilter
private TableFilter[]
Plan. filters
private TableFilter
TableFilter. join
The joined table (if there is one).private TableFilter
TableFilter. nestedJoin
The nested joined table (if there is one).Fields in org.h2.table with type parameters of type TableFilter Modifier and Type Field Description static java.util.Comparator<TableFilter>
TableFilter. ORDER_IN_FROM_COMPARATOR
Comparator that uses order in FROM clause as a sort key.private java.util.HashMap<TableFilter,PlanItem>
Plan. planItems
Methods in org.h2.table that return TableFilter Modifier and Type Method Description TableFilter
TableFilter. getCommonJoinColumnsFilter()
Returns common join columns table filter.TableFilter[]
Plan. getFilters()
The the list of tables.TableFilter
TableFilter. getJoin()
TableFilter
TableFilter. getNestedJoin()
default TableFilter
ColumnResolver. getTableFilter()
Get the table filter.TableFilter
TableFilter. getTableFilter()
Methods in org.h2.table with parameters of type TableFilter Modifier and Type Method Description void
TableFilter.MapColumnsVisitor. accept(TableFilter f)
void
TableFilter.TableFilterVisitor. accept(TableFilter f)
This method is called for each nested or joined table filter.void
TableFilter. addCommonJoinColumns(Column leftColumn, Column replacementColumn, TableFilter replacementFilter)
Add a column to the common join column list for a left table filter.void
TableFilter. addJoin(TableFilter filter, boolean outer, Expression on)
Add a joined table.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
TableFilter. getBestPlanItem(SessionLocal s, TableFilter[] filters, int filter, AllColumnsForPlan allColumnsSet)
Get the best plan item (index, cost) to use for the current join order.PlanItem
TableView. getBestPlanItem(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet)
private static IndexHints
Table. getIndexHints(TableFilter[] filters, int filter)
PlanItem
Plan. getItem(TableFilter filter)
Get the plan item for the given table.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)
private void
Plan. setEvaluatable(TableFilter filter, boolean b)
void
TableFilter. setEvaluatable(TableFilter filter, boolean b)
Update the filter and join conditions of this and all joined tables with the information that the given table filter and all nested filter can now return rows or not.void
TableFilter. setNestedJoin(TableFilter filter)
Set a nested joined table.Constructors in org.h2.table with parameters of type TableFilter Constructor Description Plan(TableFilter[] filters, int count, Expression condition)
Create a query plan with the given order.
-