Uses of Class
org.h2.table.TableFilter
Packages that use TableFilter
Package
Description
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.dml
Methods in org.h2.command.dml that return TableFilterModifier and TypeMethodDescriptionMergeUsing.getSourceTableFilter()MergeUsing.getTargetTableFilter()Methods in org.h2.command.dml with parameters of type TableFilterModifier and TypeMethodDescriptionvoidUpdate.setFromTableFilter(TableFilter tableFilter) voidMergeUsing.setSourceTableFilter(TableFilter sourceTableFilter) voidMergeUsing.setTargetTableFilter(TableFilter targetTableFilter) Constructors in org.h2.command.dml with parameters of type TableFilter -
Uses of TableFilter in org.h2.command.query
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 TypeMethodDescriptionvoidSelect.addTableFilter(TableFilter filter, boolean isTop) Add a table to the query.abstract voidQuery.setEvaluatable(TableFilter tableFilter, boolean b) Change the evaluatable flag.voidSelect.setEvaluatable(TableFilter tableFilter, boolean b) voidSelectUnion.setEvaluatable(TableFilter tableFilter, boolean b) voidTableValueConstructor.setEvaluatable(TableFilter tableFilter, boolean b) Constructors in org.h2.command.query with parameters of type TableFilter -
Uses of TableFilter in org.h2.constraint
Methods 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 TypeMethodDescriptionvoidExpression.addFilterConditions(TableFilter filter) Add conditions to a table filter if they can be evaluated.static voidExpressionVisitor.allColumnsForTableFilters(TableFilter[] filters, AllColumnsForPlan allColumnsSet) Get the set of columns of all tables.voidExpression.createIndexConditions(SessionLocal session, TableFilter filter) Create index conditions if possible and attach them to the table filter.voidExpressionColumn.createIndexConditions(SessionLocal session, TableFilter filter) voidValueExpression.createIndexConditions(SessionLocal session, TableFilter filter) voidAlias.setEvaluatable(TableFilter tableFilter, boolean b) voidArrayConstructorByQuery.setEvaluatable(TableFilter tableFilter, boolean value) abstract voidExpression.setEvaluatable(TableFilter tableFilter, boolean value) Tell the expression columns whether the table filter can return values now.voidExpressionColumn.setEvaluatable(TableFilter tableFilter, boolean b) voidExpressionList.setEvaluatable(TableFilter tableFilter, boolean b) voidOperation0.setEvaluatable(TableFilter tableFilter, boolean value) voidOperation1_2.setEvaluatable(TableFilter tableFilter, boolean value) voidOperation1.setEvaluatable(TableFilter tableFilter, boolean value) voidOperation2.setEvaluatable(TableFilter tableFilter, boolean value) voidOperationN.setEvaluatable(TableFilter tableFilter, boolean value) voidSimpleCase.setEvaluatable(TableFilter tableFilter, boolean value) voidSubquery.setEvaluatable(TableFilter tableFilter, boolean b) voidWildcard.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 TypeMethodDescriptionvoidAbstractAggregate.setEvaluatable(TableFilter tableFilter, boolean b) voidAggregate.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 TypeMethodDescriptionvoidDataAnalysisOperation.setEvaluatable(TableFilter tableFilter, boolean b) voidWindow.setEvaluatable(TableFilter tableFilter, boolean value) Tell the expression columns whether the table filter can return values now.voidWindowFunction.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 TypeMethodDescriptionvoidConditionAndOr.addFilterConditions(TableFilter filter) voidConditionAndOrN.addFilterConditions(TableFilter filter) voidConditionLocalAndGlobal.addFilterConditions(TableFilter filter) voidBetweenPredicate.createIndexConditions(SessionLocal session, TableFilter filter) voidBooleanTest.createIndexConditions(SessionLocal session, TableFilter filter) voidCompareLike.createIndexConditions(SessionLocal session, TableFilter filter) voidComparison.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionAndOr.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionAndOrN.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionIn.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionInConstantSet.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionInParameter.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionInQuery.createIndexConditions(SessionLocal session, TableFilter filter) voidConditionLocalAndGlobal.createIndexConditions(SessionLocal session, TableFilter filter) voidNullPredicate.createIndexConditions(SessionLocal session, TableFilter filter) voidBetweenPredicate.setEvaluatable(TableFilter tableFilter, boolean value) voidCompareLike.setEvaluatable(TableFilter tableFilter, boolean b) voidComparison.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionAndOr.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionAndOrN.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionIn.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionInConstantSet.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionInParameter.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionInQuery.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionLocalAndGlobal.setEvaluatable(TableFilter tableFilter, boolean b) voidConditionNot.setEvaluatable(TableFilter tableFilter, boolean b) voidIsJsonPredicate.setEvaluatable(TableFilter tableFilter, boolean b) voidSimplePredicate.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 TypeMethodDescriptionvoidFunction0_1.setEvaluatable(TableFilter tableFilter, boolean value) voidJavaFunction.setEvaluatable(TableFilter tableFilter, boolean b) -
Uses of TableFilter in org.h2.index
Methods in org.h2.index with parameters of type TableFilterModifier and TypeMethodDescriptiondoubleDualIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) abstract doubleIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Estimate the cost to search for rows given the search mask.doubleLinkedIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleMetaIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleRangeIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleViewIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleVirtualConstructedTableIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) protected final longIndex.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 TypeMethodDescriptiondoubleMVDelegateIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleMVPrimaryIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleMVSecondaryIndex.getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) doubleMVSpatialIndex.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 with type parameters of type TableFilterModifier and TypeFieldDescriptionstatic final Comparator<TableFilter> TableFilter.ORDER_IN_FROM_COMPARATORComparator that uses order in FROM clause as a sort key.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 TableFilterColumnResolver.getTableFilter()Get the table filter.TableFilter.getTableFilter()Methods in org.h2.table with parameters of type TableFilterModifier and TypeMethodDescriptionvoidTableFilter.TableFilterVisitor.accept(TableFilter f) This method is called for each nested or joined table filter.voidTableFilter.addCommonJoinColumns(Column leftColumn, Column replacementColumn, TableFilter replacementFilter) Add a column to the common join column list for a left table filter.voidTableFilter.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) 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) voidTableFilter.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.voidTableFilter.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.