Top Description Fields Constructors Methods
org.hsqldb

public Class FunctionSQLInvoked

extends Expression
Class Inheritance
Imports
org.hsqldb.HsqlNameManager.HsqlName, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.ArrayListIdentity, .List, .Set, org.hsqldb.map.ValuePool, org.hsqldb.result.Result, org.hsqldb.types.Type
Implementation of SQL-invoked user-defined function calls - PSM and JRT
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.7.3

Field Summary

Modifier and TypeField and Description
pack-priv Expression
condition

pack-priv Routine
routine

pack-priv RoutineSchema
routineSchema

Inherited from org.hsqldb.Expression:
aliasBINARYcollationcolumnIndexdataTypeemptyArrayEXPR_FALSEEXPR_TRUEexprSubTypegroupingTypeisColumnConditionisColumnEqualisCorrelatedisDistinctAggregateisSingleColumnConditionisSingleColumnEqualisSingleColumnNotNullisSingleColumnNullLEFTnodeDataTypesnodesnoOptimisationnullabilityopTypeparameterIndexrangeGrouprangeGroupsresultTableColumnIndexRIGHTtableTERNARYTHIRDUNARYvalueData

Constructor Summary

AccessConstructor and Description
pack-priv
FunctionSQLInvoked(RoutineSchema routineSchema)

Method Summary

Modifier and TypeMethod and Description
pack-priv void
collectObjectNames(Set<HsqlNameManager.HsqlName> set)

Overrides org.hsqldb.Expression.collectObjectNames.

collects all schema objects

public String
describe(Session session, int blanks)

Overrides org.hsqldb.Expression.describe.

pack-priv boolean
equals(Expression other)

Overrides org.hsqldb.Expression.equals.

SIMPLE_COLUMN expressions can be of different Expression subclass types

public Object
getAggregatedValue(Session session, SetFunction currValue)

Overrides org.hsqldb.Expression.getAggregatedValue.

public Expression
getCondition()

Overrides org.hsqldb.Expression.getCondition.

public Result
getResult(Session session)

Overrides org.hsqldb.Expression.getResult.

public String
getSQL()

Overrides org.hsqldb.Expression.getSQL.

For use with CHECK constraints.

public Object
getValue(Session session)

Overrides org.hsqldb.Expression.getValue.

private Object
getValueInternal(Session session, Object[] aggregateData)

public boolean
hasCondition()

Overrides org.hsqldb.Expression.hasCondition.

public boolean
isDeterministic()

public boolean
isSelfAggregate()

Overrides org.hsqldb.Expression.isSelfAggregate.

public List<Expression>
resolveColumnReferences(Session session, RangeGroup rangeGroup, int rangeCount, RangeGroup[] rangeGroups, List<Expression> unresolvedSet, boolean acceptsSequences)

Overrides org.hsqldb.Expression.resolveColumnReferences.

public void
resolveTypes(Session session, Expression parent)

Overrides org.hsqldb.Expression.resolveTypes.

public void
setArguments(Expression[] newNodes)

public void
setCondition(Expression e)

Overrides org.hsqldb.Expression.setCondition.

public SetFunction
updateAggregatingValue(Session session, SetFunction currValue)

Overrides org.hsqldb.Expression.updateAggregatingValue.

Inherited from org.hsqldb.Expression:
checkValidCheckConstraintcollectAllExpressionscollectAllSubqueriescollectRangeVariablescollectRangeVariablesconvertToTypecostFactorcountNullsduplicateequalsequalsequalsgetAliasgetCheckSelectgetColumngetColumnIndexgetColumnNamegetConstantValueNoCheckgetContextSQLgetDataTypegetDegreegetIndexableExpressiongetJoinRangeVariablesgetLeftNodegetNodeDataTypegetNodeDataTypesgetNullabilitygetRangeVariablegetRightNodegetRowValuegetSimpleNamegetSubqueriesgetSubTypegetTablegetTypegetUnkeyedColumnsgetValuegetValueClassNamehasAggregatehashCodehasNonDeterministicFunctionhasReferencehasReferenceinsertValuesIntoSubqueryTableisComposedOfisComposedOfisConditionRangeVariableisCorrelatedisDistinctAggregateisDynamicParamisFalseisIndexableisTrueisUnresolvedParammaterialiseprepareTablereplaceAliasInOrderByreplaceColumnReferencesreplaceExpressionsreplaceNodereplaceRangeVariablesresetColumnReferencesresolveCheckOrGenExpressionresolveColumnReferencesresolveColumnSetresolveColumnSetresolveGrantFiltersetAggregatesetAliassetAsConstantValuesetAsConstantValuesetAttributesAsColumnsetCollationsetCorrelatedReferencessetDataTypesetLeftNodesetNoOptimisationsetRightNodesetSubTypeswapLeftAndRightNodestestConditionupdateAggregatingValue

Field Detail

conditionback to summary
pack-priv Expression condition
routineback to summary
pack-priv Routine routine
routineSchemaback to summary
pack-priv RoutineSchema routineSchema

Constructor Detail

FunctionSQLInvokedback to summary
pack-priv FunctionSQLInvoked(RoutineSchema routineSchema)

Method Detail

collectObjectNamesback to summary
pack-priv void collectObjectNames(Set<HsqlNameManager.HsqlName> set)

Overrides org.hsqldb.Expression.collectObjectNames.

Doc from org.hsqldb.Expression.collectObjectNames.

collects all schema objects

describeback to summary
public String describe(Session session, int blanks)

Overrides org.hsqldb.Expression.describe.

equalsback to summary
pack-priv boolean equals(Expression other)

Overrides org.hsqldb.Expression.equals.

Doc from org.hsqldb.Expression.equals.

SIMPLE_COLUMN expressions can be of different Expression subclass types

getAggregatedValueback to summary
public Object getAggregatedValue(Session session, SetFunction currValue)

Overrides org.hsqldb.Expression.getAggregatedValue.

getConditionback to summary
public Expression getCondition()

Overrides org.hsqldb.Expression.getCondition.

getResultback to summary
public Result getResult(Session session)

Overrides org.hsqldb.Expression.getResult.

getSQLback to summary
public String getSQL()

Overrides org.hsqldb.Expression.getSQL.

Doc from org.hsqldb.Expression.getSQL.

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValueback to summary
public Object getValue(Session session)

Overrides org.hsqldb.Expression.getValue.

getValueInternalback to summary
private Object getValueInternal(Session session, Object[] aggregateData)
hasConditionback to summary
public boolean hasCondition()

Overrides org.hsqldb.Expression.hasCondition.

isDeterministicback to summary
public boolean isDeterministic()
isSelfAggregateback to summary
public boolean isSelfAggregate()

Overrides org.hsqldb.Expression.isSelfAggregate.

resolveColumnReferencesback to summary
public List<Expression> resolveColumnReferences(Session session, RangeGroup rangeGroup, int rangeCount, RangeGroup[] rangeGroups, List<Expression> unresolvedSet, boolean acceptsSequences)

Overrides org.hsqldb.Expression.resolveColumnReferences.

resolveTypesback to summary
public void resolveTypes(Session session, Expression parent)

Overrides org.hsqldb.Expression.resolveTypes.

setArgumentsback to summary
public void setArguments(Expression[] newNodes)
setConditionback to summary
public void setCondition(Expression e)

Overrides org.hsqldb.Expression.setCondition.

updateAggregatingValueback to summary
public SetFunction updateAggregatingValue(Session session, SetFunction currValue)

Overrides org.hsqldb.Expression.updateAggregatingValue.