Uses of Class
org.h2.expression.Expression

Packages that use Expression

Package	Description
org.h2.command	This package contains the parser and the base classes for prepared SQL statements.
org.h2.command.ddl	Contains DDL (data definition language) and related SQL statements.
org.h2.command.dml	Contains DML (data manipulation language) and related SQL statements.
org.h2.command.query	Contains queries.
org.h2.constraint	Database constraints such as check constraints, unique constraints, and referential constraints.
org.h2.expression	Expressions include mathematical operations, simple values, and others.
org.h2.expression.aggregate	Aggregate functions.
org.h2.expression.analysis	Base classes for data analysis operations and implementations of window functions.
org.h2.expression.condition	Condition expressions.
org.h2.expression.function	Functions.
org.h2.expression.function.table	Table value functions.
org.h2.index	Various table index implementations, as well as cursors to navigate in an index.
org.h2.mode	Utility classes for compatibility with other database, for example MySQL.
org.h2.mvstore.db	Helper classes to use the MVStore in the H2 database.
org.h2.result	Implementation of row and internal result sets.
org.h2.schema	Schema implementation and objects that are stored in a schema (for example, sequences and constants).
org.h2.table	Classes related to a table and table meta data.

Uses of Expression in org.h2.command

Methods in org.h2.command that return Expression

Modifier and Type	Method	Description
Expression	Parser.parseDomainConstraintExpression(String sql)	Parse a SQL code snippet that represents an expression for a domain constraint.
Expression	Parser.parseExpression(String sql)	Parse a SQL code snippet that represents an expression.

Methods in org.h2.command with parameters of type Expression

Modifier and Type	Method	Description
static String	Prepared.getSimpleSQL(Expression[] list)	Get the SQL snippet of the expression list.

Uses of Expression in org.h2.command.ddl

Methods in org.h2.command.ddl with parameters of type Expression

Modifier and Type	Method	Description
void	SequenceOptions.setCacheSize(Expression cacheSize)	Sets cache size.
void	AlterDomainAddConstraint.setCheckExpression(Expression expression)
void	AlterTableAddConstraint.setCheckExpression(Expression expression)
void	SetComment.setCommentExpression(Expression expr)
void	AlterTableAlterColumn.setDefaultExpression(Expression defaultExpression)	Set default or on update expression.
void	CreateDomain.setDefaultExpression(Expression defaultExpression)
void	AlterDomainExpressions.setExpression(Expression expression)
void	CreateConstant.setExpression(Expression expr)
void	AlterUser.setHash(Expression e)
void	CreateUser.setHash(Expression e)
void	SequenceOptions.setIncrement(Expression increment)	Sets increment value expression.
void	SequenceOptions.setMaxValue(Expression maxValue)	Sets max value expression.
void	SequenceOptions.setMinValue(Expression minValue)	Sets min value expression.
void	CreateDomain.setOnUpdateExpression(Expression onUpdateExpression)
void	AlterUser.setPassword(Expression password)
void	CreateUser.setPassword(Expression password)
void	SequenceOptions.setRestartValue(Expression restart)	Sets restart value expression, or ValueExpression.DEFAULT.
void	AlterUser.setSalt(Expression e)
void	CreateUser.setSalt(Expression e)
void	AlterTableAlterColumn.setSelectivity(Expression selectivity)
void	SequenceOptions.setStartValue(Expression start)	Sets start value expression.
void	AlterTableAlterColumn.setUsingExpression(Expression usingExpression)	Set using expression.

Uses of Expression in org.h2.command.dml

Methods in org.h2.command.dml that return Expression

Modifier and Type	Method	Description
Expression	MergeUsing.getOnCondition()

Methods in org.h2.command.dml with parameters of type Expression

Modifier and Type	Method	Description
void	Insert.addAssignmentForDuplicate(Column column, Expression expression)	Keep a collection of the columns to pass to update if a duplicate key happens, for MySQL-style INSERT ...
void	SetClauseList.addMultiple(ArrayList<Column> columns, Expression expression)	Add multiple columns.
void	CommandWithValues.addRow(Expression[] expr)	Add a row to this command.
void	SetClauseList.addSingle(Column column, Expression expression)	Add a single column.
void	MergeUsing.When.setAndCondition(Expression andCondition)	Sets the specified AND condition.
void	Call.setExpression(Expression expression)
void	ExecuteProcedure.setExpression(int index, Expression expr)	Set the expression at the given index.
void	Set.setExpression(Expression expression)
void	BackupCommand.setFileName(Expression fileName)
void	MergeUsing.setOnCondition(Expression condition)

Constructors in org.h2.command.dml with parameters of type Expression

Modifier	Constructor	Description
	ExecuteImmediate(SessionLocal session, Expression statement)
	WhenNotMatched(Column[] columns, Boolean overridingSystem, Expression[] values)

Uses of Expression in org.h2.command.query

Fields in org.h2.command.query declared as Expression

Modifier and Type	Field	Description
Expression	QueryOrderBy.columnIndexExpr	The column index expression.
Expression	QueryOrderBy.expression	The order by expression.

Methods in org.h2.command.query that return Expression

Modifier and Type	Method	Description
Expression	Select.getCondition()
Expression	Query.getFetch()
Expression	Select.getHaving()
Expression	Query.getIfSingleRow()	If this query is determined as a single-row query, returns a replacement expression.
Expression	Select.getIfSingleRow()
Expression	TableValueConstructor.getIfSingleRow()
Expression	Query.getOffset()
Expression	Select.getQualify()
Expression	SelectListColumnResolver.optimize(ExpressionColumn expressionColumn, Column column)

Methods in org.h2.command.query that return types with arguments of type Expression

Modifier and Type	Method	Description
ArrayList<Expression>	Query.getExpressions()	The the list of select expressions.
ArrayList<Expression>	Select.getGroupBy()

Methods in org.h2.command.query with parameters of type Expression

Modifier and Type	Method	Description
void	Select.addCondition(Expression cond)	Add a condition to the list of conditions.
final Object	SelectGroups.getCurrentGroupExprData(Expression expr)	Get the group-by data for the current group and the passed in expression.
final void	SelectGroups.setCurrentGroupExprData(Expression expr, Object obj)	Set the group-by data for the current group and the passed in expression.
void	Select.setDistinct(Expression[] distinctExpressions)	Set the DISTINCT ON expressions.
void	Query.setFetch(Expression fetch)
void	Select.setHaving(Expression having)
void	Query.setOffset(Expression offset)
void	Select.setQualify(Expression qualify)

Method parameters in org.h2.command.query with type arguments of type Expression

Modifier and Type	Method	Description
static SelectGroups	SelectGroups.getInstance(SessionLocal session, ArrayList<Expression> expressions, boolean isGroupQuery, int[] groupIndex)	Creates new instance of grouped data.
static void	TableValueConstructor.getValuesSQL(StringBuilder builder, int sqlFlags, ArrayList<ArrayList<Expression>> rows)	Appends the SQL of the values to the specified string builder..
static void	TableValueConstructor.getVisibleResult(SessionLocal session, ResultTarget result, Column[] columns, ArrayList<ArrayList<Expression>> rows)	Appends visible columns of all rows to the specified result.
void	Select.setExpressions(ArrayList<Expression> expressions)
void	Select.setGroupBy(ArrayList<Expression> group)

Constructor parameters in org.h2.command.query with type arguments of type Expression

Modifier	Constructor	Description
	TableValueConstructor(SessionLocal session, ArrayList<ArrayList<Expression>> rows)	Creates new instance of table value constructor.

Uses of Expression in org.h2.constraint

Methods in org.h2.constraint that return Expression

Modifier and Type	Method	Description
Expression	ConstraintDomain.getCheckConstraint(SessionLocal session, String columnName)	Get the check constraint expression for this column.
Expression	Constraint.getExpression()	Returns the CHECK expression or null.
Expression	ConstraintCheck.getExpression()
Expression	ConstraintDomain.getExpression()

Methods in org.h2.constraint with parameters of type Expression

Modifier and Type	Method	Description
void	ConstraintCheck.setExpression(Expression expr)
void	ConstraintDomain.setExpression(SessionLocal session, Expression expr)	Set the expression.

Uses of Expression in org.h2.expression

Subclasses of Expression in org.h2.expression

Modifier and Type	Class	Description
final class	Alias	A column alias as in SELECT 'Hello' AS NAME ...
final class	ArrayConstructorByQuery	Array value constructor by query.
final class	ArrayElementReference	Array element reference.
class	BinaryOperation	A mathematical expression, or string concatenation.
class	CompatibilityDatePlusTimeOperation	A compatibility mathematical operation with datetime values.
final class	ConcatenationOperation	Character string concatenation as in 'Hello' || 'World', binary string concatenation as in X'01' || X'AB' or an array concatenation as in ARRAY[1, 2] || 3.
final class	DomainValueExpression	An expression representing a value for domain constraint.
final class	ExpressionColumn	A column reference expression that represents a column of a table or view.
final class	ExpressionList	A list of expressions, as in (ID, NAME).
final class	FieldReference	Field reference.
final class	Format	A format clause such as FORMAT JSON.
class	IntervalOperation	A mathematical operation with intervals.
class	Operation0	Operation without subexpressions.
class	Operation1	Operation with one argument.
class	Operation1_2	Operation with one or two arguments.
class	Operation2	Operation with two arguments.
class	OperationN	Operation with many arguments.
final class	Parameter	A parameter of a prepared statement.
final class	Rownum	Represents the ROWNUM function.
final class	SearchedCase	A searched case.
final class	SequenceValue	Wraps a sequence when used in a statement.
final class	SimpleCase	A simple case.
final class	Subquery	A query returning a single value.
final class	TimeZoneOperation	A time zone specification (AT { TIME ZONE | LOCAL }).
class	TypedValueExpression	An expression representing a constant value with a type cast.
class	UnaryOperation	Unary operation.
class	ValueExpression	An expression representing a constant value.
final class	Variable	A user-defined variable, for example: @ID.
final class	Wildcard	A wildcard expression as in SELECT * FROM TEST.

Fields in org.h2.expression declared as Expression

Modifier and Type	Field	Description
protected Expression	Operation1.arg	The argument of the operation.
protected Expression[]	OperationN.args	The array of arguments.
protected Expression	Operation1_2.left	The left part of the operation (the first argument).
protected Expression	Operation2.left	The left part of the operation (the first argument).
protected Expression	Operation1_2.right	The right part of the operation (the second argument).
protected Expression	Operation2.right	The right part of the operation (the second argument).

Methods in org.h2.expression that return Expression

Modifier and Type	Method	Description
Expression	Alias.getNonAliasExpression()
Expression	Expression.getNonAliasExpression()	Returns the main expression, skipping aliases.
Expression	Expression.getNotIfPossible(SessionLocal session)	If it is possible, return the negated expression.
Expression	ExpressionColumn.getNotIfPossible(SessionLocal session)
Expression	Parameter.getNotIfPossible(SessionLocal session)
Expression	ValueExpression.getNotIfPossible(SessionLocal session)
Expression	Expression.getSubexpression(int index)	Returns subexpression with specified index.
Expression	ExpressionList.getSubexpression(int index)
Expression	Operation1_2.getSubexpression(int index)
Expression	Operation1.getSubexpression(int index)
Expression	Operation2.getSubexpression(int index)
Expression	OperationN.getSubexpression(int index)
Expression	SimpleCase.getSubexpression(int index)
Expression	Alias.optimize(SessionLocal session)
Expression	ArrayConstructorByQuery.optimize(SessionLocal session)
Expression	ArrayElementReference.optimize(SessionLocal session)
Expression	BinaryOperation.optimize(SessionLocal session)
Expression	CompatibilityDatePlusTimeOperation.optimize(SessionLocal session)
Expression	ConcatenationOperation.optimize(SessionLocal session)
Expression	DomainValueExpression.optimize(SessionLocal session)
abstract Expression	Expression.optimize(SessionLocal session)	Try to optimize the expression.
Expression	ExpressionColumn.optimize(SessionLocal session)
Expression	ExpressionList.optimize(SessionLocal session)
Expression	FieldReference.optimize(SessionLocal session)
Expression	Format.optimize(SessionLocal session)
Expression	IntervalOperation.optimize(SessionLocal session)
Expression	Operation0.optimize(SessionLocal session)
Expression	Parameter.optimize(SessionLocal session)
Expression	Rownum.optimize(SessionLocal session)
Expression	SearchedCase.optimize(SessionLocal session)
Expression	SimpleCase.optimize(SessionLocal session)
Expression	Subquery.optimize(SessionLocal session)
Expression	TimeZoneOperation.optimize(SessionLocal session)
Expression	UnaryOperation.optimize(SessionLocal session)
Expression	Wildcard.optimize(SessionLocal session)
final Expression	Expression.optimizeCondition(SessionLocal session)	Try to optimize or remove the condition.

Methods in org.h2.expression with parameters of type Expression

Modifier and Type	Method	Description
void	ExpressionWithVariableParameters.addParameter(Expression param)	Adds the parameter expression.
void	OperationN.addParameter(Expression param)
static StringBuilder	Expression.writeExpressions(StringBuilder builder, Expression[] expressions, int sqlFlags)	Get the SQL snippet for an array of expressions.

Method parameters in org.h2.expression with type arguments of type Expression

Modifier and Type	Method	Description
static StringBuilder	Expression.writeExpressions(StringBuilder builder, List<? extends Expression> expressions, int sqlFlags)	Get the SQL snippet for a list of expressions.

Constructors in org.h2.expression with parameters of type Expression

Modifier	Constructor	Description
	Alias(Expression expression, String alias, boolean aliasColumnName)
	ArrayElementReference(Expression left, Expression right)
	BinaryOperation(BinaryOperation.OpType opType, Expression left, Expression right)
	CompatibilityDatePlusTimeOperation(Expression left, Expression right)
	ConcatenationOperation(Expression op1, Expression op2)
	ExpressionList(Expression[] list, boolean isArray)
	FieldReference(Expression arg, String fieldName)
	Format(Expression arg, Format.FormatEnum format)
	IntervalOperation(IntervalOperation.IntervalOpType opType, Expression left, Expression right)
	IntervalOperation(IntervalOperation.IntervalOpType opType, Expression left, Expression right, TypeInfo forcedType)
protected	Operation1(Expression arg)
protected	Operation1_2(Expression left, Expression right)
protected	Operation2(Expression left, Expression right)
protected	OperationN(Expression[] args)
	SearchedCase(Expression[] args)
	SimpleCase(Expression operand, SimpleCase.SimpleWhen when, Expression elseResult)
	SimpleWhen(Expression[] operands, Expression result)
	SimpleWhen(Expression operand, Expression result)
	TimeZoneOperation(Expression left, Expression right)
	UnaryOperation(Expression arg)

Uses of Expression in org.h2.expression.aggregate

Subclasses of Expression in org.h2.expression.aggregate

Modifier and Type	Class	Description
class	AbstractAggregate	A base class for aggregate functions.
class	Aggregate	Implements the integrated aggregate functions, such as COUNT, MAX, SUM.
class	JavaAggregate	This class wraps a user-defined aggregate.

Fields in org.h2.expression.aggregate declared as Expression

Modifier and Type	Field	Description
protected final Expression[]	AbstractAggregate.args	The arguments.
protected Expression	AbstractAggregate.filterCondition	FILTER condition for aggregate

Methods in org.h2.expression.aggregate that return Expression

Modifier and Type	Method	Description
Expression	AbstractAggregate.getSubexpression(int index)
Expression	AbstractAggregate.optimize(SessionLocal session)
Expression	Aggregate.optimize(SessionLocal session)
Expression	JavaAggregate.optimize(SessionLocal session)

Methods in org.h2.expression.aggregate with parameters of type Expression

Modifier and Type	Method	Description
void	AbstractAggregate.setFilterCondition(Expression filterCondition)	Sets the FILTER condition.

Constructors in org.h2.expression.aggregate with parameters of type Expression

Modifier	Constructor	Description
	Aggregate(AggregateType aggregateType, Expression[] args, Select select, boolean distinct)	Create a new aggregate object.
	JavaAggregate(UserAggregate userAggregate, Expression[] args, Select select, boolean distinct)

Uses of Expression in org.h2.expression.analysis

Subclasses of Expression in org.h2.expression.analysis

Modifier and Type	Class	Description
class	DataAnalysisOperation	A base class for data analysis operations such as aggregates and window functions.
class	WindowFunction	A window function.

Methods in org.h2.expression.analysis that return Expression

Modifier and Type	Method	Description
Expression	WindowFrameBound.getValue()	Returns the value.
Expression	DataAnalysisOperation.optimize(SessionLocal session)
Expression	WindowFunction.optimize(SessionLocal session)

Constructors in org.h2.expression.analysis with parameters of type Expression

Modifier	Constructor	Description
	WindowFrameBound(WindowFrameBoundType type, Expression value)	Creates new instance of window frame bound.
	WindowFunction(WindowFunctionType type, Select select, Expression[] args)	Creates new instance of a window function.

Constructor parameters in org.h2.expression.analysis with type arguments of type Expression

Modifier	Constructor	Description
	Window(String parent, ArrayList<Expression> partitionBy, ArrayList<QueryOrderBy> orderBy, WindowFrame frame)	Creates a new instance of window clause.

Uses of Expression in org.h2.expression.condition

Subclasses of Expression in org.h2.expression.condition

Modifier and Type	Class	Description
final class	BetweenPredicate	BETWEEN predicate.
final class	BooleanTest	Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
final class	CompareLike	Pattern matching comparison expression: WHERE NAME LIKE ?
final class	Comparison	Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
class	ConditionAndOr	An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
class	ConditionAndOrN	An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
final class	ConditionIn	An 'in' condition with a list of values, as in WHERE NAME IN(...)
final class	ConditionInConstantSet	Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.
final class	ConditionInParameter	A condition with parameter as = ANY(?).
final class	ConditionInQuery	An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)
class	ConditionLocalAndGlobal	A global condition or combination of local and global conditions.
class	ConditionNot	A NOT condition.
class	ExistsPredicate	Exists predicate as in EXISTS(SELECT ...)
final class	IsJsonPredicate	IS JSON predicate.
final class	NullPredicate	Null predicate (IS [NOT] NULL).
class	SimplePredicate	Base class for simple predicates.
final class	TypePredicate	Type predicate (IS [NOT] OF).
class	UniquePredicate	Unique predicate as in UNIQUE(SELECT ...)

Methods in org.h2.expression.condition that return Expression

Modifier and Type	Method	Description
Expression	BetweenPredicate.getNotIfPossible(SessionLocal session)
Expression	BooleanTest.getNotIfPossible(SessionLocal session)
Expression	CompareLike.getNotIfPossible(SessionLocal session)
Expression	Comparison.getNotIfPossible(SessionLocal session)
Expression	ConditionAndOr.getNotIfPossible(SessionLocal session)
Expression	ConditionAndOrN.getNotIfPossible(SessionLocal session)
Expression	ConditionIn.getNotIfPossible(SessionLocal session)
Expression	ConditionInConstantSet.getNotIfPossible(SessionLocal session)
Expression	ConditionInParameter.getNotIfPossible(SessionLocal session)
Expression	ConditionInQuery.getNotIfPossible(SessionLocal session)
Expression	ConditionNot.getNotIfPossible(SessionLocal session)
Expression	IsJsonPredicate.getNotIfPossible(SessionLocal session)
Expression	NullPredicate.getNotIfPossible(SessionLocal session)
Expression	TypePredicate.getNotIfPossible(SessionLocal session)
Expression	BetweenPredicate.getSubexpression(int index)
Expression	CompareLike.getSubexpression(int index)
Expression	Comparison.getSubexpression(int index)
Expression	ConditionAndOr.getSubexpression(int index)
Expression	ConditionAndOrN.getSubexpression(int index)
Expression	ConditionIn.getSubexpression(int index)
Expression	ConditionInConstantSet.getSubexpression(int index)
Expression	ConditionLocalAndGlobal.getSubexpression(int index)
Expression	ConditionNot.getSubexpression(int index)
Expression	IsJsonPredicate.getSubexpression(int index)
Expression	SimplePredicate.getSubexpression(int index)
Expression	BetweenPredicate.optimize(SessionLocal session)
Expression	CompareLike.optimize(SessionLocal session)
Expression	Comparison.optimize(SessionLocal session)
Expression	ConditionAndOr.optimize(SessionLocal session)
Expression	ConditionAndOrN.optimize(SessionLocal session)
Expression	ConditionIn.optimize(SessionLocal session)
Expression	ConditionInConstantSet.optimize(SessionLocal session)
Expression	ConditionInParameter.optimize(SessionLocal session)
Expression	ConditionInQuery.optimize(SessionLocal session)
Expression	ConditionLocalAndGlobal.optimize(SessionLocal session)
Expression	ConditionNot.optimize(SessionLocal session)
Expression	IsJsonPredicate.optimize(SessionLocal session)
Expression	NullPredicate.optimize(SessionLocal session)
Expression	SimplePredicate.optimize(SessionLocal session)
Expression	TypePredicate.optimize(SessionLocal session)
Expression	UniquePredicate.optimize(SessionLocal session)

Constructors in org.h2.expression.condition with parameters of type Expression

Modifier	Constructor	Description
	BetweenPredicate(Expression left, boolean not, boolean whenOperand, boolean symmetric, Expression a, Expression b)
	BooleanTest(Expression left, boolean not, boolean whenOperand, Boolean right)
	CompareLike(Database db, Expression left, boolean not, boolean whenOperand, Expression right, Expression escape, CompareLike.LikeType likeType)
	CompareLike(CompareMode compareMode, String defaultEscape, Expression left, boolean not, boolean whenOperand, Expression right, Expression escape, CompareLike.LikeType likeType)
	Comparison(int compareType, Expression left, Expression right, boolean whenOperand)
	ConditionAndOr(int andOrType, Expression left, Expression right)
	ConditionAndOrN(int andOrType, Expression expr1, Expression expr2, Expression expr3)
	ConditionIn(Expression left, boolean not, boolean whenOperand, ArrayList<Expression> values)	Create a new IN(..) condition.
	ConditionInParameter(Expression left, boolean not, boolean whenOperand, Parameter parameter)	Create a new = ANY(?) condition.
	ConditionInQuery(Expression left, boolean not, boolean whenOperand, Query query, boolean all, int compareType)
	ConditionLocalAndGlobal(Expression local, Expression global)
	ConditionNot(Expression condition)
	IsJsonPredicate(Expression left, boolean not, boolean whenOperand, boolean withUniqueKeys, JSONItemType itemType)
	NullPredicate(Expression left, boolean not, boolean whenOperand)
	TypePredicate(Expression left, boolean not, boolean whenOperand, TypeInfo[] typeList)

Constructor parameters in org.h2.expression.condition with type arguments of type Expression

Modifier	Constructor	Description
	ConditionAndOrN(int andOrType, List<Expression> expressions)
	ConditionIn(Expression left, boolean not, boolean whenOperand, ArrayList<Expression> values)	Create a new IN(..) condition.

Uses of Expression in org.h2.expression.function

Subclasses of Expression in org.h2.expression.function

Modifier and Type	Class	Description
final class	ArrayFunction	An array function.
final class	BitFunction	A bitwise function.
final class	CardinalityExpression	Cardinality expression.
final class	CastSpecification	A cast specification.
final class	CoalesceFunction	A COALESCE, GREATEST, or LEAST function.
final class	CompatibilitySequenceValueFunction	NEXTVAL() and CURRVAL() compatibility functions.
final class	CompressFunction	A COMPRESS or EXPAND function.
final class	ConcatFunction	A CONCAT or CONCAT_WS function.
final class	CryptFunction	An ENCRYPT or DECRYPT function.
final class	CSVWriteFunction	A CSVWRITE function.
final class	CurrentDateTimeValueFunction	Current datetime value function.
final class	CurrentGeneralValueSpecification	Simple general value specifications.
final class	DataTypeSQLFunction	DATA_TYPE_SQL() function.
final class	DateTimeFormatFunction	A date-time format function.
final class	DateTimeFunction	A date-time function.
final class	DayMonthNameFunction	A DAYNAME() or MONTHNAME() function.
final class	DBObjectFunction	DB_OBJECT_ID() and DB_OBJECT_SQL() functions.
final class	FileFunction	A FILE_READ or FILE_WRITE function.
class	Function0_1	Function with one optional argument.
class	Function1	Function with one argument.
class	Function1_2	Function with two arguments.
class	Function2	Function with two arguments.
class	FunctionN	Function with many arguments.
final class	HashFunction	A HASH or ORA_HASH function.
final class	JavaFunction	This class wraps a user-defined function.
final class	JsonConstructorFunction	JSON constructor function.
final class	LengthFunction	CHAR_LENGTH(), or OCTET_LENGTH() function.
final class	MathFunction	A math function.
final class	MathFunction1	A math function with one argument and DOUBLE PRECISION result.
final class	MathFunction2	A math function with two arguments and DOUBLE PRECISION result.
final class	NullIfFunction	A NULLIF function.
final class	RandFunction	A RAND, SECURE_RAND, or RANDOM_UUID function.
final class	RegexpFunction	A regular expression function.
final class	SessionControlFunction	An ABORT_SESSION() or CANCEL_SESSION() function.
final class	SetFunction	A SET function.
final class	SignalFunction	A SIGNAL function.
final class	SoundexFunction	A SOUNDEX or DIFFERENCE function.
final class	StringFunction	An string function with multiple arguments.
final class	StringFunction1	A string function with one argument.
final class	StringFunction2	A string function with two arguments.
final class	SubstringFunction	A SUBSTRING function.
final class	SysInfoFunction	Database or session information function.
final class	TableInfoFunction	A table information function.
final class	ToCharFunction	Emulates Oracle's TO_CHAR function.
final class	TrimFunction	A TRIM function.
final class	TruncateValueFunction	A TRUNCATE_VALUE function.
final class	XMLFunction	An XML function.

Fields in org.h2.expression.function declared as Expression

Modifier and Type	Field	Description
protected Expression	Function0_1.arg	The argument of the operation.

Methods in org.h2.expression.function that return Expression

Modifier and Type	Method	Description
Expression	Function0_1.getSubexpression(int index)
Expression	JavaFunction.getSubexpression(int index)
Expression	ArrayFunction.optimize(SessionLocal session)
Expression	BitFunction.optimize(SessionLocal session)
Expression	CardinalityExpression.optimize(SessionLocal session)
Expression	CastSpecification.optimize(SessionLocal session)
Expression	CoalesceFunction.optimize(SessionLocal session)
Expression	CompatibilitySequenceValueFunction.optimize(SessionLocal session)
Expression	CompressFunction.optimize(SessionLocal session)
Expression	ConcatFunction.optimize(SessionLocal session)
Expression	CryptFunction.optimize(SessionLocal session)
Expression	CSVWriteFunction.optimize(SessionLocal session)
Expression	DataTypeSQLFunction.optimize(SessionLocal session)
Expression	DateTimeFormatFunction.optimize(SessionLocal session)
Expression	DateTimeFunction.optimize(SessionLocal session)
Expression	DayMonthNameFunction.optimize(SessionLocal session)
Expression	DBObjectFunction.optimize(SessionLocal session)
Expression	FileFunction.optimize(SessionLocal session)
Expression	HashFunction.optimize(SessionLocal session)
Expression	JavaFunction.optimize(SessionLocal session)
Expression	JsonConstructorFunction.optimize(SessionLocal session)
Expression	LengthFunction.optimize(SessionLocal session)
Expression	MathFunction.optimize(SessionLocal session)
Expression	MathFunction1.optimize(SessionLocal session)
Expression	MathFunction2.optimize(SessionLocal session)
Expression	NullIfFunction.optimize(SessionLocal session)
Expression	RandFunction.optimize(SessionLocal session)
Expression	RegexpFunction.optimize(SessionLocal session)
Expression	SessionControlFunction.optimize(SessionLocal session)
Expression	SetFunction.optimize(SessionLocal session)
Expression	SignalFunction.optimize(SessionLocal session)
Expression	SoundexFunction.optimize(SessionLocal session)
Expression	StringFunction.optimize(SessionLocal session)
Expression	StringFunction1.optimize(SessionLocal session)
Expression	StringFunction2.optimize(SessionLocal session)
Expression	SubstringFunction.optimize(SessionLocal session)
Expression	TableInfoFunction.optimize(SessionLocal session)
Expression	ToCharFunction.optimize(SessionLocal session)
Expression	TrimFunction.optimize(SessionLocal session)
Expression	TruncateValueFunction.optimize(SessionLocal session)
Expression	XMLFunction.optimize(SessionLocal session)

Methods in org.h2.expression.function with parameters of type Expression

Modifier and Type	Method	Description
static TypeInfo	BitFunction.checkArgType(Expression arg)	Checks the type of an argument of bitwise function (one of BitFunction.BITAND, BitFunction.BITOR, BitFunction.BITXOR, BitFunction.BITNOT, BitFunction.BITNAND, BitFunction.BITNOR, BitFunction.BITXNOR).

Constructors in org.h2.expression.function with parameters of type Expression

Modifier	Constructor	Description
	ArrayFunction(Expression arg1, Expression arg2, Expression arg3, int function)
	BitFunction(Expression arg1, Expression arg2, int function)
	CardinalityExpression(Expression arg, boolean max)	Creates new instance of cardinality expression.
	CastSpecification(Expression arg, Column column)
	CastSpecification(Expression arg, TypeInfo type)
	CoalesceFunction(int function, Expression... args)
	CompatibilitySequenceValueFunction(Expression left, Expression right, boolean current)
	CompressFunction(Expression arg1, Expression arg2, int function)
	ConcatFunction(int function, Expression... args)
	CryptFunction(Expression arg1, Expression arg2, Expression arg3, int function)
	DataTypeSQLFunction(Expression objectSchema, Expression objectName, Expression objectType, Expression typeIdentifier)
	DateTimeFunction(int function, int field, Expression arg1, Expression arg2)
	DayMonthNameFunction(Expression arg, int function)
	DBObjectFunction(Expression objectType, Expression arg1, Expression arg2, int function)
	FileFunction(Expression arg1, Expression arg2, int function)
protected	Function0_1(Expression arg)
protected	Function1(Expression arg)
protected	Function1_2(Expression left, Expression right)
protected	Function2(Expression left, Expression right)
protected	FunctionN(Expression[] args)
	HashFunction(Expression arg, int function)
	HashFunction(Expression arg1, Expression arg2, Expression arg3, int function)
	JavaFunction(FunctionAlias functionAlias, Expression[] args)
	LengthFunction(Expression arg, int function)
	MathFunction(Expression arg1, Expression arg2, int function)
	MathFunction1(Expression arg, int function)
	MathFunction2(Expression arg1, Expression arg2, int function)
	NullIfFunction(Expression arg1, Expression arg2)
	RandFunction(Expression arg, int function)
	SessionControlFunction(Expression arg, int function)
	SetFunction(Expression arg1, Expression arg2)
	SignalFunction(Expression arg1, Expression arg2)
	SoundexFunction(Expression arg1, Expression arg2, int function)
	StringFunction(Expression[] args, int function)
	StringFunction(Expression arg1, Expression arg2, Expression arg3, int function)
	StringFunction(Expression arg1, Expression arg2, Expression arg3, Expression arg4, int function)
	StringFunction1(Expression arg, int function)
	StringFunction2(Expression arg1, Expression arg2, int function)
	TableInfoFunction(Expression arg1, Expression arg2, int function)
	ToCharFunction(Expression arg1, Expression arg2, Expression arg3)
	TrimFunction(Expression from, Expression space, int flags)
	TruncateValueFunction(Expression arg1, Expression arg2, Expression arg3)

Uses of Expression in org.h2.expression.function.table

Fields in org.h2.expression.function.table declared as Expression

Modifier and Type	Field	Description
protected Expression[]	TableFunction.args

Methods in org.h2.expression.function.table with parameters of type Expression

Modifier and Type	Method	Description
void	TableFunction.addParameter(Expression param)

Constructors in org.h2.expression.function.table with parameters of type Expression

Modifier	Constructor	Description
	JavaTableFunction(FunctionAlias functionAlias, Expression[] args)
protected	TableFunction(Expression[] args)

Uses of Expression in org.h2.index

Methods in org.h2.index that return Expression

Modifier and Type	Method	Description
Expression	IndexCondition.getExpression()	Get expression.

Methods in org.h2.index that return types with arguments of type Expression

Modifier and Type	Method	Description
List<Expression>	IndexCondition.getExpressionList()	Get expression list.

Methods in org.h2.index with parameters of type Expression

Modifier and Type	Method	Description
static IndexCondition	IndexCondition.get(int compareType, ExpressionColumn column, Expression expression)	Create an index condition with the given parameters.

Method parameters in org.h2.index with type arguments of type Expression

Modifier and Type	Method	Description
static IndexCondition	IndexCondition.getInList(ExpressionColumn column, List<Expression> list)	Create an index condition with the compare type IN_LIST and with the given parameters.

Uses of Expression in org.h2.mode

Subclasses of Expression in org.h2.mode

Modifier and Type	Class	Description
final class	FunctionsDB2Derby	Functions for Mode.ModeEnum.DB2 and Mode.ModeEnum.Derby compatibility modes.
class	FunctionsLegacy	This class implements some legacy functions not available in Regular mode.
final class	FunctionsMSSQLServer	Functions for Mode.ModeEnum.MSSQLServer compatibility mode.
final class	FunctionsMySQL	This class implements some MySQL-specific functions.
final class	FunctionsOracle	Functions for Mode.ModeEnum.Oracle compatibility mode.
final class	FunctionsPostgreSQL	Functions for Mode.ModeEnum.PostgreSQL compatibility mode.
class	ModeFunction	Base class for mode-specific functions.
final class	OnDuplicateKeyValues	VALUES(column) function for ON DUPLICATE KEY UPDATE clause.
final class	Regclass	A ::regclass expression.

Methods in org.h2.mode that return Expression

Modifier and Type	Method	Description
Expression	FunctionsDB2Derby.optimize(SessionLocal session)
Expression	FunctionsLegacy.optimize(SessionLocal session)
Expression	FunctionsMSSQLServer.optimize(SessionLocal session)
Expression	FunctionsMySQL.optimize(SessionLocal session)
Expression	FunctionsOracle.optimize(SessionLocal session)
Expression	FunctionsPostgreSQL.optimize(SessionLocal session)
Expression	Regclass.optimize(SessionLocal session)

Constructors in org.h2.mode with parameters of type Expression

Modifier	Constructor	Description
	Regclass(Expression arg)

Uses of Expression in org.h2.mvstore.db

Methods in org.h2.mvstore.db with parameters of type Expression

Modifier and Type	Method	Description
static ResultExternal	MVTempResult.of(Database database, Expression[] expressions, boolean distinct, int[] distinctIndexes, int visibleColumnCount, int resultColumnCount, SortOrder sort)	Creates MVStore-based temporary result.

Uses of Expression in org.h2.result

Methods in org.h2.result with parameters of type Expression

Modifier and Type	Method	Description
StringBuilder	SortOrder.getSQL(StringBuilder builder, Expression[] list, int visible, int sqlFlags)	Create the SQL snippet that describes this sort order.

Constructors in org.h2.result with parameters of type Expression

Modifier	Constructor	Description
	LazyResult(SessionLocal session, Expression[] expressions)
	LocalResult(SessionLocal session, Expression[] expressions, int visibleColumnCount, int resultColumnCount)	Construct a local result object.

Uses of Expression in org.h2.schema

Methods in org.h2.schema that return Expression

Modifier and Type	Method	Description
Expression	Domain.getDefaultExpression()
Expression	Domain.getEffectiveDefaultExpression()
Expression	Domain.getEffectiveOnUpdateExpression()
Expression	Domain.getOnUpdateExpression()

Methods in org.h2.schema with parameters of type Expression

Modifier and Type	Method	Description
FunctionAlias.JavaMethod	FunctionAlias.findJavaMethod(Expression[] args)	Find the Java method that matches the arguments.
ResultInterface	FunctionAlias.JavaMethod.getTableValue(SessionLocal session, Expression[] args, boolean columnList)	Call the table user-defined function and return the value.
Value	FunctionAlias.JavaMethod.getValue(SessionLocal session, Expression[] args, boolean columnList)	Call the user-defined function and return the value.
void	Domain.setDefaultExpression(SessionLocal session, Expression defaultExpression)
void	Domain.setOnUpdateExpression(SessionLocal session, Expression onUpdateExpression)

Uses of Expression in org.h2.table

Methods in org.h2.table that return Expression

Modifier and Type	Method	Description
Expression	Column.getDefaultExpression()
Expression	ColumnTemplate.getDefaultExpression()
Expression	Column.getEffectiveDefaultExpression()
Expression	ColumnTemplate.getEffectiveDefaultExpression()
Expression	Column.getEffectiveOnUpdateExpression()
Expression	ColumnTemplate.getEffectiveOnUpdateExpression()
Expression	TableFilter.getFilterCondition()
Expression	TableFilter.getJoinCondition()
Expression	Column.getOnUpdateExpression()
Expression	ColumnTemplate.getOnUpdateExpression()
default Expression	ColumnResolver.optimize(ExpressionColumn expressionColumn, Column column)	Get the expression that represents this column.

Methods in org.h2.table with parameters of type Expression

Modifier and Type	Method	Description
void	TableFilter.addFilterCondition(Expression condition, boolean isJoin)	Add a filter condition.
void	TableFilter.addJoin(TableFilter filter, boolean outer, Expression on)	Add a joined table.
void	TableFilter.mapAndAddFilter(Expression on)	Map the columns and add the join condition.
void	Column.setDefaultExpression(SessionLocal session, Expression defaultExpression)
void	ColumnTemplate.setDefaultExpression(SessionLocal session, Expression defaultExpression)	Set the default expression.
void	TableFilter.setFullCondition(Expression condition)
void	Column.setGeneratedExpression(Expression expression)	Set the default value in the form of a generated expression of other columns.
void	Column.setOnUpdateExpression(SessionLocal session, Expression onUpdateExpression)
void	ColumnTemplate.setOnUpdateExpression(SessionLocal session, Expression onUpdateExpression)	Set the on update expression.

Constructors in org.h2.table with parameters of type Expression

Modifier	Constructor	Description
	Plan(TableFilter[] filters, int count, Expression condition)	Create a query plan with the given order.
	RangeTable(Schema schema, Expression min, Expression max)	Create a new range with the given start and end expressions.
	RangeTable(Schema schema, Expression min, Expression max, Expression step)

Constructor parameters in org.h2.table with type arguments of type Expression

Modifier	Constructor	Description
	TableValueConstructorTable(Schema schema, SessionLocal session, Column[] columns, ArrayList<ArrayList<Expression>> rows)