Top Description Fields Constructors Methods
org.hsqldb

public Class ExpressionOrderBy

extends Expression
Class Inheritance
Imports
org.hsqldb.error.Error, .ErrorCode
Implementation of ORDER BY operations
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.0.1

Field Summary

Modifier and TypeField and Description
private boolean
isDescending

private boolean
isNullsLast

Inherited from org.hsqldb.Expression:
aliasBINARYcollationcolumnIndexdataTypeemptyArrayEXPR_FALSEEXPR_TRUEexprSubTypegroupingTypeisColumnConditionisColumnEqualisCorrelatedisDistinctAggregateisSingleColumnConditionisSingleColumnEqualisSingleColumnNotNullisSingleColumnNullLEFTnodeDataTypesnodesnoOptimisationnullabilityopTypeparameterIndexrangeGrouprangeGroupsresultTableColumnIndexRIGHTtableTERNARYTHIRDUNARYvalueData

Constructor Summary

AccessConstructor and Description
pack-priv
ExpressionOrderBy(Expression e)

Method Summary

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

Overrides org.hsqldb.Expression.describe.

public String
getSQL()

Overrides org.hsqldb.Expression.getSQL.

For use with CHECK constraints.

public Object
getValue(Session session)

Overrides org.hsqldb.Expression.getValue.

pack-priv boolean
isDescending()

Is an ORDER BY column expression DESC

pack-priv boolean
isNullsLast()

Is an ORDER BY column NULL ordering

public void
resolveTypes(Session session, Expression parent)

Overrides org.hsqldb.Expression.resolveTypes.

pack-priv void
setDescending()

Set an ORDER BY column expression DESC

pack-priv void
setNullsLast(boolean value)

Set an ORDER BY column NULL ordering

Inherited from org.hsqldb.Expression:
checkValidCheckConstraintcollectAllExpressionscollectAllSubqueriescollectObjectNamescollectRangeVariablescollectRangeVariablesconvertToTypecostFactorcountNullsduplicateequalsequalsequalsequalsgetAggregatedValuegetAliasgetCheckSelectgetColumngetColumnIndexgetColumnNamegetConditiongetConstantValueNoCheckgetContextSQLgetDataTypegetDegreegetIndexableExpressiongetJoinRangeVariablesgetLeftNodegetNodeDataTypegetNodeDataTypesgetNullabilitygetRangeVariablegetResultgetRightNodegetRowValuegetSimpleNamegetSubqueriesgetSubTypegetTablegetTypegetUnkeyedColumnsgetValuegetValueClassNamehasAggregatehasConditionhashCodehasNonDeterministicFunctionhasReferencehasReferenceinsertValuesIntoSubqueryTableisComposedOfisComposedOfisConditionRangeVariableisCorrelatedisDistinctAggregateisDynamicParamisFalseisIndexableisSelfAggregateisTrueisUnresolvedParammaterialiseprepareTablereplaceAliasInOrderByreplaceColumnReferencesreplaceExpressionsreplaceNodereplaceRangeVariablesresetColumnReferencesresolveCheckOrGenExpressionresolveColumnReferencesresolveColumnReferencesresolveColumnSetresolveColumnSetresolveGrantFiltersetAggregatesetAliassetAsConstantValuesetAsConstantValuesetAttributesAsColumnsetCollationsetConditionsetCorrelatedReferencessetDataTypesetLeftNodesetNoOptimisationsetRightNodesetSubTypeswapLeftAndRightNodestestConditionupdateAggregatingValueupdateAggregatingValue

Field Detail

isDescendingback to summary
private boolean isDescending
isNullsLastback to summary
private boolean isNullsLast

Constructor Detail

ExpressionOrderByback to summary
pack-priv ExpressionOrderBy(Expression e)

Method Detail

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

Overrides org.hsqldb.Expression.describe.

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.

isDescendingback to summary
pack-priv boolean isDescending()

Is an ORDER BY column expression DESC

isNullsLastback to summary
pack-priv boolean isNullsLast()

Is an ORDER BY column NULL ordering

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

Overrides org.hsqldb.Expression.resolveTypes.

setDescendingback to summary
pack-priv void setDescending()

Set an ORDER BY column expression DESC

setNullsLastback to summary
pack-priv void setNullsLast(boolean value)

Set an ORDER BY column NULL ordering