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
abstract class PredicateWithSubquery extends Condition
Base class for predicates with a subquery.
-
-
Field Summary
Fields Modifier and Type Field Description (package private) Query
query
The subquery.-
Fields 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 Constructor Description PredicateWithSubquery(Query query)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description int
getCost()
Estimate the cost to process the expression.java.lang.StringBuilder
getUnenclosedSQL(java.lang.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.Expression
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 Detail
-
query
final Query query
The subquery.
-
-
Constructor Detail
-
PredicateWithSubquery
PredicateWithSubquery(Query query)
-
-
Method Detail
-
mapColumns
public void mapColumns(ColumnResolver resolver, int level, int state)
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
public Expression optimize(SessionLocal session)
Description copied from class:Expression
Try to optimize the expression.- Specified by:
optimize
in classExpression
- Parameters:
session
- the session- Returns:
- the optimized expression
-
setEvaluatable
public void setEvaluatable(TableFilter tableFilter, boolean value)
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
public java.lang.StringBuilder getUnenclosedSQL(java.lang.StringBuilder builder, int sqlFlags)
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
public void updateAggregate(SessionLocal session, int stage)
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
public boolean isEverything(ExpressionVisitor visitor)
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
-
-