HyperSQL Database 2.7.4 · org.hsqldb.ExpressionColumn

Modifier and Type	Field and Description
pack-priv ColumnSchema	column
pack-priv String	columnName
public static final OrderedHashMap<String, ColumnSchema>	diagnosticsList
pack-priv static final String[]	diagnosticsVariableTokens
public static final ExpressionColumn[]	emptyArray Hides org.hsqldb.Expression.emptyArray.
public static final int	idx_more
public static final int	idx_number
public static final int	idx_row_count
pack-priv boolean	isParam
pack-priv boolean	isUpdateColumn
pack-priv int	rangePosition
pack-priv RangeVariable	rangeVariable
pack-priv static final HsqlNameManager.SimpleName	rownumName
pack-priv String	schema
pack-priv NumberSequence	sequence
pack-priv String	tableName

Access	Constructor and Description
pack-priv	ExpressionColumn(String schema, String table, String column) Creates a OpTypes.COLUMN expression
pack-priv	ExpressionColumn(String column) Column reference in MySQL INSERT
pack-priv	ExpressionColumn(ColumnSchema column)
pack-priv	ExpressionColumn(RangeVariable rangeVar, ColumnSchema column)
pack-priv	ExpressionColumn(RangeVariable rangeVar, int index)
pack-priv	ExpressionColumn(Expression e, int colIndex, int rangePosition) Creates a temporary OpTypes.SIMPLE_COLUMN expression
pack-priv	ExpressionColumn(int type)
pack-priv	ExpressionColumn(int type, int columnIndex) For diagnostics vars
pack-priv	ExpressionColumn(Expression[] nodes, String name)
pack-priv	ExpressionColumn(Expression groups) for GROUPING function
pack-priv	ExpressionColumn(String schema, String table) Creates an OpCodes.ASTERISK expression
pack-priv	ExpressionColumn(NumberSequence sequence, int opType) Creates a OpTypes.SEQUENCE expression

Modifier and Type	Method and Description
public static void	checkColumnsResolved(List<Expression> set)
pack-priv void	collectObjectNames(Set<HsqlNameManager.HsqlName> set) Overrides org.hsqldb.Expression.collectObjectNames. collects all schema objects
pack-priv OrderedHashSet<RangeVariable>	collectRangeVariables(OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.Expression.collectRangeVariables. collects all range variables in expression tree
pack-priv OrderedHashSet<RangeVariable>	collectRangeVariables(RangeVariable[] rangeVariables, OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.Expression.collectRangeVariables.
pack-priv double	costFactor(Session session, RangeVariable range, int operation) Overrides org.hsqldb.Expression.costFactor. For normal tables only.
protected String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public Expression	duplicate() Overrides org.hsqldb.Expression.duplicate.
pack-priv boolean	equals(Expression other) Overrides org.hsqldb.Expression.equals. SIMPLE_COLUMN expressions are now (2.4.0) always ExpressionColumn
pack-priv String	getAlias() Overrides org.hsqldb.Expression.getAlias. Get the column alias
public ColumnSchema	getColumn() Overrides org.hsqldb.Expression.getColumn.
pack-priv String	getColumnName() Overrides org.hsqldb.Expression.getColumnName. Returns the name of a column as string
private Object	getDiagnosticsVariable(Session session)
pack-priv void	getJoinRangeVariables(RangeVariable[] ranges, List<RangeVariable> list) Overrides org.hsqldb.Expression.getJoinRangeVariables.
public byte	getNullability() Overrides org.hsqldb.Expression.getNullability.
pack-priv RangeVariable	getRangeVariable() Overrides org.hsqldb.Expression.getRangeVariable. Returns the range variable for a COLUMN or PERIOD expression
pack-priv String	getSchemaName()
pack-priv HsqlNameManager.SimpleName	getSimpleName() Overrides org.hsqldb.Expression.getSimpleName.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
pack-priv String	Returns: table name getTableName() Returns the table name used in query
public OrderedHashSet<Expression>	getUnkeyedColumns(OrderedHashSet<Expression> unresolvedSet) Overrides org.hsqldb.Expression.getUnkeyedColumns.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
pack-priv boolean	hasReference(RangeVariable range) Overrides org.hsqldb.Expression.hasReference. return true if given RangeVariable is used in expression tree
pack-priv boolean	isDynamicParam() Overrides org.hsqldb.Expression.isDynamicParam.
public boolean	isIndexable(RangeVariable range) Overrides org.hsqldb.Expression.isIndexable.
public boolean	isUnresolvedParam() Overrides org.hsqldb.Expression.isUnresolvedParam.
pack-priv Expression	replaceAliasInOrderBy(Session session, List<Expression> columns, int length) Overrides org.hsqldb.Expression.replaceAliasInOrderBy. return the expression for an alias used in an ORDER BY clause
pack-priv Expression	replaceColumnReferences(Session session, RangeVariable range, Expression[] list) Overrides org.hsqldb.Expression.replaceColumnReferences.
pack-priv void	replaceRangeVariables(RangeVariable[] ranges, RangeVariable[] newRanges) Overrides org.hsqldb.Expression.replaceRangeVariables.
pack-priv void	resetColumnReferences() Overrides org.hsqldb.Expression.resetColumnReferences.
pack-priv boolean	resolveColumnReference(RangeVariable rangeVar, boolean outer)
public List<Expression>	resolveColumnReferences(Session session, RangeGroup rangeGroup, int rangeCount, RangeGroup[] rangeGroups, List<Expression> unresolvedSet, boolean acceptsSequences) Overrides org.hsqldb.Expression.resolveColumnReferences.
private boolean	resolveCorrelated(RangeGroup rangeGroup, RangeGroup[] rangeGroups)
pack-priv boolean	resolvesDuplicateColumnReference(RangeVariable rangeVar)
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.
pack-priv void	setAttributesAsColumn(RangeVariable range, int i)
pack-priv void	setAttributesAsColumn(ColumnSchema column) Overrides org.hsqldb.Expression.setAttributesAsColumn.
pack-priv void	setAutoAttributesAsColumn(RangeVariable range, int i)

column	back to summary
pack-priv ColumnSchema column

columnName	back to summary
pack-priv String columnName

diagnosticsList	back to summary
public static final OrderedHashMap<String, ColumnSchema> diagnosticsList

diagnosticsVariableTokens	back to summary
pack-priv static final String[] diagnosticsVariableTokens

emptyArray	back to summary
public static final ExpressionColumn[] emptyArray Hides org.hsqldb.Expression.emptyArray.

idx_more	back to summary
public static final int idx_more

idx_number	back to summary
public static final int idx_number

idx_row_count	back to summary
public static final int idx_row_count

isParam	back to summary
pack-priv boolean isParam

isUpdateColumn	back to summary
pack-priv boolean isUpdateColumn

rangePosition	back to summary
pack-priv int rangePosition

rangeVariable	back to summary
pack-priv RangeVariable rangeVariable

rownumName	back to summary
pack-priv static final HsqlNameManager.SimpleName rownumName

schema	back to summary
pack-priv String schema

sequence	back to summary
pack-priv NumberSequence sequence

tableName	back to summary
pack-priv String tableName

ExpressionColumn	back to summary
pack-priv ExpressionColumn(String schema, String table, String column) Creates a OpTypes.COLUMN expression

ExpressionColumn	back to summary
pack-priv ExpressionColumn(String column) Column reference in MySQL INSERT

ExpressionColumn	back to summary
pack-priv ExpressionColumn(ColumnSchema column)

ExpressionColumn	back to summary
pack-priv ExpressionColumn(RangeVariable rangeVar, ColumnSchema column)

ExpressionColumn	back to summary
pack-priv ExpressionColumn(RangeVariable rangeVar, int index)

ExpressionColumn	back to summary
pack-priv ExpressionColumn(Expression e, int colIndex, int rangePosition) Creates a temporary OpTypes.SIMPLE_COLUMN expression

ExpressionColumn	back to summary
pack-priv ExpressionColumn(int type)

ExpressionColumn	back to summary
pack-priv ExpressionColumn(int type, int columnIndex) For diagnostics vars

ExpressionColumn	back to summary
pack-priv ExpressionColumn(Expression[] nodes, String name)

ExpressionColumn	back to summary
pack-priv ExpressionColumn(Expression groups) for GROUPING function

ExpressionColumn	back to summary
pack-priv ExpressionColumn(String schema, String table) Creates an OpCodes.ASTERISK expression

ExpressionColumn	back to summary
pack-priv ExpressionColumn(NumberSequence sequence, int opType) Creates a OpTypes.SEQUENCE expression

Method Detail

checkColumnsResolved	back to summary
public static void checkColumnsResolved(List<Expression> set)

collectObjectNames	back 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

collectObjectNames

back 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

collectRangeVariables	back to summary
pack-priv OrderedHashSet<RangeVariable> collectRangeVariables(OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.Expression.collectRangeVariables. collects all range variables in expression tree

collectRangeVariables

back to summary

pack-priv OrderedHashSet<RangeVariable> collectRangeVariables(OrderedHashSet<RangeVariable> set)

Overrides org.hsqldb.Expression.collectRangeVariables.

collects all range variables in expression tree

collectRangeVariables	back to summary
pack-priv OrderedHashSet<RangeVariable> collectRangeVariables(RangeVariable[] rangeVariables, OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.Expression.collectRangeVariables.

costFactor	back to summary
pack-priv double costFactor(Session session, RangeVariable range, int operation) Overrides org.hsqldb.Expression.costFactor. For normal tables only. We don't want to create an index on each column that is checked.

costFactor

back to summary

pack-priv double costFactor(Session session, RangeVariable range, int operation)

Overrides org.hsqldb.Expression.costFactor.

For normal tables only. We don't want to create an index on each column that is checked.

describe	back to summary
protected String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

duplicate	back to summary
public Expression duplicate() Overrides org.hsqldb.Expression.duplicate.

equals	back to summary
pack-priv boolean equals(Expression other) Overrides org.hsqldb.Expression.equals. SIMPLE_COLUMN expressions are now (2.4.0) always ExpressionColumn

equals

back to summary

pack-priv boolean equals(Expression other)

Overrides org.hsqldb.Expression.equals.

SIMPLE_COLUMN expressions are now (2.4.0) always ExpressionColumn

getAlias	back to summary
pack-priv String getAlias() Overrides org.hsqldb.Expression.getAlias. Doc from org.hsqldb.Expression.getAlias. Get the column alias

getAlias

back to summary

pack-priv String getAlias()

Overrides org.hsqldb.Expression.getAlias.

Doc from org.hsqldb.Expression.getAlias.

Get the column alias

getColumn	back to summary
public ColumnSchema getColumn() Overrides org.hsqldb.Expression.getColumn.

getColumnName	back to summary
pack-priv String getColumnName() Overrides org.hsqldb.Expression.getColumnName. Doc from org.hsqldb.Expression.getColumnName. Returns the name of a column as string

getColumnName

back to summary

pack-priv String getColumnName()

Overrides org.hsqldb.Expression.getColumnName.

Doc from org.hsqldb.Expression.getColumnName.

Returns the name of a column as string

getDiagnosticsVariable	back to summary
private Object getDiagnosticsVariable(Session session)

getJoinRangeVariables	back to summary
pack-priv void getJoinRangeVariables(RangeVariable[] ranges, List<RangeVariable> list) Overrides org.hsqldb.Expression.getJoinRangeVariables.

getNullability	back to summary
public byte getNullability() Overrides org.hsqldb.Expression.getNullability.

getRangeVariable	back to summary
pack-priv RangeVariable getRangeVariable() Overrides org.hsqldb.Expression.getRangeVariable. Doc from org.hsqldb.Expression.getRangeVariable. Returns the range variable for a COLUMN or PERIOD expression

getRangeVariable

back to summary

pack-priv RangeVariable getRangeVariable()

Overrides org.hsqldb.Expression.getRangeVariable.

Doc from org.hsqldb.Expression.getRangeVariable.

Returns the range variable for a COLUMN or PERIOD expression

getSchemaName	back to summary
pack-priv String getSchemaName()

getSimpleName	back to summary
pack-priv HsqlNameManager.SimpleName getSimpleName() Overrides org.hsqldb.Expression.getSimpleName.

getSQL	back 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.

getSQL

back 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.

getTableName	back to summary
pack-priv String getTableName() Returns the table name used in query Returns:String table name

getTableName

back to summary

pack-priv String getTableName()

Returns the table name used in query

Returns:String: table name

getUnkeyedColumns	back to summary
public OrderedHashSet<Expression> getUnkeyedColumns(OrderedHashSet<Expression> unresolvedSet) Overrides org.hsqldb.Expression.getUnkeyedColumns.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

hasReference

back to summary

pack-priv boolean hasReference(RangeVariable range)

Overrides org.hsqldb.Expression.hasReference.

return true if given RangeVariable is used in expression tree

isDynamicParam	back to summary
pack-priv boolean isDynamicParam() Overrides org.hsqldb.Expression.isDynamicParam.

isIndexable	back to summary
public boolean isIndexable(RangeVariable range) Overrides org.hsqldb.Expression.isIndexable.

isUnresolvedParam	back to summary
public boolean isUnresolvedParam() Overrides org.hsqldb.Expression.isUnresolvedParam.

replaceAliasInOrderBy

back to summary

pack-priv Expression replaceAliasInOrderBy(Session session, List<Expression> columns, int length)

Overrides org.hsqldb.Expression.replaceAliasInOrderBy.

Doc from org.hsqldb.Expression.replaceAliasInOrderBy.

return the expression for an alias used in an ORDER BY clause

replaceColumnReferences	back to summary
pack-priv Expression replaceColumnReferences(Session session, RangeVariable range, Expression[] list) Overrides org.hsqldb.Expression.replaceColumnReferences.

replaceRangeVariables	back to summary
pack-priv void replaceRangeVariables(RangeVariable[] ranges, RangeVariable[] newRanges) Overrides org.hsqldb.Expression.replaceRangeVariables.

resetColumnReferences	back to summary
pack-priv void resetColumnReferences() Overrides org.hsqldb.Expression.resetColumnReferences.

resolveColumnReference	back to summary
pack-priv boolean resolveColumnReference(RangeVariable rangeVar, boolean outer)

resolveColumnReferences	back to summary
public List<Expression> resolveColumnReferences(Session session, RangeGroup rangeGroup, int rangeCount, RangeGroup[] rangeGroups, List<Expression> unresolvedSet, boolean acceptsSequences) Overrides org.hsqldb.Expression.resolveColumnReferences.

resolveCorrelated	back to summary
private boolean resolveCorrelated(RangeGroup rangeGroup, RangeGroup[] rangeGroups)

resolvesDuplicateColumnReference	back to summary
pack-priv boolean resolvesDuplicateColumnReference(RangeVariable rangeVar)

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

setAttributesAsColumn	back to summary
pack-priv void setAttributesAsColumn(RangeVariable range, int i)

setAttributesAsColumn	back to summary
pack-priv void setAttributesAsColumn(ColumnSchema column) Overrides org.hsqldb.Expression.setAttributesAsColumn.

setAutoAttributesAsColumn	back to summary
pack-priv void setAutoAttributesAsColumn(RangeVariable range, int i)

public Class ExpressionColumn

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail