org.hsqldb

Class QuerySpecification

java.lang.Object

org.hsqldb.QueryExpression

org.hsqldb.QuerySpecification

All Implemented Interfaces:

RangeGroup

public class QuerySpecification
extends QueryExpression

Implementation of an SQL query specification, including SELECT.

Since:

1.9.0

Nested Class Summary

Nested classes/interfaces inherited from interface org.hsqldb.RangeGroup

RangeGroup.RangeGroupEmpty, RangeGroup.RangeGroupSimple

Field Summary

Fields

Modifier and Type	Field and Description
Index	groupIndex
int	indexLimitData
int	indexLimitVisible
int	indexStartAggregates
int	indexStartOrderBy
boolean	isAggregated
boolean	isDistinctSelect
boolean	isGrouped
boolean	isOrderSensitive
boolean	isSimpleDistinct
boolean	isUniqueResultRows
int	resultRangePosition

Fields inherited from class org.hsqldb.QueryExpression

EXCEPT, EXCEPT_ALL, fullIndex, idIndex, INTERSECT, INTERSECT_ALL, mainIndex, NOUNION, orderIndex, resultTable, UNION, UNION_ALL, UNION_TERM

Fields inherited from interface org.hsqldb.RangeGroup

emptyArray, emptyGroup

Method Summary

Modifier and Type	Method and Description
void	addExtraConditions(Expression e)
boolean	areColumnsResolved()
OrderedHashSet	collectAllExpressions(OrderedHashSet set, OrderedIntHashSet typeSet, OrderedIntHashSet stopAtTypeSet)
OrderedHashSet	collectAllSubqueries(OrderedHashSet set)
void	collectObjectNames(Set set)
OrderedHashSet	collectOuterColumnExpressions(OrderedHashSet set, OrderedHashSet exclude)
java.lang.String	describe(Session session, int blanks)
Table	getBaseTable()
int[]	getBaseTableColumnMap()
Expression	getCheckCondition()
int	getColumnCount()
java.lang.String[]	getColumnNames()
Type[]	getColumnTypes()
Expression	getEquiJoinExpressions(OrderedHashSet nameSet, RangeVariable rightRange, boolean fullList)
ResultMetaData	getMetaData()
RangeVariable[]	getRangeVariables()
java.lang.String	getSQL()
OrderedHashSet	getSubqueries()
TableDerived	getValueListTable()
boolean	hasReference(RangeVariable range)
boolean	isSingleColumn()
void	replaceColumnReferences(RangeVariable range, Expression[] list)
void	replaceRangeVariables(RangeVariable[] ranges, RangeVariable[] newRanges)
void	resolveExpressionTypes(Session session) Sets the types of all the expressions used in this SELECT list.
void	resolveReferences(Session session, RangeGroup[] rangeGroups)
void	resolveTypes(Session session)
void	setReturningResult() Not for views.

Methods inherited from class org.hsqldb.QueryExpression

getColumns, getMainSelect, getResultColumnNames, getResultTable, getSingleRowValues, getUnresolvedExpressions, getValue, getValues, isInsertable, isRecursive, isUpdatable, isVariable, resolve, resolve, setColumnsDefined, setCorrelated, setFullOrder, setSingleRow, setTableColumnNames, setUnionCorresoponding, setUnionCorrespondingColumns, setView

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

resultRangePosition

public int resultRangePosition

isDistinctSelect

public boolean isDistinctSelect

isAggregated

public boolean isAggregated

isGrouped

public boolean isGrouped

isOrderSensitive

public boolean isOrderSensitive

isSimpleDistinct

public boolean isSimpleDistinct

indexLimitVisible

public int indexLimitVisible

indexStartOrderBy

public int indexStartOrderBy

indexStartAggregates

public int indexStartAggregates

indexLimitData

public int indexLimitData

isUniqueResultRows

public boolean isUniqueResultRows

groupIndex

public Index groupIndex

Method Detail

getValueListTable

public TableDerived getValueListTable()

getRangeVariables

public RangeVariable[] getRangeVariables()

Specified by:

getRangeVariables in interface RangeGroup

Overrides:

getRangeVariables in class QueryExpression

resolveReferences

public void resolveReferences(Session session,
                              RangeGroup[] rangeGroups)

Overrides:

resolveReferences in class QueryExpression

hasReference

public boolean hasReference(RangeVariable range)

Overrides:

hasReference in class QueryExpression

areColumnsResolved

public boolean areColumnsResolved()

Overrides:

areColumnsResolved in class QueryExpression

resolveTypes

public void resolveTypes(Session session)

Overrides:

resolveTypes in class QueryExpression

addExtraConditions

public void addExtraConditions(Expression e)

Overrides:

addExtraConditions in class QueryExpression

getEquiJoinExpressions

public Expression getEquiJoinExpressions(OrderedHashSet nameSet,
                                         RangeVariable rightRange,
                                         boolean fullList)

resolveExpressionTypes

public void resolveExpressionTypes(Session session)

Sets the types of all the expressions used in this SELECT list.

getSQL

public java.lang.String getSQL()

getMetaData

public ResultMetaData getMetaData()

Overrides:

getMetaData in class QueryExpression

describe

public java.lang.String describe(Session session,
                                 int blanks)

Overrides:

describe in class QueryExpression

getSubqueries

public OrderedHashSet getSubqueries()

Overrides:

getSubqueries in class QueryExpression

getBaseTable

public Table getBaseTable()

Overrides:

getBaseTable in class QueryExpression

collectAllSubqueries

public OrderedHashSet collectAllSubqueries(OrderedHashSet set)

collectOuterColumnExpressions

public OrderedHashSet collectOuterColumnExpressions(OrderedHashSet set,
                                                    OrderedHashSet exclude)

collectAllExpressions

public OrderedHashSet collectAllExpressions(OrderedHashSet set,
                                            OrderedIntHashSet typeSet,
                                            OrderedIntHashSet stopAtTypeSet)

Overrides:

collectAllExpressions in class QueryExpression

collectObjectNames

public void collectObjectNames(Set set)

Overrides:

collectObjectNames in class QueryExpression

replaceColumnReferences

public void replaceColumnReferences(RangeVariable range,
                                    Expression[] list)

Overrides:

replaceColumnReferences in class QueryExpression

replaceRangeVariables

public void replaceRangeVariables(RangeVariable[] ranges,
                                  RangeVariable[] newRanges)

Overrides:

replaceRangeVariables in class QueryExpression

setReturningResult

public void setReturningResult()

Not for views. Only used on root node.

Overrides:

setReturningResult in class QueryExpression

isSingleColumn

public boolean isSingleColumn()

Overrides:

isSingleColumn in class QueryExpression

getColumnNames

public java.lang.String[] getColumnNames()

getColumnTypes

public Type[] getColumnTypes()

Overrides:

getColumnTypes in class QueryExpression

getColumnCount

public int getColumnCount()

Overrides:

getColumnCount in class QueryExpression

getBaseTableColumnMap

public int[] getBaseTableColumnMap()

Overrides:

getBaseTableColumnMap in class QueryExpression

getCheckCondition

public Expression getCheckCondition()

Overrides:

getCheckCondition in class QueryExpression