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.fulltext	The native full text search implementation, and the wrapper for the Lucene full text search implementation.
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
private Expression	Parser.addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private Expression	Parser.parseDB2SpecialRegisters(java.lang.String name)
Expression	Parser.parseDomainConstraintExpression(java.lang.String sql)	Parse a SQL code snippet that represents an expression for a domain constraint.
Expression	Parser.parseExpression(java.lang.String sql)	Parse a SQL code snippet that represents an expression.
private Expression	Parser.readAggregate(AggregateType aggregateType, java.lang.String aggregateName)
private Expression	Parser.readAnd(Expression r)
private Expression	Parser.readBuiltinFunctionIf(java.lang.String upperName)
private Expression	Parser.readCase()
private Expression	Parser.readCoalesceFunction(int function)
private Expression	Parser.readColumnIfNotFunction()
private Expression	Parser.readComparison(Expression left, int compareType, boolean whenOperand)
private Expression	Parser.readCompatibilityCase(Expression when)
private Expression	Parser.readCompatibilityFunction(java.lang.String name)
private Expression	Parser.readCompatibilitySequenceValueFunction(boolean current)
private Expression	Parser.readConcat()
private Expression	Parser.readConcatFunction(int function)
private Expression	Parser.readCondition()
private Expression	Parser.readConditionIs(Expression left, boolean whenOperand)
private Expression	Parser.readConditionRightHandSide(Expression r, boolean not, boolean whenOperand)
private Expression	Parser.readCurrentDateTimeValueFunction(int function, boolean hasParen, java.lang.String name)
private Expression	Parser.readCurrentGeneralValueSpecification(int specification)
private Expression	Parser.readDateTimeFormatFunction(int function)
private Expression	Parser.readExpression()
private Expression	Parser.readExpressionOrDefault()
private Expression	Parser.readExpressionOrIdentifier()
private Expression	Parser.readExpressionPart2(Expression r1)
private Expression	Parser.readExpressionWithGlobalConditions()
private Expression	Parser.readFactor()
private Expression	Parser.readFetchOrLimit()
private Expression	Parser.readFunction(Schema schema, java.lang.String name)
private Expression	Parser.readFunctionWithSchema(Schema schema, java.lang.String name, java.lang.String upperName)
private Expression	Parser.readIfArgument()
private Expression	Parser.readIfSingleArgument()
private Expression	Parser.readIfWildcardRowidOrSequencePseudoColumn(java.lang.String schema, java.lang.String objectName)
private Expression	Parser.readInPredicate(Expression left, boolean not, boolean whenOperand)
private Expression	Parser.readInterval()
private Expression	Parser.readJoinSpecification(TableFilter filter1, TableFilter filter2, boolean rightJoin)
private Expression	Parser.readKeywordCompatibilityFunctionOrColumn()
private Expression	Parser.readLastArgument()
private Expression	Parser.readLikePredicate(Expression left, CompareLike.LikeType likeType, boolean not, boolean whenOperand)
private Expression	Parser.readNextArgument()
private Expression	Parser.readOnDuplicateKeyValues(Table table, Update update)
private Expression	Parser.readSetFunction()
private Expression	Parser.readSingleArgument()
private Expression	Parser.readSubstringFunction()
private Expression	Parser.readSum()
private Expression	Parser.readTerm()
private Expression	Parser.readTermObjectDot(java.lang.String objectName)
private Expression	Parser.readTermWithIdentifier(java.lang.String name, boolean quoted)
private Expression	Parser.readTildeCondition(Expression r, boolean not)
private Expression	Parser.readTrimFunction()
private Expression	Parser.readUserDefinedFunctionIf(Schema schema, java.lang.String functionName)
private Expression	Parser.readWhenOperand(Expression caseOperand)

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

Modifier and Type	Method	Description
private java.util.ArrayList<Expression>	Parser.parseValuesRow(java.util.ArrayList<Expression> row)

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

Modifier and Type	Method	Description
private void	Parser.addJoin(TableFilter top, TableFilter join, boolean outer, Expression on)	Add one join to another.
private Expression	Parser.addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private SimpleCase.SimpleWhen	Parser.decodeToWhen(Expression caseOperand, boolean canOptimize, Expression whenOperand, Expression result)
static java.lang.String	Prepared.getSimpleSQL(Expression[] list)	Get the SQL snippet of the expression list.
private void	Parser.readAggregateOrder(Aggregate r, Expression expr, boolean parseSortType)
private Expression	Parser.readAnd(Expression r)
private Expression	Parser.readComparison(Expression left, int compareType, boolean whenOperand)
private Expression	Parser.readCompatibilityCase(Expression when)
private Expression	Parser.readConditionIs(Expression left, boolean whenOperand)
private Expression	Parser.readConditionRightHandSide(Expression r, boolean not, boolean whenOperand)
private Expression	Parser.readExpressionPart2(Expression r1)
private Expression	Parser.readInPredicate(Expression left, boolean not, boolean whenOperand)
private IsJsonPredicate	Parser.readJsonPredicate(Expression left, boolean not, boolean whenOperand)
private Expression	Parser.readLikePredicate(Expression left, CompareLike.LikeType likeType, boolean not, boolean whenOperand)
private SimpleCase.SimpleWhen	Parser.readSimpleWhenClause(Expression caseOperand)
private Expression	Parser.readTildeCondition(Expression r, boolean not)
private TypePredicate	Parser.readTypePredicate(Expression left, boolean not, boolean whenOperand)
private Expression	Parser.readWhenOperand(Expression caseOperand)
private Aggregate	Parser.readWithinGroup(AggregateType aggregateType, Expression[] args, boolean distinct, java.lang.Object extraArguments, boolean forHypotheticalSet, boolean simple)

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

Modifier and Type	Method	Description
private java.util.ArrayList<Expression>	Parser.parseValuesRow(java.util.ArrayList<Expression> row)

Uses of Expression in org.h2.command.ddl

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

Modifier and Type	Field	Description
private Expression	SequenceOptions.cacheSize
private Expression	AlterDomainAddConstraint.checkExpression
private Expression	AlterTableAddConstraint.checkExpression
private Expression	AlterTableAlterColumn.defaultExpression	Default or on update expression.
private Expression	CreateDomain.defaultExpression
private Expression	SetComment.expr
private Expression	AlterDomainExpressions.expression
private Expression	CreateConstant.expression
private Expression	AlterUser.hash
private Expression	CreateUser.hash
private Expression	SequenceOptions.increment
private Expression	SequenceOptions.maxValue
private Expression	SequenceOptions.minValue
private Expression	AlterTableAlterColumn.newSelectivity
private Expression	CreateDomain.onUpdateExpression
private Expression	AlterUser.password
private Expression	CreateUser.password
private Expression	SequenceOptions.restart
private Expression	AlterUser.salt
private Expression	CreateUser.salt
private Expression	SequenceOptions.start
private Expression	AlterTableAlterColumn.usingExpression

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

Modifier and Type	Method	Description
private static void	AlterTableAlterColumn.checkDefaultReferencesTable(Table table, Expression defaultExpression)
private static byte[]	CreateUser.getByteArray(SessionLocal session, Expression e)
private static java.lang.Long	SequenceOptions.getLong(SessionLocal session, Expression expr)
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)
(package private) static void	CreateUser.setPassword(User user, SessionLocal session, Expression password)	Set the password for the given user.
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)
(package private) static void	CreateUser.setSaltAndHash(User user, SessionLocal session, Expression salt, Expression hash)	Set the salt and hash for the given user.
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

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

Modifier and Type	Field	Description
(package private) Expression	MergeUsing.When.andCondition	AND condition of the command.
(package private) Expression	FilteredDataChangeStatement.condition	The WHERE criteria.
private Expression	Call.expression
private Expression	Set.expression
(package private) Expression	SetClauseList.RowExpression.expression
private Expression	SetClauseList.SetSimple.expression
private Expression[]	Call.expressions
private Expression[]	Help.expressions
(package private) Expression	FilteredDataChangeStatement.fetchExpr	The expression with optional maximum number of rows.
private Expression	BackupCommand.fileNameExpr
private Expression	ScriptBase.fileNameExpr	The file name (if set).
(package private) Expression	MergeUsing.onCondition	ON condition expression.
private Expression	ScriptBase.password
private Expression	ExecuteImmediate.statement
private Expression[]	MergeUsing.WhenNotMatched.values

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

Modifier and Type	Field	Description
private java.util.HashMap<Column,Expression>	Insert.duplicateKeyAssignmentMap	For MySQL-style INSERT ...
private java.util.ArrayList<Expression>	ExecuteProcedure.expressions

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

Modifier and Type	Method	Description
Expression	FilteredDataChangeStatement.getCondition()
Expression	MergeUsing.getOnCondition()
private Expression	Insert.prepareUpdateCondition(Index foundIndex, Expression[] row)

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(java.util.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.
private int	Merge.merge(Row row, Expression[] expressions, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)	Updates an existing row or inserts a new one.
private Expression	Insert.prepareUpdateCondition(Index foundIndex, Expression[] row)
void	MergeUsing.When.setAndCondition(Expression andCondition)	Sets the specified AND condition.
void	FilteredDataChangeStatement.setCondition(Expression 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	FilteredDataChangeStatement.setFetch(Expression fetch)
void	BackupCommand.setFileName(Expression fileName)
void	ScriptBase.setFileNameExpr(Expression file)
void	MergeUsing.setOnCondition(Expression condition)
void	ScriptBase.setPassword(Expression password)

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

Constructor	Description
ExecuteImmediate(SessionLocal session, Expression statement)
RowExpression(Expression expression, int[] columns)
SetSimple(Expression expression)
WhenNotMatched(Column[] columns, java.lang.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.
private Expression	Optimizer.condition
private Expression	Select.condition	WHERE condition.
private Expression[]	Select.distinctExpressions	DISTINCT ON(...) expressions.
Expression	QueryOrderBy.expression	The order by expression.
(package private) Expression[]	Query.expressionArray	Array of expressions.
private Expression[]	SelectListColumnResolver.expressions
(package private) Expression	Query.fetchExpr	The fetch expression as specified in the FETCH, LIMIT, or TOP clause.
private Expression	Select.having	HAVING condition.
(package private) Expression	Query.offsetExpr	The offset expression as specified in the OFFSET clause.
private Expression	Select.qualify	QUALIFY condition.

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

Modifier and Type	Field	Description
(package private) java.util.ArrayList<Expression>	Query.expressions	The column list, including invisible expressions such as order by expressions.
(package private) java.util.ArrayList<Expression>	SelectGroups.expressions	The query's column list, including invisible expressions such as order by expressions.
private java.util.HashMap<Expression,java.lang.Integer>	SelectGroups.exprToIndexInGroupByData	Maps an expression object to an index, to use in accessing the Object[] pointed to by groupByData.
private java.util.ArrayList<Expression>	Select.group
private java.util.ArrayList<java.util.ArrayList<Expression>>	TableValueConstructor.rows

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

Modifier and Type	Method	Description
private static Expression	Select.addGlobalCondition(Expression condition, Expression additional)
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)
Expression	TableValueConstructor.TableValueColumnResolver.optimize(ExpressionColumn expressionColumn, Column column)

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

Modifier and Type	Method	Description
java.util.ArrayList<Expression>	Query.getExpressions()	The the list of select expressions.
java.util.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.
private static Expression	Select.addGlobalCondition(Expression condition, Expression additional)
(package private) void	Query.appendEndOfQueryToSQL(java.lang.StringBuilder builder, int sqlFlags, Expression[] expressions)	Appends ORDER BY, OFFSET, and FETCH clauses to the plan.
private static boolean	Query.checkOrderOther(SessionLocal session, Expression expr, java.util.ArrayList<java.lang.String> expressionSQL)	An additional check for expression in ORDER BY list for DISTINCT selects that was not matched with selected expressions in regular way.
private static boolean	Select.containsAggregate(Expression expression)
java.lang.Object	SelectGroups.getCurrentGroupExprData(Expression expr)	Get the group-by data for the current group and the passed in expression.
private static void	Select.getFilterSQL(java.lang.StringBuilder builder, java.lang.String sql, Expression[] exprList, Expression condition, int conditionIndex, int sqlFlags)
private static void	Select.getFilterSQL(java.lang.StringBuilder builder, java.lang.String sql, Expression condition, int sqlFlags)
(package private) int	Query.initExpression(java.util.ArrayList<java.lang.String> expressionSQL, Expression e, boolean mustBeInResult, java.util.ArrayList<TableFilter> filters)	Initialize the 'ORDER BY' or 'DISTINCT' expressions.
void	SelectGroups.setCurrentGroupExprData(Expression expr, java.lang.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, java.util.ArrayList<Expression> expressions, boolean isGroupQuery, int[] groupIndex)	Creates new instance of grouped data.
static void	TableValueConstructor.getValuesSQL(java.lang.StringBuilder builder, int sqlFlags, java.util.ArrayList<java.util.ArrayList<Expression>> rows)	Appends the SQL of the values to the specified string builder..
static void	TableValueConstructor.getVisibleResult(SessionLocal session, ResultTarget result, Column[] columns, java.util.ArrayList<java.util.ArrayList<Expression>> rows)	Appends visible columns of all rows to the specified result.
void	Select.setExpressions(java.util.ArrayList<Expression> expressions)
void	Select.setGroupBy(java.util.ArrayList<Expression> group)

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

Constructor	Description
LazyResultGroupSorted(Expression[] expressions, int columnCount)
LazyResultQueryFlat(Expression[] expressions, int columnCount, boolean forUpdate)
LazyResultSelect(Expression[] expressions, int columnCount)
LazyResultUnion(Expression[] expressions, int columnCount)
Optimizer(TableFilter[] filters, Expression condition, SessionLocal session)

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

Constructor	Description
Grouped(SessionLocal session, java.util.ArrayList<Expression> expressions, int[] groupIndex)
Plain(SessionLocal session, java.util.ArrayList<Expression> expressions)
SelectGroups(SessionLocal session, java.util.ArrayList<Expression> expressions)
TableValueConstructor(SessionLocal session, java.util.ArrayList<java.util.ArrayList<Expression>> rows)	Creates new instance of table value constructor.

Uses of Expression in org.h2.constraint

Fields in org.h2.constraint declared as Expression

Modifier and Type	Field	Description
private Expression	ConstraintCheck.expr
private Expression	ConstraintDomain.expr

Methods in org.h2.constraint that return Expression

Modifier and Type	Method	Description
Expression	ConstraintDomain.getCheckConstraint(SessionLocal session, java.lang.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
class	Alias	A column alias as in SELECT 'Hello' AS NAME ...
class	ArrayConstructorByQuery	Array value constructor by query.
class	ArrayElementReference	Array element reference.
class	BinaryOperation	A mathematical expression, or string concatenation.
class	CompatibilityDatePlusTimeOperation	A compatibility mathematical operation with datetime values.
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.
class	DomainValueExpression	An expression representing a value for domain constraint.
class	ExpressionColumn	A column reference expression that represents a column of a table or view.
class	ExpressionList	A list of expressions, as in (ID, NAME).
class	FieldReference	Field reference.
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.
class	Parameter	A parameter of a prepared statement.
class	Rownum	Represents the ROWNUM function.
class	SearchedCase	A searched case.
class	SequenceValue	Wraps a sequence when used in a statement.
class	SimpleCase	A simple case.
class	Subquery	A query returning a single value.
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.
class	Variable	A user-defined variable, for example: @ID.
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.
private Expression	SimpleCase.elseResult
private Expression	Alias.expr
private Expression	Subquery.expression
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).
private Expression[]	ExpressionList.list
private Expression	SimpleCase.operand
(package private) Expression[]	SimpleCase.SimpleWhen.operands
(package private) Expression	SimpleCase.SimpleWhen.result
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)
Expression	Expression.optimizeCondition(SessionLocal session)	Try to optimize or remove the condition.
private Expression	BinaryOperation.optimizeDateTime(SessionLocal session, int l, int r)
private Expression	BinaryOperation.optimizeInterval(int l, int r)
private Expression	ExpressionColumn.optimizeOther()

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)
(package private) static TypeInfo	SimpleCase.combineTypes(TypeInfo typeInfo, Expression e)
static java.lang.StringBuilder	Expression.writeExpressions(java.lang.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 java.lang.StringBuilder	Expression.writeExpressions(java.lang.StringBuilder builder, java.util.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

Constructor	Description
Alias(Expression expression, java.lang.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, java.lang.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)
Operation1(Expression arg)
Operation1_2(Expression left, Expression right)
Operation2(Expression left, Expression right)
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 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
(package private) static Index	Percentile.getColumnIndex(Database database, Expression on)	Get the index (if any) for the column specified in the inverse distribution function.
(package private) static Value	Percentile.getFromIndex(SessionLocal session, Expression expression, int dataType, java.util.ArrayList<QueryOrderBy> orderByList, java.math.BigDecimal percentile, boolean interpolate)	Get the result from the index.
(package private) static Index	AggregateDataEnvelope.getGeometryColumnIndex(Expression on)	Get the index (if any) for the column specified in the geometry aggregate.
void	AbstractAggregate.setFilterCondition(Expression filterCondition)	Sets the FILTER condition.

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

Constructor	Description
AbstractAggregate(Select select, Expression[] args, boolean distinct)
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.

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

Modifier and Type	Field	Description
private Expression[]	WindowFunction.args
private Expression	WindowFrameBound.value

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

Modifier and Type	Field	Description
private java.util.ArrayList<Expression>	Window.partitionBy

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

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

Constructor	Description
Window(java.lang.String parent, java.util.ArrayList<Expression> partitionBy, java.util.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
class	BetweenPredicate	BETWEEN predicate.
class	BooleanTest	Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
class	CompareLike	Pattern matching comparison expression: WHERE NAME LIKE ?
class	Comparison	Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
(package private) class	Condition	Represents a condition returning a boolean value, or 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=? with N operands.
class	ConditionIn	An 'in' condition with a list of values, as in WHERE NAME IN(...)
class	ConditionInConstantSet	Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.
class	ConditionInParameter	A condition with parameter as = ANY(?).
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 ...)
class	IsJsonPredicate	IS JSON predicate.
class	NullPredicate	Null predicate (IS [NOT] NULL).
(package private) class	PredicateWithSubquery	Base class for predicates with a subquery.
class	SimplePredicate	Base class for simple predicates.
class	TypePredicate	Type predicate (IS [NOT] OF).
class	UniquePredicate	Unique predicate as in UNIQUE(SELECT ...)

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

Modifier and Type	Field	Description
private Expression	BetweenPredicate.a
private Expression	ConditionAndOr.added	Additional condition for index only.
private Expression	BetweenPredicate.b
private Expression	ConditionNot.condition
private Expression	CompareLike.escape
private Expression	ConditionLocalAndGlobal.global
private Expression	BetweenPredicate.left
private Expression	CompareLike.left
private Expression	Comparison.left
private Expression	ConditionAndOr.left
private Expression	ConditionIn.left
private Expression	ConditionInConstantSet.left
private Expression	ConditionInParameter.left
private Expression	ConditionInQuery.left
private Expression	IsJsonPredicate.left
(package private) Expression	SimplePredicate.left	The left hand side of the expression.
private Expression	ConditionLocalAndGlobal.local
private Expression	CompareLike.right
private Expression	Comparison.right
private Expression	ConditionAndOr.right

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

Modifier and Type	Field	Description
private java.util.List<Expression>	ConditionAndOrN.added	Additional conditions for index only.
private static java.util.Comparator<Expression>	ConditionAndOrN.COMPARE_BY_COST
private java.util.List<Expression>	ConditionAndOrN.expressions	Use an ArrayDeque because we primarily insert at the front.
private java.util.ArrayList<Expression>	ConditionIn.valueList
private java.util.ArrayList<Expression>	ConditionInConstantSet.valueList

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

Modifier and Type	Method	Description
(package private) static Expression	Condition.castToBoolean(SessionLocal session, Expression expression)	Add a cast around the expression (if necessary) so that the type is boolean.
Expression	ConditionInParameter.ParameterList.get(int index)
(package private) Expression	ConditionIn.getAdditional(Comparison other)	Add an additional element if possible.
(package private) Expression	ConditionInConstantSet.getAdditional(SessionLocal session, Comparison other)	Add an additional element if possible.
(package private) Expression	Comparison.getAdditionalAnd(SessionLocal session, Comparison other)	Get an additional condition if possible.
(package private) Expression	Comparison.getIfEquals(Expression match)	Get the other expression if this is an equals comparison and the other expression matches.
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	PredicateWithSubquery.optimize(SessionLocal session)
Expression	SimplePredicate.optimize(SessionLocal session)
Expression	TypePredicate.optimize(SessionLocal session)
Expression	UniquePredicate.optimize(SessionLocal session)
private Expression	ConditionIn.optimize2(SessionLocal session, boolean constant, boolean allValuesConstant, boolean allValuesNull, java.util.ArrayList<Expression> values)
(package private) static Expression	ConditionAndOr.optimizeConditionAndOr(ConditionAndOr left, ConditionAndOr right)	Optimize query according to the given condition.
private static Expression	ConditionAndOr.optimizeConstant(SessionLocal session, int andOrType, Value l, Expression right)
(package private) static Expression	ConditionAndOr.optimizeIfConstant(SessionLocal session, int andOrType, Expression left, Expression right)	Optimize the condition if at least one part is constant.
private static Expression	ConditionAndOr.optimizeN(ConditionAndOr condition)
(package private) Expression	Comparison.optimizeOr(SessionLocal session, Comparison other)	Replace the OR condition with IN condition if possible.

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

Modifier and Type	Method	Description
(package private) void	ConditionAndOrN.addFirst(Expression e)	Add the expression at the beginning of the list.
(package private) static Expression	Condition.castToBoolean(SessionLocal session, Expression expression)	Add a cast around the expression (if necessary) so that the type is boolean.
(package private) static void	Comparison.createIndexConditions(TableFilter filter, Expression left, Expression right, int compareType)
private static ConditionIn	Comparison.getConditionIn(Expression left, Expression value1, Expression value2)
(package private) Expression	Comparison.getIfEquals(Expression match)	Get the other expression if this is an equals comparison and the other expression matches.
private static Expression	ConditionAndOr.optimizeConstant(SessionLocal session, int andOrType, Value l, Expression right)
(package private) static Expression	ConditionAndOr.optimizeIfConstant(SessionLocal session, int andOrType, Expression left, Expression right)	Optimize the condition if at least one part is constant.

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

Modifier and Type	Method	Description
private Expression	ConditionIn.optimize2(SessionLocal session, boolean constant, boolean allValuesConstant, boolean allValuesNull, java.util.ArrayList<Expression> values)

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

Constructor	Description
BetweenPredicate(Expression left, boolean not, boolean whenOperand, boolean symmetric, Expression a, Expression b)
BooleanTest(Expression left, boolean not, boolean whenOperand, java.lang.Boolean right)
CompareLike(Database db, Expression left, boolean not, boolean whenOperand, Expression right, Expression escape, CompareLike.LikeType likeType)
CompareLike(CompareMode compareMode, java.lang.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, java.util.ArrayList<Expression> values)	Create a new IN(..) condition.
ConditionInConstantSet(SessionLocal session, Expression left, boolean not, boolean whenOperand, java.util.ArrayList<Expression> valueList)	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)
SimplePredicate(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

Constructor	Description
ConditionAndOrN(int andOrType, java.util.List<Expression> expressions)
ConditionIn(Expression left, boolean not, boolean whenOperand, java.util.ArrayList<Expression> values)	Create a new IN(..) condition.
ConditionInConstantSet(SessionLocal session, Expression left, boolean not, boolean whenOperand, java.util.ArrayList<Expression> valueList)	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
class	ArrayFunction	An array function.
class	BitFunction	A bitwise function.
class	CardinalityExpression	Cardinality expression.
class	CastSpecification	A cast specification.
class	CoalesceFunction	A COALESCE, GREATEST, or LEAST function.
class	CompatibilitySequenceValueFunction	NEXTVAL() and CURRVAL() compatibility functions.
class	CompressFunction	A COMPRESS or EXPAND function.
class	ConcatFunction	A CONCAT or CONCAT_WS function.
class	CryptFunction	An ENCRYPT or DECRYPT function.
class	CSVWriteFunction	A CSVWRITE function.
class	CurrentDateTimeValueFunction	Current datetime value function.
class	CurrentGeneralValueSpecification	Simple general value specifications.
class	DataTypeSQLFunction	DATA_TYPE_SQL() function.
class	DateTimeFormatFunction	A date-time format function.
class	DateTimeFunction	A date-time function.
class	DayMonthNameFunction	A DAYNAME() or MONTHNAME() function.
class	DBObjectFunction	DB_OBJECT_ID() and DB_OBJECT_SQL() functions.
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.
class	HashFunction	A HASH or ORA_HASH function.
class	JavaFunction	This class wraps a user-defined function.
class	JsonConstructorFunction	JSON constructor function.
class	LengthFunction	CHAR_LENGTH(), or OCTET_LENGTH() function.
class	MathFunction	A math function.
class	MathFunction1	A math function with one argument and DOUBLE PRECISION result.
class	MathFunction2	A math function with two arguments and DOUBLE PRECISION result.
class	NullIfFunction	A NULLIF function.
class	RandFunction	A RAND, SECURE_RAND, or RANDOM_UUID function.
class	RegexpFunction	A regular expression function.
class	SessionControlFunction	An ABORT_SESSION() or CANCEL_SESSION() function.
class	SetFunction	A SET function.
class	SignalFunction	A SIGNAL function.
class	SoundexFunction	A SOUNDEX or DIFFERENCE function.
class	StringFunction	An string function with multiple arguments.
class	StringFunction1	A string function with one argument.
class	StringFunction2	A string function with two arguments.
class	SubstringFunction	A SUBSTRING function.
class	SysInfoFunction	Database or session information function.
class	TableInfoFunction	A table information function.
class	ToCharFunction	Emulates Oracle's TO_CHAR function.
class	TrimFunction	A TRIM function.
class	TruncateValueFunction	A TRUNCATE_VALUE function.
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.
private Expression[]	JavaFunction.args

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)
private Expression	BitFunction.optimizeNot(SessionLocal session)
private Expression	MathFunction.optimizeRound(int scale, boolean scaleIsKnown, boolean scaleIsNull, boolean possibleRoundUp)	Optimizes rounding and truncation functions.
private Expression	MathFunction.optimizeRoundWithScale(SessionLocal session, boolean possibleRoundUp)

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).
private static TypeInfo	BitFunction.getCommonType(Expression arg1, Expression arg2)
private Value	JsonConstructorFunction.jsonArray(SessionLocal session, Expression[] args)
private Value	JsonConstructorFunction.jsonObject(SessionLocal session, Expression[] args)

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

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)
Function0_1(Expression arg)
Function1(Expression arg)
Function1_2(Expression left, Expression right)
Function2(Expression left, Expression right)
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)
private static java.lang.String	CSVReadFunction.getValue(SessionLocal session, Expression[] args, int index)

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

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

Uses of Expression in org.h2.fulltext

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

Modifier and Type	Method	Description
private static void	FullText.addColumnData(SessionLocal session, java.util.ArrayList<java.lang.String> columns, java.util.ArrayList<java.lang.String> data, Expression expr)

Uses of Expression in org.h2.index

Fields in org.h2.index declared as Expression

Modifier and Type	Field	Description
private Expression	IndexCondition.expression

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

Modifier and Type	Field	Description
private java.util.List<Expression>	IndexCondition.expressionList

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
java.util.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, java.util.List<Expression> list)	Create an index condition with the compare type IN_LIST and with the given parameters.

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

Constructor	Description
IndexCondition(int compareType, ExpressionColumn column, Expression expression)

Uses of Expression in org.h2.mode

Subclasses of Expression in org.h2.mode

Modifier and Type	Class	Description
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.
class	FunctionsMSSQLServer	Functions for Mode.ModeEnum.MSSQLServer compatibility mode.
class	FunctionsMySQL	This class implements some MySQL-specific functions.
class	FunctionsOracle	Functions for Mode.ModeEnum.Oracle compatibility mode.
class	FunctionsPostgreSQL	Functions for Mode.ModeEnum.PostgreSQL compatibility mode.
class	ModeFunction	Base class for mode-specific functions.
class	OnDuplicateKeyValues	VALUES(column) function for ON DUPLICATE KEY UPDATE clause.
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)

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

Modifier and Type	Method	Description
(package private) Value[]	ModeFunction.getArgumentsValues(SessionLocal session, Expression[] args)	Gets values of arguments and checks them for NULL values if function returns NULL on NULL argument.
(package private) static Value	ModeFunction.getNullOrValue(SessionLocal session, Expression[] args, Value[] values, int i)	Get value transformed by expression, or null if i is out of range or the input value is null.

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

Constructor	Description
Regclass(Expression arg)

Uses of Expression in org.h2.mvstore.db

Fields in org.h2.mvstore.db declared as Expression

Modifier and Type	Field	Description
(package private) Expression[]	MVTempResult.expressions	Column expressions.

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.

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

Constructor	Description
MVPlainTempResult(Database database, Expression[] expressions, int visibleColumnCount, int resultColumnCount)	Creates a new plain temporary result.
MVSortedTempResult(Database database, Expression[] expressions, boolean distinct, int[] distinctIndexes, int visibleColumnCount, int resultColumnCount, SortOrder sort)	Creates a new sorted temporary result.
MVTempResult(Database database, Expression[] expressions, int visibleColumnCount, int resultColumnCount)	Creates a new temporary result.

Uses of Expression in org.h2.result

Fields in org.h2.result declared as Expression

Modifier and Type	Field	Description
private Expression[]	LazyResult.expressions
private Expression[]	LocalResult.expressions

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

Modifier and Type	Method	Description
java.lang.StringBuilder	SortOrder.getSQL(java.lang.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

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

Fields in org.h2.schema declared as Expression

Modifier and Type	Field	Description
private Expression	Domain.defaultExpression
private Expression	Domain.onUpdateExpression

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
private java.lang.Object	FunctionAlias.JavaMethod.execute(SessionLocal session, Expression[] args, boolean columnList)
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

Fields in org.h2.table declared as Expression

Modifier and Type	Field	Description
private Expression[]	Plan.allConditions
private Expression	Column.defaultExpression
private Expression[]	DataChangeDeltaTable.expressions
private Expression	TableFilter.filterCondition	Additional conditions that can't be used for index lookup, but for row filter for this table (ID=ID, NAME LIKE '%X%')
private Expression	TableFilter.fullCondition
private Expression	TableFilter.joinCondition	The complete join condition.
private Expression	RangeTable.max
private Expression	RangeTable.min
private Expression	TableFilter.MapColumnsVisitor.on
private Expression	Column.onUpdateExpression
private Expression	RangeTable.step

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

Modifier and Type	Field	Description
private java.util.ArrayList<java.util.ArrayList<Expression>>	TableValueConstructorTable.rows

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.
(package private) boolean	TableFilter.isOk(Expression condition)	Whether the current value of the condition is true, or there is no condition.
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

Constructor	Description
MapColumnsVisitor(Expression on)
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

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