Top Description Fields Constructors Methods
org.h2.mode

public final Class FunctionsMSSQLServer

extends ModeFunction
Class Inheritance
Imports
java.util.HashMap, org.h2.api.ErrorCode, org.h2.engine.SessionLocal, org.h2.expression.Expression, .TypedValueExpression, .ValueExpression, org.h2.expression.function.CoalesceFunction, .CurrentDateTimeValueFunction, .RandFunction, .StringFunction, org.h2.message.DbException, org.h2.value.TypeInfo, .Value, .ValueBigint, .ValueInteger, .ValueNull
Functions for org.h2.engine.Mode.ModeEnum#MSSQLServer compatibility mode.

Field Summary

Modifier and TypeField and Description
private static final int
CHARINDEX

private static final HashMap<String, FunctionInfo>
FUNCTIONS

private static final int
GETDATE

private static final int
ISNULL

private static final int
LEN

private static final int
NEWID

private static final int
NEWSEQUENTIALID

private static final int
SCOPE_IDENTITY

private static final TypeInfo
SCOPE_IDENTITY_TYPE

Inherited from org.h2.mode.ModeFunction:
infoVAR_ARGS

Constructor Summary

AccessConstructor and Description
private
FunctionsMSSQLServer(FunctionInfo info)

Method Summary

Modifier and TypeMethod and Description
protected void
checkParameterCount(int
the number of parameters set
len)

Overrides org.h2.mode.ModeFunction.checkParameterCount.

Check if the parameter count is correct.

public static FunctionsMSSQLServer

Returns:

the function with specified name or null
getFunction(String
the upper-case name of a function
upperName)

Returns mode-specific function for a given name, or null.

public Value
getValue(SessionLocal
the session
session)

Overrides org.h2.expression.function.FunctionN.getValue.

Return the resulting value for the current row.

public Expression
optimize(SessionLocal
the session
session)

Implements abstract org.h2.expression.Expression.optimize.

Try to optimize the expression.

Inherited from org.h2.mode.ModeFunction:
doneWithParametersgetArgumentsValuesgetCompatibilityDateTimeValueFunctiongetFunctiongetNamegetNullOrValueisEverythingoptimizeArguments

Field Detail

CHARINDEXback to summary
private static final int CHARINDEX
FUNCTIONSback to summary
private static final HashMap<String, FunctionInfo> FUNCTIONS
GETDATEback to summary
private static final int GETDATE
ISNULLback to summary
private static final int ISNULL
LENback to summary
private static final int LEN
NEWIDback to summary
private static final int NEWID
NEWSEQUENTIALIDback to summary
private static final int NEWSEQUENTIALID
SCOPE_IDENTITYback to summary
private static final int SCOPE_IDENTITY
SCOPE_IDENTITY_TYPEback to summary
private static final TypeInfo SCOPE_IDENTITY_TYPE

Constructor Detail

FunctionsMSSQLServerback to summary
private FunctionsMSSQLServer(FunctionInfo info)

Method Detail

checkParameterCountback to summary
protected void checkParameterCount(int len)

Overrides org.h2.mode.ModeFunction.checkParameterCount.

Doc from org.h2.mode.ModeFunction.checkParameterCount.

Check if the parameter count is correct.

Parameters
len:int

the number of parameters set

Annotations
@Override
getFunctionback to summary
public static FunctionsMSSQLServer getFunction(String upperName)

Returns mode-specific function for a given name, or null.

Parameters
upperName:String

the upper-case name of a function

Returns:FunctionsMSSQLServer

the function with specified name or null

getValueback to summary
public Value getValue(SessionLocal session)

Overrides org.h2.expression.function.FunctionN.getValue.

Doc from org.h2.expression.Expression.getValue.

Return the resulting value for the current row.

Parameters
session:SessionLocal

the session

Returns:Value

the result

Annotations
@Override
optimizeback to summary
public Expression optimize(SessionLocal session)

Implements abstract org.h2.expression.Expression.optimize.

Doc from org.h2.expression.Expression.optimize.

Try to optimize the expression.

Parameters
session:SessionLocal

the session

Returns:Expression

the optimized expression

Annotations
@Override