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, 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 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 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 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()
final 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)
final void	FilteredDataChangeStatement.setTableFilter(TableFilter tableFilter)
void	MergeUsing.setTargetTableFilter(TableFilter targetTableFilter)

Constructors in org.h2.command.dml with parameters of type TableFilter

Modifier	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 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 TableFilter

Modifier and Type	Field	Description
private final ArrayList<TableFilter>	Select.filters
private final 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
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, 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 TableFilter

Modifier	Constructor	Description
	AllColumnsForPlan(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 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 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 TableFilter

Modifier	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 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 TableFilter

Modifier and Type	Field	Description
static 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 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

Modifier	Constructor	Description
	Plan(TableFilter[] filters, int count, Expression condition)	Create a query plan with the given order.