Package org.h2.expression.condition
Class PredicateWithSubquery
java.lang.Object
org.h2.expression.Expression
org.h2.expression.condition.Condition
org.h2.expression.condition.PredicateWithSubquery
- Direct Known Subclasses:
ConditionInQuery
,ExistsPredicate
,UniquePredicate
Base class for predicates with a subquery.
-
Field Summary
FieldsFields inherited from class org.h2.expression.Expression
AUTO_PARENTHESES, MAP_IN_AGGREGATE, MAP_IN_WINDOW, MAP_INITIAL, WITH_PARENTHESES, WITHOUT_PARENTHESES
Fields inherited from interface org.h2.util.HasSQL
ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionint
getCost()
Estimate the cost to process the expression.getUnenclosedSQL
(StringBuilder builder, int sqlFlags) Get the SQL statement of this expression.boolean
isEverything
(ExpressionVisitor visitor) Check if this expression and all sub-expressions can fulfill a criteria.void
mapColumns
(ColumnResolver resolver, int level, int state) Map the columns of the resolver to expression columns.optimize
(SessionLocal session) Try to optimize the expression.void
setEvaluatable
(TableFilter tableFilter, boolean value) Tell the expression columns whether the table filter can return values now.void
updateAggregate
(SessionLocal session, int stage) Update an aggregate value.Methods inherited from class org.h2.expression.condition.Condition
castToBoolean, getType
Methods inherited from class org.h2.expression.Expression
addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNotIfPossible, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getSubexpression, getSubexpressionCount, getTableAlias, getTableName, getValue, getWhenSQL, getWhenValue, isConstant, isIdentity, isNullConstant, isValueSet, isWhenConditionOperand, needParentheses, optimizeCondition, toString, writeExpressions, writeExpressions
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.h2.util.HasSQL
getTraceSQL
-
Field Details
-
query
The subquery.
-
-
Constructor Details
-
PredicateWithSubquery
PredicateWithSubquery(Query query)
-
-
Method Details
-
mapColumns
Description copied from class:Expression
Map the columns of the resolver to expression columns.- Specified by:
mapColumns
in classExpression
- Parameters:
resolver
- the column resolverlevel
- the subquery nesting levelstate
- current state for nesting checks, initial value isExpression.MAP_INITIAL
-
optimize
Description copied from class:Expression
Try to optimize the expression.- Specified by:
optimize
in classExpression
- Parameters:
session
- the session- Returns:
- the optimized expression
-
setEvaluatable
Description copied from class:Expression
Tell the expression columns whether the table filter can return values now. This is used when optimizing the query.- Specified by:
setEvaluatable
in classExpression
- Parameters:
tableFilter
- the table filtervalue
- true if the table filter can return value
-
getUnenclosedSQL
Description copied from class:Expression
Get the SQL statement of this expression. This may not always be the original SQL statement, especially after optimization. Enclosing '(' and ')' are never appended.- Specified by:
getUnenclosedSQL
in classExpression
- Parameters:
builder
- string buildersqlFlags
- formatting flags- Returns:
- the specified string builder
-
updateAggregate
Description copied from class:Expression
Update an aggregate value. This method is called at statement execution time. It is usually called once for each row, but if the expression is used multiple times (for example in the column list, and as part of the HAVING expression) it is called multiple times - the row counter needs to be used to make sure the internal state is only updated once.- Specified by:
updateAggregate
in classExpression
- Parameters:
session
- the sessionstage
- select stage
-
isEverything
Description copied from class:Expression
Check if this expression and all sub-expressions can fulfill a criteria. If any part returns false, the result is false.- Specified by:
isEverything
in classExpression
- Parameters:
visitor
- the visitor- Returns:
- if the criteria can be fulfilled
-
getCost
public int getCost()Description copied from class:Expression
Estimate the cost to process the expression. Used when optimizing the query, to calculate the query plan with the lowest estimated cost.- Specified by:
getCost
in classExpression
- Returns:
- the estimated cost
-