Package org.h2.expression.function
Class CoalesceFunction
java.lang.Object
org.h2.expression.Expression
org.h2.expression.OperationN
org.h2.expression.function.FunctionN
org.h2.expression.function.CoalesceFunction
- All Implemented Interfaces:
ExpressionWithVariableParameters
,NamedExpression
,HasSQL
,Typed
A COALESCE, GREATEST, or LEAST function.
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final int
COALESCE().private final int
static final int
GREATEST() (non-standard).static final int
LEAST() (non-standard).private static final String[]
Fields inherited from class org.h2.expression.OperationN
args, argsCount, type
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
ConstructorsConstructorDescriptionCoalesceFunction
(int function) CoalesceFunction
(int function, Expression... args) -
Method Summary
Modifier and TypeMethodDescriptiongetName()
Get the name.getValue
(SessionLocal session) Return the resulting value for the current row.optimize
(SessionLocal session) Try to optimize the expression.Methods inherited from class org.h2.expression.function.FunctionN
getUnenclosedSQL, getValue
Methods inherited from class org.h2.expression.OperationN
addParameter, doneWithParameters, getCost, getSubexpression, getSubexpressionCount, getType, isEverything, mapColumns, optimizeArguments, setEvaluatable, updateAggregate
Methods inherited from class org.h2.expression.Expression
addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNotIfPossible, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getTableAlias, getTableName, 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
-
COALESCE
public static final int COALESCECOALESCE().- See Also:
-
GREATEST
public static final int GREATESTGREATEST() (non-standard).- See Also:
-
LEAST
public static final int LEASTLEAST() (non-standard).- See Also:
-
NAMES
-
function
private final int function
-
-
Constructor Details
-
CoalesceFunction
public CoalesceFunction(int function) -
CoalesceFunction
-
-
Method Details
-
getValue
Description copied from class:Expression
Return the resulting value for the current row. -
optimize
Description copied from class:Expression
Try to optimize the expression.- Specified by:
optimize
in classExpression
- Parameters:
session
- the session- Returns:
- the optimized expression
-
getName
Description copied from interface:NamedExpression
Get the name.- Returns:
- the name in uppercase
-