HyperSQL Database 2.7.4 · org.hsqldb.QuerySpecification

Modifier and Type	Field and Description
private boolean[]	aggregateCheck
private ArrayListIdentity<Expression>	aggregateList
private Table	baseTable
pack-priv Expression	checkQueryCondition
pack-priv int[]	columnMap
pack-priv int	endInnerRange
pack-priv HsqlArrayList<Expression>	exprColumnList
pack-priv Expression[]	exprColumns
private int	groupByColumnCount
public Index	groupIndex
pack-priv GroupSet	groupSet
private int	havingColumnCount
public int	indexLimitData
private int	indexLimitExpressions
private int	indexLimitRowId
public int	indexLimitVisible
public int	indexStartAggregates
private int	indexStartHaving
public int	indexStartOrderBy
public boolean	isAggregated
pack-priv boolean	isDistinctGroups
public boolean	isDistinctSelect
public boolean	isGrouped
public boolean	isGroupingSets
public boolean	isOrderSensitive
private boolean	isSimpleCount
public boolean	isSimpleDistinct
private boolean	isSingleMemoryTable
public boolean	isUniqueResultRows
private RangeGroup[]	outerRanges
pack-priv Expression	queryCondition
private HsqlArrayList<RangeVariable>	rangeVariableList
pack-priv RangeVariable[]	rangeVariables
private ArrayListIdentity<Expression>	resolvedSubqueryExpressions
pack-priv Type[]	resultColumnTypes
public int	resultRangePosition
pack-priv int	startInnerRange
private OrderedHashSet<Expression>	tempSet

Constructor Summary

Access	Constructor and Description
pack-priv	QuerySpecification(Session session, Table table, ParserDQL.CompileContext compileContext, boolean isValueList)
pack-priv	QuerySpecification(ParserDQL.CompileContext compileContext)

Method Summary

Modifier and Type	Method and Description
private void	addAggregateToList(Expression parent, Expression e)
private void	addAllJoinedColumns(Expression e)
public void	addExtraConditions(Expression e) Overrides org.hsqldb.QueryExpression.addExtraConditions.
pack-priv void	addGroupingExpressions(Expression[] nodes, OrderedHashSet<Expression> set) collect all expressions in an extended group by expression set the flags for grouping set and group by
pack-priv void	addGroupingSets(Expression[] groupingExpressions)
pack-priv void	addHavingExpression(Expression e)
pack-priv void	addQueryCondition(Expression e)
pack-priv void	addRangeVariable(Session session, RangeVariable rangeVar)
pack-priv void	addSelectColumnExpression(Expression e)
pack-priv void	addSortAndSlice(SortAndSlice sortAndSlice) Overrides org.hsqldb.QueryExpression.addSortAndSlice.
public boolean	areColumnsResolved() Overrides org.hsqldb.QueryExpression.areColumnsResolved.
private Result	buildResult(Session session, RowSetNavigatorData navigator, int skipCount, int limitCount)
pack-priv void	checkLobUsage()
public OrderedHashSet<Expression>	collectAllExpressions(OrderedHashSet<Expression> set, OrderedIntHashSet typeSet, OrderedIntHashSet stopAtTypeSet) Overrides org.hsqldb.QueryExpression.collectAllExpressions.
public void	collectObjectNames(Set<HsqlNameManager.HsqlName> set) Overrides org.hsqldb.QueryExpression.collectObjectNames.
public OrderedHashSet<Expression>	collectOuterColumnExpressions(OrderedHashSet<Expression> set, OrderedHashSet<Expression> exclude)
pack-priv OrderedHashSet<RangeVariable>	collectRangeVariables(RangeVariable[] rangeVars, OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.QueryExpression.collectRangeVariables.
pack-priv OrderedHashSet<RangeVariable>	collectRangeVariables(OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.QueryExpression.collectRangeVariables.
private HashSet<HsqlNameManager.HsqlName>	collectReferencesInSubQueries(Expression expression)
private void	createFullIndex(Session session)
private void	createResultMetaData(Session session)
pack-priv void	createResultTable(Session session) Overrides org.hsqldb.QueryExpression.createResultTable.
pack-priv void	createTable(Session session) Overrides org.hsqldb.QueryExpression.createTable.
public String	describe(Session session, int blanks) Overrides org.hsqldb.QueryExpression.describe.
private void	finaliseColumns()
private HashSet<String>	getAllNamedJoinColumns()
public Table	getBaseTable() Overrides org.hsqldb.QueryExpression.getBaseTable.
public int[]	getBaseTableColumnMap() Overrides org.hsqldb.QueryExpression.getBaseTableColumnMap.
pack-priv void	getBaseTableNames(OrderedHashSet<HsqlNameManager.HsqlName> set) Overrides org.hsqldb.QueryExpression.getBaseTableNames.
public Expression	getCheckCondition() Overrides org.hsqldb.QueryExpression.getCheckCondition.
public int	getColumnCount() Overrides org.hsqldb.QueryExpression.getColumnCount.
public String[]	getColumnNames() Overrides org.hsqldb.QueryExpression.getColumnNames.
public Type[]	getColumnTypes() Overrides org.hsqldb.QueryExpression.getColumnTypes.
public int	getCurrentRangeVariableCount()
public Expression	getEquiJoinExpressions(OrderedHashSet<String> nameSet, RangeVariable rightRange, boolean fullList)
public ResultMetaData	getMetaData() Overrides org.hsqldb.QueryExpression.getMetaData.
public RangeVariable[]	getRangeVariables() Overrides org.hsqldb.QueryExpression.getRangeVariables. Implements org.hsqldb.RangeGroup.getRangeVariables.
pack-priv Result	Returns: the result of executing this Select getResult(Session session, int may be 0 to indicate no limit on the number of rows. Positive values limit the size of the result set. maxRows) Overrides org.hsqldb.QueryExpression.getResult. Returns the result of executing this Select.
private void	getSimpleCountResult(Session session, RowSetNavigatorData navigator)
public String	getSQL()
public OrderedHashSet<TableDerived>	getSubqueries() Overrides org.hsqldb.QueryExpression.getSubqueries.
public TableDerived	getValueListTable()
public boolean	hasReference(RangeVariable range) Overrides org.hsqldb.QueryExpression.hasReference.
pack-priv boolean	isEquivalent(QueryExpression other) Overrides org.hsqldb.QueryExpression.isEquivalent. returns true if almost equivalent
public boolean	isSingleColumn() Overrides org.hsqldb.QueryExpression.isSingleColumn.
pack-priv void	mergeQuery(Session session) isBaseMergeable is simply a flag to allow merging the current query isMergeable is a flag to allow this to act as base for a query
private int	replaceColumnIndexInOrderBy(Expression orderBy)
public void	replaceColumnReferences(Session session, RangeVariable range, Expression[] list) Overrides org.hsqldb.QueryExpression.replaceColumnReferences.
public void	replaceExpressions(OrderedHashSet<Expression> expressions, int resultRangePosition) Overrides org.hsqldb.QueryExpression.replaceExpressions. non-working temp code for replacing aggregate functions with simple column
public void	replaceRangeVariables(RangeVariable[] ranges, RangeVariable[] newRanges) Overrides org.hsqldb.QueryExpression.replaceRangeVariables.
private void	resolveAggregates()
private void	resolveColumnReferences(Session session, RangeGroup[] rangeGroups) Resolves all column expressions in the GROUP BY clause and beyond.
private boolean	resolveColumnReferences(Session session, Expression e, int rangeCount, boolean withSequences)
private void	resolveColumnReferencesAndAllocate(Session session, Expression expression, int rangeCount, RangeGroup[] rangeGroups, boolean withSequences)
private void	resolveColumnReferencesForAsterisk()
pack-priv void	resolveColumnReferencesInGroupingSets(Session session, RangeGroup[] rangeGroups) fully resolve all group by columns add each group by expression to exprColumnList
pack-priv void	resolveColumnReferencesInOrderBy(Session session, RangeGroup[] rangeGroups, SortAndSlice sortAndSlice)
public void	resolveExpressionTypes(Session session) Sets the types of all the expressions used in this SELECT list.
pack-priv boolean	resolveForGroupBy(List<Expression> unresolvedSet)
public void	resolveGroupingSets() replace all expressions in select list and having condition with pointers to columns for group by and aggregate expressions
private void	resolveGroups()
private void	resolveRangeVariables(Session session, RangeGroup[] rangeGroups)
public void	resolveReferences(Session session, RangeGroup[] rangeGroups) Overrides org.hsqldb.QueryExpression.resolveReferences.
public void	resolveTypes(Session session) Overrides org.hsqldb.QueryExpression.resolveTypes.
pack-priv void	resolveTypesPartOne(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartOne.
pack-priv void	resolveTypesPartThree(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartThree.
pack-priv void	resolveTypesPartTwo(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartTwo.
pack-priv void	resolveTypesPartTwoRecursive(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartTwoRecursive. additional resolution for union
private void	setAggregateConditions(Session session)
pack-priv void	setColumnAliases(HsqlNameManager.SimpleName[] names)
private void	setColumnIndexes()
private void	setDistinctConditions(Session session)
pack-priv void	setDistinctGroups()
pack-priv void	setDistinctSelect()
private void	setGroupedAggregateConditions(Session session)
pack-priv void	setMergeability()
private void	setRangeVariableConditions(Session session)
pack-priv void	setReferenceableColumns()
private void	setResultColumnTypes()
private void	setResultNullability()
public void	setReturningResult() Overrides org.hsqldb.QueryExpression.setReturningResult. Not for views.
pack-priv void	setReturningResultSet() Overrides org.hsqldb.QueryExpression.setReturningResultSet. Sets the scope to SESSION for the QueryExpression object that creates the table
pack-priv void	setUpdatability(Session session)

Field Detail

aggregateCheck	back to summary
private boolean[] aggregateCheck

aggregateList	back to summary
private ArrayListIdentity<Expression> aggregateList

baseTable	back to summary
private Table baseTable

checkQueryCondition	back to summary
pack-priv Expression checkQueryCondition

columnMap	back to summary
pack-priv int[] columnMap

endInnerRange	back to summary
pack-priv int endInnerRange

exprColumnList	back to summary
pack-priv HsqlArrayList<Expression> exprColumnList

exprColumns	back to summary
pack-priv Expression[] exprColumns

groupByColumnCount	back to summary
private int groupByColumnCount

groupIndex	back to summary
public Index groupIndex

groupSet	back to summary
pack-priv GroupSet groupSet

havingColumnCount	back to summary
private int havingColumnCount

indexLimitData	back to summary
public int indexLimitData

indexLimitExpressions	back to summary
private int indexLimitExpressions

indexLimitRowId	back to summary
private int indexLimitRowId

indexLimitVisible	back to summary
public int indexLimitVisible

indexStartAggregates	back to summary
public int indexStartAggregates

indexStartHaving	back to summary
private int indexStartHaving

indexStartOrderBy	back to summary
public int indexStartOrderBy

isAggregated	back to summary
public boolean isAggregated

isDistinctGroups	back to summary
pack-priv boolean isDistinctGroups

isDistinctSelect	back to summary
public boolean isDistinctSelect

isGrouped	back to summary
public boolean isGrouped

isGroupingSets	back to summary
public boolean isGroupingSets

isOrderSensitive	back to summary
public boolean isOrderSensitive

isSimpleCount	back to summary
private boolean isSimpleCount

isSimpleDistinct	back to summary
public boolean isSimpleDistinct

isSingleMemoryTable	back to summary
private boolean isSingleMemoryTable

isUniqueResultRows	back to summary
public boolean isUniqueResultRows

outerRanges	back to summary
private RangeGroup[] outerRanges

queryCondition	back to summary
pack-priv Expression queryCondition

rangeVariableList	back to summary
private HsqlArrayList<RangeVariable> rangeVariableList

rangeVariables	back to summary
pack-priv RangeVariable[] rangeVariables

resolvedSubqueryExpressions	back to summary
private ArrayListIdentity<Expression> resolvedSubqueryExpressions

resultColumnTypes	back to summary
pack-priv Type[] resultColumnTypes

resultRangePosition	back to summary
public int resultRangePosition

startInnerRange	back to summary
pack-priv int startInnerRange

tempSet	back to summary
private OrderedHashSet<Expression> tempSet

Constructor Detail

QuerySpecification	back to summary
pack-priv QuerySpecification(Session session, Table table, ParserDQL.CompileContext compileContext, boolean isValueList)

QuerySpecification	back to summary
pack-priv QuerySpecification(ParserDQL.CompileContext compileContext)

Method Detail

addAggregateToList	back to summary
private void addAggregateToList(Expression parent, Expression e)

addAllJoinedColumns	back to summary
private void addAllJoinedColumns(Expression e)

addExtraConditions	back to summary
public void addExtraConditions(Expression e) Overrides org.hsqldb.QueryExpression.addExtraConditions.

addGroupingExpressions	back to summary
pack-priv void addGroupingExpressions(Expression[] nodes, OrderedHashSet<Expression> set) collect all expressions in an extended group by expression set the flags for grouping set and group by

addGroupingSets	back to summary
pack-priv void addGroupingSets(Expression[] groupingExpressions)

addHavingExpression	back to summary
pack-priv void addHavingExpression(Expression e)

addQueryCondition	back to summary
pack-priv void addQueryCondition(Expression e)

addRangeVariable	back to summary
pack-priv void addRangeVariable(Session session, RangeVariable rangeVar)

addSelectColumnExpression	back to summary
pack-priv void addSelectColumnExpression(Expression e)

addSortAndSlice	back to summary
pack-priv void addSortAndSlice(SortAndSlice sortAndSlice) Overrides org.hsqldb.QueryExpression.addSortAndSlice.

areColumnsResolved	back to summary
public boolean areColumnsResolved() Overrides org.hsqldb.QueryExpression.areColumnsResolved.

buildResult	back to summary
private Result buildResult(Session session, RowSetNavigatorData navigator, int skipCount, int limitCount)

checkLobUsage	back to summary
pack-priv void checkLobUsage()

collectAllExpressions	back to summary
public OrderedHashSet<Expression> collectAllExpressions(OrderedHashSet<Expression> set, OrderedIntHashSet typeSet, OrderedIntHashSet stopAtTypeSet) Overrides org.hsqldb.QueryExpression.collectAllExpressions.

collectObjectNames	back to summary
public void collectObjectNames(Set<HsqlNameManager.HsqlName> set) Overrides org.hsqldb.QueryExpression.collectObjectNames.

collectOuterColumnExpressions	back to summary
public OrderedHashSet<Expression> collectOuterColumnExpressions(OrderedHashSet<Expression> set, OrderedHashSet<Expression> exclude)

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

collectRangeVariables	back to summary
pack-priv OrderedHashSet<RangeVariable> collectRangeVariables(OrderedHashSet<RangeVariable> set) Overrides org.hsqldb.QueryExpression.collectRangeVariables.

collectReferencesInSubQueries	back to summary
private HashSet<HsqlNameManager.HsqlName> collectReferencesInSubQueries(Expression expression)

createFullIndex	back to summary
private void createFullIndex(Session session)

createResultMetaData	back to summary
private void createResultMetaData(Session session)

createResultTable	back to summary
pack-priv void createResultTable(Session session) Overrides org.hsqldb.QueryExpression.createResultTable.

createTable	back to summary
pack-priv void createTable(Session session) Overrides org.hsqldb.QueryExpression.createTable.

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

finaliseColumns	back to summary
private void finaliseColumns()

getAllNamedJoinColumns	back to summary
private HashSet<String> getAllNamedJoinColumns()

getBaseTable	back to summary
public Table getBaseTable() Overrides org.hsqldb.QueryExpression.getBaseTable.

getBaseTableColumnMap	back to summary
public int[] getBaseTableColumnMap() Overrides org.hsqldb.QueryExpression.getBaseTableColumnMap.

getBaseTableNames	back to summary
pack-priv void getBaseTableNames(OrderedHashSet<HsqlNameManager.HsqlName> set) Overrides org.hsqldb.QueryExpression.getBaseTableNames.

getCheckCondition	back to summary
public Expression getCheckCondition() Overrides org.hsqldb.QueryExpression.getCheckCondition.

getColumnCount	back to summary
public int getColumnCount() Overrides org.hsqldb.QueryExpression.getColumnCount.

getColumnNames	back to summary
public String[] getColumnNames() Overrides org.hsqldb.QueryExpression.getColumnNames.

getColumnTypes	back to summary
public Type[] getColumnTypes() Overrides org.hsqldb.QueryExpression.getColumnTypes.

getCurrentRangeVariableCount	back to summary
public int getCurrentRangeVariableCount()

getEquiJoinExpressions	back to summary
public Expression getEquiJoinExpressions(OrderedHashSet<String> nameSet, RangeVariable rightRange, boolean fullList)

getMetaData	back to summary
public ResultMetaData getMetaData() Overrides org.hsqldb.QueryExpression.getMetaData.

getRangeVariables

back to summary

public RangeVariable[] getRangeVariables()

Overrides org.hsqldb.QueryExpression.getRangeVariables.

Implements org.hsqldb.RangeGroup.getRangeVariables.

getResult

back to summary

pack-priv Result getResult(Session session, int maxRows)

Overrides org.hsqldb.QueryExpression.getResult.

Returns the result of executing this Select.

Parameters

maxRows:int: may be 0 to indicate no limit on the number of rows. Positive values limit the size of the result set.

Returns:Result

the result of executing this Select

getSimpleCountResult	back to summary
private void getSimpleCountResult(Session session, RowSetNavigatorData navigator)

getSQL	back to summary
public String getSQL()

getSubqueries	back to summary
public OrderedHashSet<TableDerived> getSubqueries() Overrides org.hsqldb.QueryExpression.getSubqueries.

getValueListTable	back to summary
public TableDerived getValueListTable()

hasReference	back to summary
public boolean hasReference(RangeVariable range) Overrides org.hsqldb.QueryExpression.hasReference.

isEquivalent

back to summary

pack-priv boolean isEquivalent(QueryExpression other)

Overrides org.hsqldb.QueryExpression.isEquivalent.

returns true if almost equivalent

isSingleColumn	back to summary
public boolean isSingleColumn() Overrides org.hsqldb.QueryExpression.isSingleColumn.

mergeQuery	back to summary
pack-priv void mergeQuery(Session session) isBaseMergeable is simply a flag to allow merging the current query isMergeable is a flag to allow this to act as base for a query

replaceColumnIndexInOrderBy	back to summary
private int replaceColumnIndexInOrderBy(Expression orderBy)

replaceColumnReferences	back to summary
public void replaceColumnReferences(Session session, RangeVariable range, Expression[] list) Overrides org.hsqldb.QueryExpression.replaceColumnReferences.

replaceExpressions

back to summary

public void replaceExpressions(OrderedHashSet<Expression> expressions, int resultRangePosition)

Overrides org.hsqldb.QueryExpression.replaceExpressions.

Doc from org.hsqldb.QueryExpression.replaceExpressions.

non-working temp code for replacing aggregate functions with simple column

replaceRangeVariables	back to summary
public void replaceRangeVariables(RangeVariable[] ranges, RangeVariable[] newRanges) Overrides org.hsqldb.QueryExpression.replaceRangeVariables.

resolveAggregates	back to summary
private void resolveAggregates()

resolveColumnReferences	back to summary
private void resolveColumnReferences(Session session, RangeGroup[] rangeGroups) Resolves all column expressions in the GROUP BY clause and beyond. Replaces any alias column expression in the ORDER BY clause with the actual select column expression.

resolveColumnReferences	back to summary
private boolean resolveColumnReferences(Session session, Expression e, int rangeCount, boolean withSequences)

resolveColumnReferencesAndAllocate	back to summary
private void resolveColumnReferencesAndAllocate(Session session, Expression expression, int rangeCount, RangeGroup[] rangeGroups, boolean withSequences)

resolveColumnReferencesForAsterisk	back to summary
private void resolveColumnReferencesForAsterisk()

resolveColumnReferencesInGroupingSets	back to summary
pack-priv void resolveColumnReferencesInGroupingSets(Session session, RangeGroup[] rangeGroups) fully resolve all group by columns add each group by expression to exprColumnList

resolveColumnReferencesInOrderBy	back to summary
pack-priv void resolveColumnReferencesInOrderBy(Session session, RangeGroup[] rangeGroups, SortAndSlice sortAndSlice)

resolveExpressionTypes	back to summary
public void resolveExpressionTypes(Session session) Sets the types of all the expressions used in this SELECT list.

resolveForGroupBy	back to summary
pack-priv boolean resolveForGroupBy(List<Expression> unresolvedSet)

resolveGroupingSets	back to summary
public void resolveGroupingSets() replace all expressions in select list and having condition with pointers to columns for group by and aggregate expressions

resolveGroups	back to summary
private void resolveGroups()

resolveRangeVariables	back to summary
private void resolveRangeVariables(Session session, RangeGroup[] rangeGroups)

resolveReferences	back to summary
public void resolveReferences(Session session, RangeGroup[] rangeGroups) Overrides org.hsqldb.QueryExpression.resolveReferences.

resolveTypes	back to summary
public void resolveTypes(Session session) Overrides org.hsqldb.QueryExpression.resolveTypes.

resolveTypesPartOne	back to summary
pack-priv void resolveTypesPartOne(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartOne.

resolveTypesPartThree	back to summary
pack-priv void resolveTypesPartThree(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartThree.

resolveTypesPartTwo	back to summary
pack-priv void resolveTypesPartTwo(Session session) Overrides org.hsqldb.QueryExpression.resolveTypesPartTwo.

resolveTypesPartTwoRecursive

back to summary

pack-priv void resolveTypesPartTwoRecursive(Session session)

Overrides org.hsqldb.QueryExpression.resolveTypesPartTwoRecursive.

additional resolution for union

setAggregateConditions	back to summary
private void setAggregateConditions(Session session)

setColumnAliases	back to summary
pack-priv void setColumnAliases(HsqlNameManager.SimpleName[] names)

setColumnIndexes	back to summary
private void setColumnIndexes()

setDistinctConditions	back to summary
private void setDistinctConditions(Session session)

setDistinctGroups	back to summary
pack-priv void setDistinctGroups()

setDistinctSelect	back to summary
pack-priv void setDistinctSelect()

setGroupedAggregateConditions	back to summary
private void setGroupedAggregateConditions(Session session)

setMergeability	back to summary
pack-priv void setMergeability()

setRangeVariableConditions	back to summary
private void setRangeVariableConditions(Session session)

setReferenceableColumns	back to summary
pack-priv void setReferenceableColumns()

setResultColumnTypes	back to summary
private void setResultColumnTypes()

setResultNullability	back to summary
private void setResultNullability()

setReturningResult

back to summary

public void setReturningResult()

Overrides org.hsqldb.QueryExpression.setReturningResult.

Not for views. Only used on root node.

setReturningResultSet

back to summary

pack-priv void setReturningResultSet()

Overrides org.hsqldb.QueryExpression.setReturningResultSet.

Doc from org.hsqldb.QueryExpression.setReturningResultSet.

Sets the scope to SESSION for the QueryExpression object that creates the table

setUpdatability	back to summary
pack-priv void setUpdatability(Session session)

public Class QuerySpecification

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail