Package org.h2.expression
Class Parameter
java.lang.Object
org.h2.expression.Expression
org.h2.expression.Operation0
org.h2.expression.Parameter
- All Implemented Interfaces:
ParameterInterface
,HasSQL
,Typed
A parameter of a prepared statement.
-
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 TypeMethodDescriptionvoid
checkSet()
Check if the value is set.int
getCost()
Estimate the cost to process the expression.int
getIndex()
getNotIfPossible
(SessionLocal session) If it is possible, return the negated expression.Get the value of the parameter if set.getType()
Returns the data type.getUnenclosedSQL
(StringBuilder builder, int sqlFlags) Get the SQL statement of this expression.getValue
(SessionLocal session) Return the resulting value for the current row.boolean
isEverything
(ExpressionVisitor visitor) Check if this expression and all sub-expressions can fulfill a criteria.boolean
Is the value of a parameter set.optimize
(SessionLocal session) Try to optimize the expression.void
void
void
Set the value of the parameter.Methods inherited from class org.h2.expression.Operation0
mapColumns, setEvaluatable, updateAggregate
Methods inherited from class org.h2.expression.Expression
addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getSubexpression, getSubexpressionCount, getTableAlias, getTableName, getWhenSQL, getWhenValue, isConstant, isIdentity, isNullConstant, 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
Methods inherited from interface org.h2.expression.ParameterInterface
getNullable
-
Field Details
-
value
-
column
-
index
private final int index
-
-
Constructor Details
-
Parameter
public Parameter(int index)
-
-
Method Details
-
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
-
setValue
Description copied from interface:ParameterInterface
Set the value of the parameter.- Specified by:
setValue
in interfaceParameterInterface
- Parameters:
v
- the new valuecloseOld
- if the old value (if one is set) should be closed
-
setValue
-
getParamValue
Description copied from interface:ParameterInterface
Get the value of the parameter if set.- Specified by:
getParamValue
in interfaceParameterInterface
- Returns:
- the value or null
-
getValue
Description copied from class:Expression
Return the resulting value for the current row.- Specified by:
getValue
in classExpression
- Parameters:
session
- the session- Returns:
- the result
-
getType
Description copied from class:Expression
Returns the data type. The data type may be unknown before the optimization phase.- Specified by:
getType
in interfaceParameterInterface
- Specified by:
getType
in interfaceTyped
- Specified by:
getType
in classExpression
- Returns:
- the data type
-
checkSet
public void checkSet()Description copied from interface:ParameterInterface
Check if the value is set.- Specified by:
checkSet
in interfaceParameterInterface
-
optimize
Description copied from class:Expression
Try to optimize the expression.- Overrides:
optimize
in classOperation0
- Parameters:
session
- the session- Returns:
- the optimized expression
-
isValueSet
public boolean isValueSet()Description copied from class:Expression
Is the value of a parameter set.- Specified by:
isValueSet
in interfaceParameterInterface
- Overrides:
isValueSet
in classExpression
- Returns:
- true if set
-
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
-
getNotIfPossible
Description copied from class:Expression
If it is possible, return the negated expression. This is used to optimize NOT expressions: NOT ID>10 can be converted to ID<=10. Returns null if negating is not possible.- Overrides:
getNotIfPossible
in classExpression
- Parameters:
session
- the session- Returns:
- the negated expression, or null
-
setColumn
-
getIndex
public int getIndex()
-