Package | Description |
---|---|
org.h2.command | |
org.h2.command.ddl | |
org.h2.command.dml | |
org.h2.constraint | |
org.h2.engine | |
org.h2.expression | |
org.h2.index | |
org.h2.result | |
org.h2.table |
Modifier and Type | Method and Description |
---|---|
Expression |
Parser.parseExpression(String sql)
Parse a SQL code snippet that represents an expression.
|
Modifier and Type | Method and Description |
---|---|
protected static String |
Prepared.getSQL(Expression[] list)
Get the SQL snippet of the expression list.
|
Modifier and Type | Method and Description |
---|---|
void |
CreateSequence.setCacheSize(Expression cacheSize) |
void |
AlterTableAddConstraint.setCheckExpression(Expression expression) |
void |
SetComment.setCommentExpression(Expression expr) |
void |
AlterTableAlterColumn.setDefaultExpression(Expression defaultExpression) |
void |
CreateConstant.setExpression(Expression expr) |
void |
CreateUser.setHash(Expression e) |
void |
AlterUser.setHash(Expression e) |
void |
CreateSequence.setIncrement(Expression increment) |
void |
CreateUser.setPassword(Expression password) |
void |
AlterUser.setPassword(Expression password) |
void |
CreateUser.setSalt(Expression e) |
void |
AlterUser.setSalt(Expression e) |
void |
AlterTableAlterColumn.setSelectivity(Expression selectivity) |
void |
CreateSequence.setStartWith(Expression start) |
Modifier and Type | Field and Description |
---|---|
Expression |
SelectOrderBy.columnIndexExpr
The column index expression.
|
Expression |
SelectOrderBy.expression
The order by expression.
|
protected Expression |
Query.limitExpr
The limit expression as specified in the LIMIT or TOP clause.
|
protected Expression |
Query.offsetExpr
The offset expression as specified in the LIMIT ..
|
Modifier and Type | Method and Description |
---|---|
Expression |
SelectListColumnResolver.optimize(ExpressionColumn expressionColumn,
Column column) |
Modifier and Type | Method and Description |
---|---|
HashMap<Expression,Object> |
Select.getCurrentGroup() |
ArrayList<Expression> |
SelectUnion.getExpressions() |
ArrayList<Expression> |
Select.getExpressions() |
abstract ArrayList<Expression> |
Query.getExpressions()
The the list of select expressions.
|
Modifier and Type | Method and Description |
---|---|
void |
Select.addCondition(Expression cond)
Add a condition to the list of conditions.
|
void |
Merge.addRow(Expression[] expr)
Add a row to this merge statement.
|
void |
Insert.addRow(Expression[] expr)
Add a row to this merge statement.
|
void |
Update.setAssignment(Column column,
Expression expression)
Add an assignment of the form column = expression.
|
void |
Update.setCondition(Expression condition) |
void |
Delete.setCondition(Expression condition) |
void |
Set.setExpression(Expression expression) |
void |
Call.setExpression(Expression expression) |
void |
ExecuteProcedure.setExpression(int index,
Expression expr)
Set the expression at the given index.
|
void |
BackupCommand.setFileName(Expression fileName) |
void |
Select.setHaving(Expression having) |
void |
AlterSequence.setIncrement(Expression increment) |
void |
Query.setLimit(Expression limit) |
void |
Delete.setLimit(Expression limit) |
void |
Query.setOffset(Expression offset) |
void |
AlterSequence.setStartWith(Expression start) |
Modifier and Type | Method and Description |
---|---|
void |
Select.setExpressions(ArrayList<Expression> expressions) |
void |
Select.setGroupBy(ArrayList<Expression> group) |
Modifier and Type | Method and Description |
---|---|
Expression |
ConstraintCheck.getExpression() |
Modifier and Type | Method and Description |
---|---|
void |
ConstraintCheck.setExpression(Expression expr) |
Modifier and Type | Method and Description |
---|---|
FunctionAlias.JavaMethod |
FunctionAlias.findJavaMethod(Expression[] args)
Find the Java method that matches the arguments.
|
Value |
FunctionAlias.JavaMethod.getValue(Session session,
Expression[] args,
boolean columnList)
Call the user-defined function and return the value.
|
Modifier and Type | Class and Description |
---|---|
class |
Aggregate
Implements the integrated aggregate functions, such as COUNT, MAX, SUM.
|
class |
Alias
A column alias as in SELECT 'Hello' AS NAME ...
|
class |
CompareLike
Pattern matching comparison expression: WHERE NAME LIKE ?
|
class |
Comparison
Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
|
class |
ConditionAndOr
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
|
class |
ConditionExists
An 'exists' condition as in WHERE EXISTS(SELECT ...)
|
class |
ConditionIn
An 'in' condition with a list of values, as in WHERE NAME IN(...)
|
class |
ConditionInSelect
An 'in' condition with a subquery, as in WHERE ID IN(SELECT ...)
|
class |
ConditionNot
A NOT condition.
|
class |
ExpressionColumn
A expression that represents a column of a table or view.
|
class |
ExpressionList
A list of expressions, as in (ID, NAME).
|
class |
Function
This class implements most built-in functions of this database.
|
class |
JavaAggregate
This class wraps a user-defined aggregate.
|
class |
JavaFunction
This class wraps a user-defined function.
|
class |
Operation
A mathematical expression, or string concatenation.
|
class |
Parameter
A parameter of a prepared statement.
|
class |
Rownum
Represents the ROWNUM function.
|
class |
SequenceValue
Wraps a sequence when used in a statement.
|
class |
Subquery
A query returning a single value.
|
class |
TableFunction
Implementation of the functions TABLE(..) and TABLE_DISTINCT(..).
|
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.
|
Modifier and Type | Field and Description |
---|---|
protected Expression[] |
Function.args |
Modifier and Type | Method and Description |
---|---|
Expression[] |
JavaFunction.getArgs() |
Expression[] |
FunctionCall.getArgs()
Get the function arguments.
|
Expression[] |
Function.getArgs() |
Expression |
ConditionAndOr.getExpression(boolean getLeft)
Get the left or the right sub-expression of this condition.
|
Expression |
Comparison.getExpression(boolean getLeft)
Get the left or the right sub-expression of this condition.
|
Expression[] |
ValueExpression.getExpressionColumns(Session session) |
Expression[] |
TableFunction.getExpressionColumns(Session session) |
Expression[] |
Subquery.getExpressionColumns(Session session) |
Expression[] |
JavaFunction.getExpressionColumns(Session session) |
Expression[] |
ExpressionList.getExpressionColumns(Session session) |
Expression[] |
Expression.getExpressionColumns(Session session)
If this expression consists of column expressions it should return them.
|
static Expression[] |
Expression.getExpressionColumns(Session session,
ResultSet rs)
Extracts expression columns from the given result set.
|
Expression |
Expression.getNonAliasExpression()
Returns the main expression, skipping aliases.
|
Expression |
Alias.getNonAliasExpression() |
Expression |
ValueExpression.getNotIfPossible(Session session) |
Expression |
Parameter.getNotIfPossible(Session session) |
Expression |
ExpressionColumn.getNotIfPossible(Session session) |
Expression |
Expression.getNotIfPossible(Session session)
If it is possible, return the negated expression.
|
Expression |
ConditionNot.getNotIfPossible(Session session) |
Expression |
ConditionAndOr.getNotIfPossible(Session session) |
Expression |
Comparison.getNotIfPossible(Session session) |
Expression |
Wildcard.optimize(Session session) |
Expression |
Variable.optimize(Session session) |
Expression |
ValueExpression.optimize(Session session) |
Expression |
Subquery.optimize(Session session) |
Expression |
SequenceValue.optimize(Session session) |
Expression |
Rownum.optimize(Session session) |
Expression |
Parameter.optimize(Session session) |
Expression |
Operation.optimize(Session session) |
Expression |
JavaFunction.optimize(Session session) |
Expression |
JavaAggregate.optimize(Session session) |
Expression |
FunctionCall.optimize(Session session)
Optimize the function if possible.
|
Expression |
Function.optimize(Session session) |
Expression |
ExpressionList.optimize(Session session) |
Expression |
ExpressionColumn.optimize(Session session) |
abstract Expression |
Expression.optimize(Session session)
Try to optimize the expression.
|
Expression |
ConditionNot.optimize(Session session) |
Expression |
ConditionInSelect.optimize(Session session) |
Expression |
ConditionIn.optimize(Session session) |
Expression |
ConditionExists.optimize(Session session) |
Expression |
ConditionAndOr.optimize(Session session) |
Expression |
Comparison.optimize(Session session) |
Expression |
CompareLike.optimize(Session session) |
Expression |
Alias.optimize(Session session) |
Expression |
Aggregate.optimize(Session session) |
Modifier and Type | Method and Description |
---|---|
ValueResultSet |
TableFunction.getValueForColumnList(Session session,
Expression[] nullArgs) |
ValueResultSet |
JavaFunction.getValueForColumnList(Session session,
Expression[] argList) |
ValueResultSet |
FunctionCall.getValueForColumnList(Session session,
Expression[] nullArgs)
Get an empty result set with the column names set.
|
ValueResultSet |
Function.getValueForColumnList(Session session,
Expression[] argList) |
void |
Function.setParameter(int index,
Expression param)
Set the parameter expression at the given index.
|
void |
Aggregate.setSeparator(Expression separator)
Set the separator for GROUP_CONCAT.
|
Constructor and Description |
---|
Aggregate(int type,
Expression on,
Select select,
boolean distinct)
Create a new aggregate object.
|
Alias(Expression expression,
String alias,
boolean aliasColumnName) |
CompareLike(CompareMode compareMode,
String defaultEscape,
Expression left,
Expression right,
Expression escape,
boolean regexp) |
CompareLike(Database db,
Expression left,
Expression right,
Expression escape,
boolean regexp) |
Comparison(Session session,
int compareType,
Expression left,
Expression right) |
ConditionAndOr(int andOrType,
Expression left,
Expression right) |
ConditionIn(Database database,
Expression left,
ArrayList<Expression> values)
Create a new IN(..) condition.
|
ConditionInSelect(Database database,
Expression left,
Query query,
boolean all,
int compareType) |
ConditionNot(Expression condition) |
ExpressionList(Expression[] list) |
JavaAggregate(UserAggregate userAggregate,
Expression[] args,
Select select) |
JavaFunction(FunctionAlias functionAlias,
Expression[] args) |
Operation(int opType,
Expression left,
Expression right) |
Constructor and Description |
---|
ConditionIn(Database database,
Expression left,
ArrayList<Expression> values)
Create a new IN(..) condition.
|
Modifier and Type | Method and Description |
---|---|
static IndexCondition |
IndexCondition.get(int compareType,
ExpressionColumn column,
Expression expression)
Create an index condition with the given parameters.
|
Modifier and Type | Method and Description |
---|---|
static IndexCondition |
IndexCondition.getInList(ExpressionColumn column,
List<Expression> list)
Create an index condition with the compare type IN_LIST and with the
given parameters.
|
Modifier and Type | Method and Description |
---|---|
String |
SortOrder.getSQL(Expression[] list,
int visible)
Create the SQL snippet that describes this sort order.
|
Constructor and Description |
---|
LocalResult(Session session,
Expression[] expressions,
int visibleColumnCount)
Construct a local result object.
|
Modifier and Type | Method and Description |
---|---|
Expression |
Column.getCheckConstraint(Session session,
String asColumnName)
Get the check constraint expression for this column if set.
|
Expression |
Column.getDefaultExpression() |
Expression |
TableFilter.getFilterCondition() |
Expression |
TableFilter.getJoinCondition() |
Expression |
TableFilter.optimize(ExpressionColumn expressionColumn,
Column column) |
Expression |
SingleColumnResolver.optimize(ExpressionColumn expressionColumn,
Column col) |
Expression |
ColumnResolver.optimize(ExpressionColumn expressionColumn,
Column column)
Get the expression that represents this column.
|
Modifier and Type | Method and Description |
---|---|
void |
Column.addCheckConstraint(Session session,
Expression expr)
Add a check constraint expression to this column.
|
void |
TableFilter.addFilterCondition(Expression condition,
boolean isJoin)
Add a filter condition.
|
void |
TableFilter.addJoin(TableFilter filter,
boolean outer,
boolean nested,
Expression on)
Add a joined table.
|
void |
TableFilter.mapAndAddFilter(Expression on)
Map the columns and add the join condition.
|
void |
Column.setComputedExpression(Expression expression)
Set the default value in the form of a computed expression of other
columns.
|
void |
Column.setDefaultExpression(Session session,
Expression defaultExpression)
Set the default expression.
|
void |
TableFilter.setFullCondition(Expression condition) |
Constructor and Description |
---|
FunctionTable(Schema schema,
Session session,
Expression functionExpr,
FunctionCall function) |
Plan(TableFilter[] filters,
int count,
Expression condition)
Create a query plan with the given order.
|
RangeTable(Schema schema,
Expression min,
Expression max,
boolean noColumns)
Create a new range with the given start and end expressions.
|
Copyright © 2012 JBoss by Red Hat. All Rights Reserved.