Top Description Fields Constructors Methods
org.hsqldb

public Class ExpressionArrayAggregate

extends Expression
Class Inheritance
Imports
org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.ArrayListIdentity, .ArrayUtil, .HsqlArrayList, .List, org.hsqldb.types.ArrayType, .DateTimeType, .RowType, .Type

Implementation of array aggregate operations
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
2.0.1
Version
2.7.4

Field Summary

Modifier and TypeField and Description
pack-priv ArrayType
pack-priv Expression
pack-priv SortAndSlice
pack-priv Type
pack-priv int
pack-priv String
pack-priv int
pack-priv boolean
pack-priv boolean
pack-priv String
pack-priv SortAndSlice
pack-priv boolean
Inherited from org.hsqldb.Expression:
aliasBINARYcollationcolumnIndexdataTypeemptyArrayEXPR_FALSEEXPR_TRUEexprSubTypegroupingTypeisColumnConditionisColumnEqualisCorrelatedisDistinctAggregateisSingleColumnConditionisSingleColumnEqualisSingleColumnNotNullisSingleColumnNullLEFTnodeDataTypesnodesnoOptimisationnullabilityopTypeparameterIndexrangeGrouprangeGroupsresultTableColumnIndexRIGHTtableTERNARYTHIRDUNARYvalueData

Constructor Summary

AccessConstructor and Description
pack-priv
ExpressionArrayAggregate(int type, boolean distinct, Expression e, SortAndSlice sort, String separator, String filler, boolean overflowTruncate, boolean overflowError, boolean withCount, int maxElements)

Method Summary

Modifier and TypeMethod and Description
protected String
describe(Session session, int blanks)

Overrides org.hsqldb.Expression.describe.

public Expression
pack-priv boolean
equals(Expression other)

Overrides org.hsqldb.Expression.equals.

SIMPLE_COLUMN expressions can be of different Expression subclass types

public Object
public Expression
public String
getSQL()

Overrides org.hsqldb.Expression.getSQL.

For use with CHECK constraints.

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

Overrides org.hsqldb.Expression.resolveColumnReferences.

public void
public void
public SetFunction
public SetFunction
Inherited from org.hsqldb.Expression:
checkValidCheckConstraintcollectAllExpressionscollectAllSubqueriescollectObjectNamescollectRangeVariablescollectRangeVariablesconvertToTypecostFactorcountNullsequalsequalsequalsgetAliasgetCheckSelectgetColumngetColumnIndexgetColumnNamegetConstantValueNoCheckgetContextSQLgetDataTypegetDegreegetIndexableExpressiongetJoinRangeVariablesgetLeftNodegetNodeDataTypegetNodeDataTypesgetNullabilitygetRangeVariablegetResultgetRightNodegetRowValuegetSimpleNamegetSubqueriesgetSubTypegetTablegetTypegetUnkeyedColumnsgetValuegetValuegetValueClassNamehasAggregatehashCodehasNonDeterministicFunctionhasReferencehasReferenceinsertValuesIntoSubqueryTableisComposedOfisComposedOfisConditionRangeVariableisCorrelatedisDistinctAggregateisDynamicParamisFalseisIndexableisTrueisUnresolvedParammaterialiseprepareTablereplaceAliasInOrderByreplaceColumnReferencesreplaceExpressionsreplaceNodereplaceRangeVariablesresetColumnReferencesresolveCheckOrGenExpressionresolveColumnReferencesresolveColumnSetresolveColumnSetresolveGrantFiltersetAggregatesetAliassetAsConstantValuesetAsConstantValuesetAttributesAsColumnsetCollationsetCorrelatedReferencessetDataTypesetLeftNodesetNoOptimisationsetRightNodesetSubTypeswapLeftAndRightNodestestCondition

Field Detail

arrayDataTypeback to summary
pack-priv ArrayType arrayDataType
conditionback to summary
pack-priv Expression condition
distinctSortback to summary
pack-priv SortAndSlice distinctSort
exprDataTypeback to summary
pack-priv Type exprDataType
exprOpTypeback to summary
pack-priv int exprOpType
fillerback to summary
pack-priv String filler
maxElementsback to summary
pack-priv int maxElements
overflowErrorback to summary
pack-priv boolean overflowError
overflowTruncateback to summary
pack-priv boolean overflowTruncate
separatorback to summary
pack-priv String separator
sortback to summary
pack-priv SortAndSlice sort
withCountback to summary
pack-priv boolean withCount

Constructor Detail

ExpressionArrayAggregateback to summary
pack-priv ExpressionArrayAggregate(int type, boolean distinct, Expression e, SortAndSlice sort, String separator, String filler, boolean overflowTruncate, boolean overflowError, boolean withCount, int maxElements)

Method Detail

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

Overrides org.hsqldb.Expression.describe.

duplicateback to summary
public Expression duplicate()

Overrides org.hsqldb.Expression.duplicate.

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.

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.

hasConditionback to summary
public boolean hasCondition()

Overrides org.hsqldb.Expression.hasCondition.

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.

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.

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

Overrides org.hsqldb.Expression.updateAggregatingValue.