Uses of Class
org.h2.table.TableFilter
Packages that use TableFilter
Package
Description
This package contains the parser and the base classes for prepared SQL statements.
Contains DML (data manipulation language) and related SQL statements.
Contains queries.
Database constraints such as check constraints, unique constraints, and referential constraints.
Expressions include mathematical operations, simple values, and others.
Aggregate functions.
Base classes for data analysis operations and implementations of window functions.
Condition expressions.
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 TableFilter in org.h2.command
Methods in org.h2.command that return TableFilterModifier and TypeMethodDescriptionprivate TableFilter
Parser.buildTableFilter
(Table table, String alias, ArrayList<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 TableFilterModifier and TypeMethodDescriptionprivate 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 String
Parser.readTableColumn
(TableFilter filter, String tableAlias) private SetClauseList
Parser.readUpdateSetClause
(TableFilter filter) -
Uses of TableFilter in org.h2.command.dml
Fields in org.h2.command.dml declared as TableFilterModifier and TypeFieldDescriptionprivate 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 TableFilterModifier and TypeMethodDescriptionMergeUsing.getSourceTableFilter()
final TableFilter
FilteredDataChangeStatement.getTableFilter()
MergeUsing.getTargetTableFilter()
Methods in org.h2.command.dml with parameters of type TableFilterModifier and TypeMethodDescriptionvoid
Update.setFromTableFilter
(TableFilter tableFilter) void
MergeUsing.setSourceTableFilter
(TableFilter sourceTableFilter) final void
FilteredDataChangeStatement.setTableFilter
(TableFilter tableFilter) void
MergeUsing.setTargetTableFilter
(TableFilter targetTableFilter) Constructors in org.h2.command.dml with parameters of type TableFilter -
Uses of TableFilter in org.h2.command.query
Fields in org.h2.command.query declared as TableFilterModifier and TypeFieldDescriptionprivate final TableFilter[]
AllColumnsForPlan.filters
private final 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 TableFilterModifier and TypeFieldDescriptionprivate final ArrayList
<TableFilter> Select.filters
private final ArrayList
<TableFilter> Select.topFilters
Methods in org.h2.command.query that return TableFilterMethods in org.h2.command.query that return types with arguments of type TableFilterMethods in org.h2.command.query with parameters of type TableFilterModifier and TypeMethodDescriptionprivate int
Select.addExpandedColumn
(TableFilter filter, int index, HashMap<Column, ExpressionColumn> except, String schema, 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, HashMap<Column, ExpressionColumn> except) private static boolean
Select.getPlanFromFilter
(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 TableFilterModifierConstructorDescriptionAllColumnsForPlan
(TableFilter[] filters) (package private)
Optimizer
(TableFilter[] filters, Expression condition, SessionLocal session) -
Uses of TableFilter in org.h2.constraint
Fields in org.h2.constraint declared as TableFilterMethods in org.h2.constraint with parameters of type TableFilter -
Uses of TableFilter in org.h2.expression
Methods in org.h2.expression that return TableFilterMethods in org.h2.expression with parameters of type TableFilterModifier and TypeMethodDescriptionvoid
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 TableFilterModifier and TypeMethodDescriptionvoid
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 TableFilterModifier and TypeMethodDescriptionvoid
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 TableFilterModifier and TypeMethodDescriptionvoid
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 TableFilterModifier and TypeMethodDescriptionvoid
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 TableFilterModifier 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 TableFilterModifierConstructorDescriptionViewIndex
(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 TableFilterModifier 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) -
Uses of TableFilter in org.h2.result
Methods in org.h2.result with parameters of type TableFilterModifier and TypeMethodDescriptionSortOrder.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 TableFilterModifier and TypeFieldDescriptionprivate final TableFilter[]
Plan.allFilters
private TableFilter
TableFilter.commonJoinColumnsFilter
private final 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 TableFilterModifier and TypeFieldDescriptionstatic final Comparator
<TableFilter> TableFilter.ORDER_IN_FROM_COMPARATOR
Comparator that uses order in FROM clause as a sort key.private final HashMap
<TableFilter, PlanItem> Plan.planItems
Methods in org.h2.table that return TableFilterModifier and TypeMethodDescriptionTableFilter.getCommonJoinColumnsFilter()
Returns common join columns table filter.Plan.getFilters()
The the list of tables.TableFilter.getJoin()
TableFilter.getNestedJoin()
default TableFilter
ColumnResolver.getTableFilter()
Get the table filter.TableFilter.getTableFilter()
Methods in org.h2.table with parameters of type TableFilterModifier and TypeMethodDescriptionvoid
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.Table.getBestPlanItem
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Get the best plan for the given search mask.TableFilter.getBestPlanItem
(SessionLocal s, TableFilter[] filters, int filter, AllColumnsForPlan allColumnsSet) Get the best plan item (index, cost) to use for the current join order.TableView.getBestPlanItem
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) private static IndexHints
Table.getIndexHints
(TableFilter[] filters, int filter) Plan.getItem
(TableFilter filter) Get the plan item for the given table.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) 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 TableFilterModifierConstructorDescriptionPlan
(TableFilter[] filters, int count, Expression condition) Create a query plan with the given order.