Top Description Inners Fields Constructors Methods
org.hsqldb

public Class ParserDQL

extends ParserBase
Class Inheritance
Known Direct Subclasses
org.hsqldb.ParserDML
Imports
org.hsqldb.HsqlNameManager.HsqlName, .HsqlNameManager.SimpleName, .QueryExpression.RecursiveQuerySettings, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.ArrayUtil, .HsqlArrayList, .Iterator, .List, .LongDeque, .OrderedHashMap, .OrderedHashSet, .OrderedIntKeyHashMap, org.hsqldb.map.BitMap, .ValuePool, org.hsqldb.result.ResultConstants, .ResultProperties, org.hsqldb.types.ArrayType, .BinaryType, .BlobType, .CharacterType, .Charset, .ClobType, .Collation, .DTIType, .IntervalType, .NumberType, .Type, .Types, .UserTypeModifier
Parser for DQL statements
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.7.4

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static class
ParserDQL.CompileContext

Field Summary

Modifier and TypeField and Description
protected final ParserDQL.CompileContext
compileContext

protected Database
database

protected Session
session

Inherited from org.hsqldb.ParserBase:
isRecordingisSchemaDefinitionisViewDefinitionlastErrorlastSynonymLONG_MAX_VALUE_INCREMENTpartPositionrecordedStatementscannertoken

Constructor Summary

AccessConstructor and Description
pack-priv
ParserDQL(Session
the connected context
session, Scanner
the token source from which to parse commands
scanner, ParserDQL.CompileContext baseContext)

Constructs a new Parser object with the given context.

Method Summary

Modifier and TypeMethod and Description
private void
checkIfGroupingOrAggregate(Expression e)

pack-priv void
checkIsSchemaObjectName()

pack-priv void
checkValidCatalogName(String name)

pack-priv StatementQuery
compileCursorSpecification(RangeGroup[] rangeGroups, int props, boolean isRoutine)

Retrieves a SELECT or other query expression Statement from this parse context.

pack-priv StatementQuery
compileDeclareCursorOrNull(RangeGroup[] rangeGroups, boolean isRoutine)

pack-priv StatementDMQL
compileShortCursorSpecification(int props)

pack-priv Expression
getRowExpression(OrderedHashSet<String> columnNames)

pack-priv TableDerived
newSubQueryTable(Expression e, int opType)

pack-priv TableDerived
newSubQueryTable(QueryExpression qe, int opType)

pack-priv TableDerived
newSubQueryTable(HsqlNameManager.HsqlName name, QueryExpression qe, int opType)

private TableDerived
prepareSubqueryTable(Expression e, HsqlNameManager.HsqlName[] colNames)

private Expression
readAggregateExpression(int tokenType)

private Expression
readAggregateFunctionOrNull()

pack-priv Expression
readCaseExpression()

private Expression
readCaseWhen(final Expression l)

Reads part of a CASE ...

private Expression
readCaseWhenExpressionOrNull()

reads a CASEWHEN expression

private Expression
readCastExpression()

Reads a CAST expression

pack-priv int
readCloseBrackets(int limit)

private Expression
readCoalesceExpression()

Reads a COALESE expression

pack-priv Collation
readCollateClauseOrNull()

pack-priv Expression
readCollection(int type)

pack-priv int[]

Returns:

array of column indexes
readColumnList(Table
table that contains the columns
table, boolean
boolean
ascOrDesc)

Process a bracketed column list as used in the declaration of SQL CONSTRAINTS and return an array containing the indexes of the columns within the table.

pack-priv void
readColumnNameList(OrderedHashSet<String> set, BitMap quotedFlags, boolean readAscDesc)

pack-priv HsqlNameManager.SimpleName[]
readColumnNameList(OrderedHashSet<String> set)

pack-priv HsqlNameManager.HsqlName[]
readColumnNames(HsqlNameManager.HsqlName tableName)

pack-priv OrderedHashSet<String>
readColumnNames(boolean readAscDesc)

pack-priv OrderedHashSet<String>
readColumnNames(BitMap quotedFlags, boolean readAscDesc)

private Expression
readColumnOrFunctionExpression()

reads a Column or Function expression

private Expression
readConcatExpressionOrNull()

private Expression
readConcatSeparatorExpressionOrNull()

private Expression
readConvertExpressionOrNull()

private Expression
readDecodeExpressionOrNull()

pack-priv void
readExpression(HsqlArrayList<Expression> exprList, short[] parseList, int start, int count, boolean isOption)

private void
readFilterClause(Expression e)

pack-priv Expression
readFunction()

private Expression
readGreatestExpressionOrNull()

private Expression
readIfNull2ExpressionOrNull()

Reads a NVL2 expression

private Expression
readIfNullExpressionOrNull()

Reads a ISNULL or ISNULL of NVL expression

pack-priv Expression
readJSONArray()

pack-priv Expression
readJSONArrayAgg()

pack-priv boolean
readJSONNullClause(boolean defaultValue)

pack-priv Expression
readJSONObject()

pack-priv Expression
readJSONObjectAgg()

pack-priv Type
readJSONReturningClause()

pack-priv boolean
readJSONUniqueClause(boolean defaultValue)

private Expression
readLeastExpressionOrNull()

private Expression
readListAggFunctionOrNull()

pack-priv Type
readMysEnum()

protected Table
readNamedSubqueryOrNull()

pack-priv void
readNestedParenthesisedTokens()

pack-priv HsqlNameManager.HsqlName
readNewDependentSchemaObjectName(HsqlNameManager.HsqlName parentName, int type)

pack-priv HsqlNameManager.HsqlName
readNewSchemaName()

pack-priv HsqlNameManager.HsqlName
readNewSchemaObjectName(int type, boolean checkSchema)

pack-priv Expression
readNextvalFunction()

private Expression
readNullIfExpression()

Reads a NULLIF expression

pack-priv int
readOpenBrackets()

protected RangeVariable
readRangeVariableForDataChange(int operation)

pack-priv Expression
readRow()

pack-priv HsqlNameManager.HsqlName
readSchemaName()

pack-priv SchemaObject
readSchemaObjectName(int type)

pack-priv SchemaObject
readSchemaObjectName(HsqlNameManager.HsqlName schemaName, int type)

private Expression
readSequenceExpressionOrNull(int opType)

pack-priv ColumnSchema
readSimpleColumnName(RangeVariable rangeVar, boolean withPrefix)

pack-priv ColumnSchema
readSimpleColumnName(Table table, boolean withPrefix)

pack-priv void
readSimpleColumnNames(OrderedHashSet<String> columns, RangeVariable rangeVar, boolean withPrefix)

pack-priv void
readSimpleColumnNames(OrderedHashSet<String> columns, Table table, boolean withPrefix)

pack-priv HsqlNameManager.SimpleName
readSimpleName()

pack-priv Expression
readSQLFunction(FunctionSQL function)

private Expression
readStringAggFunctionOrNull()

pack-priv Table
readTableName()

pack-priv Table
readTableName(boolean orSynonym)

protected RangeVariable
readTableOrSubquery()

Creates a RangeVariable from the parse context.

pack-priv void
readTargetSpecificationList(OrderedHashSet<Expression> targets, RangeVariable[] rangeVars, LongDeque colIndexList)

pack-priv Type
readTypeDefinition(boolean allowCollation, boolean includeUserTypes)

private Expression
readValue(Expression e, int opType)

pack-priv void
readWhereGroupHaving(QuerySpecification select)

pack-priv void
reset(Session session, String
a new SQL character sequence to replace the current one
sql)

Overrides org.hsqldb.ParserBase.reset.

Resets this parse context with the given SQL character sequence.

pack-priv void
rewind(int position)

Overrides org.hsqldb.ParserBase.rewind.

pack-priv Expression
XreadAllTypesCommonValueExpression(boolean boole)

pack-priv Expression
XreadAllTypesFactor(boolean boole)

pack-priv Expression
XreadAllTypesPrimary(boolean boole)

pack-priv Expression
XreadAllTypesTerm(boolean boole)

pack-priv Expression
XreadAllTypesValueExpressionPrimary(boolean isBoolean)

pack-priv Expression
XreadArrayConstructor()

pack-priv Expression
XreadArrayElementReference(Expression e)

private ExpressionLogical
XreadBetweenPredicateRightPart(final Expression a)

pack-priv Expression
XreadBooleanFactorOrNull()

pack-priv Expression
XreadBooleanPredicand()

pack-priv Expression
XreadBooleanPrimaryOrNull()

pack-priv Expression
XreadBooleanTermOrNull()

pack-priv Expression
XreadBooleanTestOrNull()

pack-priv Expression
XreadBooleanValueExpression()

pack-priv Expression
XreadCharacterPrimary()

pack-priv Expression
XreadCharacterValueExpression()

pack-priv Expression
XreadCollectionDerivedTable(int type)

pack-priv Expression
XreadContextuallyTypedTable(int degree)

pack-priv Expression
XreadCurrentCollationSpec()

pack-priv Expression
XreadDateTimeIntervalTerm()

pack-priv Expression
XreadDatetimeValueExpression()

pack-priv Expression
XreadDateTimeValueFunctionOrNull()

pack-priv Expression
XreadDynamicParameterOrNull()

pack-priv Expression
XreadExplicitRowValueConstructorOrNull()

pack-priv Expression
XreadFactor()

pack-priv Expression
XreadFilterExpressionOrNull()

pack-priv void
XreadFromClause(QuerySpecification select)

pack-priv Expression
XreadGroupByExpression()

pack-priv Expression
XreadGroupByExpressionPrimary()

private ExpressionLogical
XreadInPredicateRightPart(Expression l)

pack-priv Expression
XreadIntervalValueExpression()

pack-priv Expression
XreadInValueList(int degree)

pack-priv Expression
XreadInValueListConstructor(int degree)

pack-priv TableDerived
XreadJoinedTableAsSubqueryOrNull()

pack-priv QuerySpecification
XreadJoinedTableAsView()

pack-priv Expression
XreadLateralDerivedTable()

private ExpressionLogical
XreadLikePredicateRightPart(Expression a)

private void
XreadLimit(SortAndSlice sortAndSlice)

private ExpressionLogical
XreadMatchPredicateRightPart(Expression a)

pack-priv Expression
XreadModifier(Expression e)

pack-priv Expression
XreadNumericPrimary()

pack-priv Expression
XreadNumericValueExpression()

private SortAndSlice
XreadOrderBy()

pack-priv SortAndSlice
XreadOrderByExpression()

private ExpressionLogical
XreadPeriodPredicateRightPart(int opType, Expression left)

OVERLAPS does not require PERIOD, others do.

pack-priv Expression
XreadPredicate()

pack-priv Expression
XreadPredicateRightPart(final Expression l)

private ExpressionLogical
XreadQuantifiedComparisonRightPart(int exprType, Expression l)

pack-priv ExpressionPeriodOp
XreadQueryApplicationPeriodSpecOrNull(Table table)

pack-priv QueryExpression
XreadQueryExpression()

pack-priv QueryExpression
XreadQueryExpressionBody()

pack-priv QueryExpression
XreadQueryPrimary()

pack-priv QuerySpecification
XreadQuerySpecification()

pack-priv ExpressionPeriodOp
XreadQuerySystemPeriodSpecOrNull(Table table)

Returns a period condition (including a default) for all tables with a system period, otherwise null;

pack-priv QueryExpression
XreadQueryTerm()

pack-priv void
XreadRecursiveFeatures(TableDerived table)

pack-priv TableDerived
XreadRecursiveSubqueryBody(HsqlNameManager.HsqlName name, HsqlNameManager.HsqlName[] columnNames)

pack-priv Expression
XreadRowElementList(boolean multiple)

pack-priv Expression
XreadRowOrCommonValueExpression()

pack-priv Expression
XreadRowValueConstructor()

pack-priv Expression
XreadRowValueExpression()

private TableDerived
XreadRowValueExpressionList()

pack-priv Expression
XreadRowValueExpressionListBody()

pack-priv Expression
XreadRowValuePredicand()

pack-priv Expression
XreadRowValueSpecialCase()

pack-priv QuerySpecification
XreadSelect()

private QueryExpression
XreadSetOperation(QueryExpression queryExpression)

pack-priv QuerySpecification
XreadSimpleTable()

pack-priv Expression
XreadSimpleValueExpressionPrimary()

pack-priv Expression
XreadSimpleValueSpecificationOrNull()

pack-priv Expression
XreadStringValueExpression()

pack-priv TableDerived
XreadSubqueryTableBody(int type)

pack-priv TableDerived
XreadSubqueryTableBody(HsqlNameManager.HsqlName name, int type)

pack-priv void
XreadTableExpression(QuerySpecification select)

pack-priv Expression
XreadTableFunctionDerivedTable()

pack-priv TableDerived
XreadTableNamedSubqueryBody(HsqlNameManager.HsqlName name, HsqlNameManager.HsqlName[] columnNames)

pack-priv void
XreadTableReference(QuerySpecification select)

pack-priv Expression
XreadTableRowValueConstructor()

pack-priv Expression
XreadTableSubquery(int mode)

pack-priv Table
XreadTableSubqueryOrNull(boolean parens)

pack-priv Expression
XreadTargetSpecification(RangeVariable[] rangeVars, LongDeque colIndexList)

pack-priv Expression
XreadTerm()

private SortAndSlice
XreadTopOrLimit()

pack-priv void
XreadUnionCorrespondingClause(QueryExpression queryExpression)

pack-priv int
XreadUnionType()

pack-priv Expression
XreadUnsignedValueSpecificationOrNull()

pack-priv Expression
XreadValueExpression()

value expression ::= common value expression | boolean value expression | row value expression

pack-priv Expression
XreadValueExpressionOnDuplicate()

pack-priv Expression
XreadValueExpressionPrimary()

pack-priv Expression
XreadValueExpressionWithContext()

pack-priv Expression
XreadValueSpecificationOrNull()

pack-priv TableDerived
XreadViewSubqueryTable(View view, boolean resolve)

pack-priv void
XreadWithClause()

private SortAndSlice
XreadWithinGroup()

Inherited from org.hsqldb.ParserBase:
checkIsAnycheckIsDelimitedIdentifiercheckIsIdentifiercheckIsIntegralcheckIsIrregularCharInIdentifiercheckIsNonCoreReservedIdentifiercheckIsNonReservedIdentifiercheckIsQuotedStringcheckIsSimpleNamecheckIsThischeckIsUndelimitedIdentifiercheckIsValueconvertToNumbergetExpressionTypegetLastPartgetLastPartgetPartPositiongetPositiongetRecordedTokengetScannergetStatementgetStatementForRoutineisCoreReservedKeyisDelimitedIdentifierisDelimitedSimpleNameisIdentifierisIntegralisNonCoreReservedIdentifierisNonReservedIdentifierisQuotedStringisReservedKeyisSimpleNameisUndelimitedSimpleNamereadreadAnyreadBigintreadDateTimeIntervalLiteralreadIfThisreadIfThisreadIntegerreadIntegerObjectreadIntervalTypereadPropertyValuePairsreadQuotedStringreadThisreadThisreadUnquotedIdentifierreplaceTokenreplaceTokensetPartPositionstartRecordingtooManyIdentifiersunexpectedTokenunexpectedTokenunexpectedTokenunexpectedTokenRequireunsupportedFeatureunsupportedFeature