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, orValueExpression.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 inX'01' || X'AB'
or an array concatenation as inARRAY[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. -
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 aggregateMethods 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 ofBitFunction.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)
-
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 forMode.ModeEnum.DB2
andMode.ModeEnum.Derby
compatibility modes.class
FunctionsLegacy
This class implements some legacy functions not available in Regular mode.class
FunctionsMSSQLServer
Functions forMode.ModeEnum.MSSQLServer
compatibility mode.class
FunctionsMySQL
This class implements some MySQL-specific functions.class
FunctionsOracle
Functions forMode.ModeEnum.Oracle
compatibility mode.class
FunctionsPostgreSQL
Functions forMode.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)
-