H2 Database Engine 2.3.232 · org.h2.command.Parser · APIdia, the JavaDoc alternative

Modifier and Type	Class and Description
private static enum	Parser.NullConstraintType Enumeration describing null constraints

Modifier and Type	Field and Description
private CreateView	createView
private Prepared	currentPrepared
private Select	currentSelect
private int	orderInFrom
private boolean	parseDomainConstraint
private boolean	parsingRecursiveWithList
private QueryScope	queryScope
private boolean	recompileAlways
private boolean	rightsChecked
private String	schemaName

Access	Constructor and Description
public	Parser(SessionLocal the session session) Creates a new instance of parser.

Method Summary

Modifier and Type	Method and Description
private void	addJoin(TableFilter parent join top, TableFilter child join join, boolean if child join is an outer join outer, Expression the join condition on) Add one join to another.
private Expression	addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private boolean	Returns: true if we expect to see a TABLE clause addRoleOrRight(GrantRevoke command)
private TableFilter	buildTableFilter(Table table, String alias, ArrayList<String> derivedColumnNames, IndexHints indexHints)
private void	checkDatabaseName(String databaseName)
private void	checkSchema(Schema old)
private Column	columnIfTableExists(Schema schema, String tableName, String columnName, boolean ifTableExists, boolean ifExists)
private Prepared	commandIfTableExists(Schema schema, String tableName, boolean ifTableExists, Prepared commandIfTableExists)
private SimpleCase.SimpleWhen	decodeToWhen(Expression caseOperand, boolean canOptimize, Expression whenOperand, Expression result)
private void	discardTableHint()
private void	discardWithTableHints()
private Schema	findSchema(String schemaName)
private Sequence	findSequence(String schema, String sequenceName)
private void	findTableNameCandidates(String schemaName, String tableName, Set<String> candidates)
private UserDefinedFunction	findUserDefinedFunctionWithinPath(Schema schema, String name)
private Prepared	getAlterTableAlterColumnDropDefaultExpression(Schema schema, String tableName, boolean ifTableExists, Column column, int type)
private static Column	getColumnWithDomain(String columnName, Domain domain)
private static int	getCompareType(int tokenType)
private Prepared	getCurrentPreparedOrSelect()
private FunctionAlias	getFunctionAliasWithinPath(String name, Schema schema)
private static DbException	getInvalidNumericPrecisionException(long precision)
private static DbException	getInvalidPrecisionException(DataType dataType, long precision)
private Schema	getSchema(String schemaName)
private Schema	getSchema()
private Schema	getSchemaWithDefault()
private DbException	getTableOrViewNotFoundDbException(String tableName)
private DbException	getTableOrViewNotFoundDbException(String schemaName, String tableName)
private DbException	getTableOrViewNotFoundDbException(Set<String> schemaNames, String tableName)
private Table	getWithSubquery(String name)
private DbException	intervalDayError()
private DbException	intervalHourError()
private DbException	intervalQualifierError()
private boolean	isDerivedTable()
private boolean	isDirectQuery(int offset)
private boolean	Returns: `true` if the table is DUAL special table. Otherwise returns `false`. isDualTable(String table name. tableName) Is this the Oracle DUAL table or the IBM/DB2 SYSIBM table?
private boolean	Returns: whether current opening parenthesis can be a start of ordinary grouping set isOrdinaryGroupingSet() Checks whether current opening parenthesis can be a start of ordinary grouping set.
private boolean	isQuery()
private boolean	isQueryQuick()
private boolean	isReservedFunctionName(String name)
public static AlterTableAddConstraint	Returns: the command newPrimaryKeyConstraintCommand(SessionLocal the session session, Schema the schema schema, String the table tableName, Column the column column) Create a new alter table command.
pack-priv Prepared	Returns: the prepared object parse(String the SQL statement to parse sql, ArrayList<Token> tokens, or null tokens) Parse the statement, but don't prepare it for execution.
private Prepared	parse(boolean withExpectedList)
private ConstraintActionType	parseAction()
private Prepared	parseAlter()
private void	parseAlterColumnUsingIf(AlterTableAlterColumn command)
private DefineCommand	parseAlterDomain()
private AlterIndexRename	parseAlterIndex()
private Prepared	parseAlterSchema()
private AlterSequence	parseAlterSequence()
private Prepared	parseAlterTable()
private AlterTableAlterColumn	parseAlterTableAddColumn(String tableName, Schema schema, boolean ifTableExists)
private Prepared	parseAlterTableAlter(Schema schema, String tableName, boolean ifTableExists)
private AlterTableAlterColumn	parseAlterTableAlterColumnDataType(Schema schema, String tableName, String columnName, boolean ifTableExists, boolean ifExists)
private Prepared	parseAlterTableAlterColumnIdentity(Schema schema, String tableName, boolean ifTableExists, Column column)
private Prepared	parseAlterTableAlterColumnSet(Schema schema, String tableName, boolean ifTableExists, boolean ifExists, String columnName, Column column)
private AlterTableAlterColumn	parseAlterTableAlterColumnType(Schema schema, String tableName, String columnName, boolean ifTableExists, boolean ifExists, boolean preserveNotNull)
private Prepared	parseAlterTableCompatibility(Schema schema, String tableName, boolean ifTableExists, Mode mode)
private Prepared	parseAlterTableDrop(Schema schema, String tableName, boolean ifTableExists)
private Prepared	parseAlterTableDropCompatibility(Schema schema, String tableName, boolean ifTableExists)
private Prepared	parseAlterTableRename(Schema schema, String tableName, boolean ifTableExists)
private Prepared	parseAlterTableSet(Schema schema, String tableName, boolean ifTableExists)
private AlterUser	parseAlterUser()
private DefineCommand	parseAlterView()
private Prepared	parseAnalyze()
private TypeInfo	parseArrayType(TypeInfo componentType)
private Prepared	parseBackup()
private boolean	parseBasicSequenceOption(SequenceOptions options)
private TransactionCommand	parseBegin()
private Call	parseCall()
private ConstraintActionType	parseCascadeOrRestrict()
private TransactionCommand	parseCheckpoint()
private Column	parseColumn(Table table)
private Column	parseColumnForTable(String columnName, boolean defaultNullable)
private String[]	parseColumnList()
private Column[]	parseColumnList(Table table)
private Column	parseColumnWithType(String columnName)
private Prepared	parseComment()
private TransactionCommand	parseCommit()
private boolean	parseCompatibilityIdentity(Column column, Mode mode)
private void	parseCompatibilityIdentityOptions(Column column)
private Prepared	parseCreate()
private CreateAggregate	parseCreateAggregate(boolean force)
private CreateConstant	parseCreateConstant()
private CreateDomain	parseCreateDomain()
private CreateFunctionAlias	parseCreateFunctionAlias(boolean force)
private CreateLinkedTable	parseCreateLinkedTable(boolean temp, boolean globalTemp, boolean force)
private CreateMaterializedView	parseCreateMaterializedView(boolean force, boolean orReplace)
private CreateRole	parseCreateRole()
private CreateSchema	parseCreateSchema()
private CreateSequence	parseCreateSequence()
private boolean	parseCreateSequenceOption(CreateSequence command)
private CreateSynonym	parseCreateSynonym(boolean orReplace)
private CreateTable	parseCreateTable(boolean temp, boolean globalTemp, boolean persistIndexes)
private void	parseCreateTableMySQLTableOptions(CreateTable command)
private CreateTrigger	parseCreateTrigger(boolean force)
private CreateUser	parseCreateUser()
private CreateView	parseCreateView(boolean force, boolean orReplace)
private TypeInfo	parseDataType()
private TypeInfo	parseDateTimeType(boolean smallDateTime)
private Expression	parseDB2SpecialRegisters(String name)
private DeallocateProcedure	parseDeallocate()
private TypeInfo	parseDecfloatType()
private Delete	parseDelete(int start)
public Expression	Returns: the expression object parseDomainConstraintExpression(String the code snippet sql) Parse a SQL code snippet that represents an expression for a domain constraint.
private Prepared	parseDrop()
private DropAggregate	parseDropAggregate()
private DropDomain	parseDropDomain()
private void	parseEndOfQuery(Query command)
private TypeInfo	parseEnumType()
private Prepared	parseExecutePostgre()
private Prepared	parseExecuteSQLServer()
private Explain	parseExplain()
private Query	parseExplicitTable(int start)
public Expression	Returns: the expression object parseExpression(String the code snippet sql) Parse a SQL code snippet that represents an expression.
private TypeInfo	parseFloatType()
private TypeInfo	parseGeometryType()
private GrantRevoke	parseGrantRevoke(int operationType)
private Prepared	parseHelp()
private IndexColumn[]	parseIndexColumnList()
private IndexHints	parseIndexHints(Table table)
private Insert	parseInsert(int start)
private void	parseInsertCompatibility(Insert command, Table table, Mode mode)
private void	parseInsertSet(Insert command, Table table, Column[] columns)
private void	parseIsolationClause() DB2 isolation clause
private Prepared	parseMerge(int start)
private Prepared	parseMergeInto(TableFilter targetTableFilter, int start)
private MergeUsing	parseMergeUsing(TableFilter targetTableFilter, int start)
private Parser.NullConstraintType	parseNotNullCompatibility(Parser.NullConstraintType nullConstraint)
private Parser.NullConstraintType	parseNotNullConstraint(Parser.NullConstraintType nullConstraint)
private Parser.NullConstraintType	parseNotNullConstraint()
private TypeInfo	parseNumericType(boolean decimal)
private Prepared	parsePrepare()
private Prepared	parsePrepared()
private Prepared	parsePrepareProcedure()
private Query	parseQuery()
private Query	parseQueryExpression()
private Query	parseQueryExpressionBody()
private Query	parseQueryExpressionBodyAndEndOfQuery(int start)
private Query	parseQueryPrimary()
private Query	parseQueryTerm()
private void	parseReferences(AlterTableAddConstraint command, Schema schema, String tableName)
private RefreshMaterializedView	parseRefresh(int start) REFRESH MATERIALIZED VIEW
private Prepared	parseReleaseSavepoint()
private Merge	parseReplace(int start) MySQL compatibility.
private TransactionCommand	parseRollback()
private TypeInfo	parseRowType()
private RunScriptCommand	parseRunScript()
private TransactionCommand	parseSavepoint()
private ScriptCommand	parseScript()
private Select	parseSelect(int start)
private void	parseSelectExpressions(Select command)
private void	parseSelectFromPart(Select command)
private boolean	parseSequenceOptions(SequenceOptions options, CreateSequence command, boolean allowDataType, boolean forAlterColumn)
private Prepared	parseSet()
private Set	parseSetCollation()
private Prepared	parseSetTransactionMode()
private Prepared	parseShow()
private TransactionCommand	parseShutdown()
private void	parseSingleCommonTableExpression(boolean isPotentiallyRecursive)
private QueryOrderBy	parseSortSpecification()
private ArrayList<QueryOrderBy>	parseSortSpecificationList()
private int	parseSortType()
private void	parseTableColumnDefinition(CommandWithColumns command, Schema schema, String tableName, boolean forCreateTable)
private DefineCommand	parseTableConstraintIf(String tableName, Schema schema, boolean ifTableExists)
public Table	Returns: the table object parseTableName(String the code snippet sql) Parse a SQL code snippet that represents a table name.
private TypeInfo	parseTimestampType()
private TypeInfo	parseTimeType()
private Prepared	parseTruncate()
private DataChangeStatement	parseUpdate(int start)
private MergeUsing	parseUpdateFrom(TableFilter targetTableFilter, int start)
private Prepared	parseUse()
private TableValueConstructor	parseValues()
private void	parseValuesForCommand(CommandWithValues command)
private ArrayList<Expression>	parseValuesRow(ArrayList<Expression> row)
private void	parseWhenMatched(MergeUsing command)
private void	parseWhenNotMatched(MergeUsing command)
private Wildcard	parseWildcard(String schema, String objectName)
public Prepared	Returns: the prepared object prepare(String the SQL statement to parse sql) Parse the statement and prepare it for execution.
public Command	Returns: the command object prepareCommand(String the SQL statement to parse sql) Parse a statement or a list of statements, and prepare it for execution.
private CommandList	prepareCommandList(CommandContainer command, Prepared p, String sql, String remainingSql, ArrayList<Token> remainingTokens)
public Query	Returns: the prepared object prepareQueryExpression(String the SQL statement to parse sql) Parse a query and prepare its expressions.
private Expression	readAggregate(AggregateType aggregateType, String aggregateName)
private void	readAggregateOrder(Aggregate r, Expression expr, boolean parseSortType)
private Expression	readAnd(Expression r)
private Expression	readAnyComparison(Expression left, int compareType, boolean whenOperand, int start)
private Expression	readBuiltinFunctionIf(String upperName)
private Expression	readCase()
private Expression	readCoalesceFunction(int function)
private Expression	readColonColonAfterTerm(Expression r)
private void	readColumnConstraints(CommandWithColumns command, Schema schema, String tableName, Column column)
private Expression	readColumnIfNotFunction()
private String	readCommentIf()
private Expression	readComparison(Expression left, int compareType, boolean whenOperand)
private Expression	readCompatibilityCase(Expression when)
private Expression	readCompatibilityFunction(String name)
private Expression	readCompatibilitySequenceValueFunction(boolean current)
private Expression	readConcat()
private Expression	readConcatFunction(int function)
private Expression	readCondition()
private Expression	readConditionIs(Expression left, boolean whenOperand)
private Expression	readConditionRightHandSide(Expression r, boolean not, boolean whenOperand)
private TableFilter	readCorrelation(TableFilter tableFilter)
private Expression	readCurrentDateTimeValueFunction(int function, boolean hasParen, String name)
private Expression	readCurrentGeneralValueSpecification(int specification)
private Table	readDataChangeDeltaTable(String resultOptionName, int backupIndex)
private int	readDateTimeField()
private Expression	readDateTimeFormatFunction(int function)
private Expression	readDbObjectFunction(int function)
private ArrayList<String>	readDerivedColumnNames()
private TableFilter	readDerivedTableWithCorrelation()
private boolean	readDistinctAgg()
private Expression	readExpression()
private Expression	readExpressionOrDefault()
private Expression	readExpressionOrIdentifier()
private Expression	readExpressionPart2(Expression r1)
private Expression	readExpressionWithGlobalConditions()
private Expression	readFactor()
private Expression	readFetchOrLimit()
private void	readFilterAndOver(AbstractAggregate aggregate)
private String	readFromAlias(String alias)
private void	readFromFirstOrLast(WindowFunction function)
private Expression	readFunction(Schema schema, String name)
private Expression	readFunctionWithSchema(Schema schema, String name, String upperName)
private String	readIdentifier()
private String	readIdentifierOrKeyword()
private String	readIdentifierWithSchema(String defaultSchemaName)
private String	readIdentifierWithSchema()
private String	readIdentifierWithSchema2(String s)
private Expression	readIfArgument()
private TypeInfo	readIfDataType()
private TypeInfo	readIfDataType1()
private void	readIfEqualOrTo()
private boolean	readIfExists(boolean ifExists)
private boolean	readIfNotExists()
private ArrayList<QueryOrderBy>	readIfOrderBy()
private Boolean	readIfOverriding()
private SequenceValue	readIfSequencePseudoColumn(String schema, String objectName)
private Expression	readIfSingleArgument()
private boolean	readIfUseIndex()
private Expression	readIfWildcardRowidOrSequencePseudoColumn(String schema, String objectName)
private boolean	readIgnoreNulls(boolean ignoreNulls)
private Expression	readInPredicate(Expression left, boolean not, boolean whenOperand)
private Expression	readInterval()
private TypeInfo	readIntervalQualifier()
private Expression	readJoinSpecification(TableFilter filter1, TableFilter filter2, boolean rightJoin)
private boolean	readJsonObjectFunctionFlags(ExpressionWithFlags function, boolean forArray)
private IsJsonPredicate	readJsonPredicate(Expression left, boolean not, boolean whenOperand)
private Expression	readKeywordCompatibilityFunctionOrColumn()
private Expression	readLastArgument()
private Expression	readLikePredicate(Expression left, CompareLike.LikeType likeType, boolean not, boolean whenOperand)
private void	readMySQLCharset()
private Expression	readNextArgument()
private NullsDistinct	readNullsDistinct(NullsDistinct defaultDistinct)
private Expression	readOnDuplicateKeyValues(Table table, Update update)
private void	readOver(DataAnalysisOperation operation)
private <T extends ExpressionWithVariableParameters> T	readParameters(T expression)
private long	readPrecision(int valueType)
private Sequence	readSequence()
private Prepared	readSetCompatibility(Mode.ModeEnum modeEnum)
private Expression	readSetFunction()
private TableFilter	readSimpleTableFilter()
private SimpleCase.SimpleWhen	readSimpleWhenClause(Expression caseOperand)
private Expression	readSingleArgument()
private String	readString()
private String	readStringOrIdentifier()
private Expression	readStringOrParameter()
private Expression	readSubstringFunction()
private Expression	readSum()
private Column	readTableColumn(TableFilter filter)
private String	readTableColumn(TableFilter filter, String tableAlias)
private ArrayList<String>	readTableEngineParams()
private TableFunction	readTableFunction(String name, Schema schema)
private ArrayTableFunction	readTableFunction(int functionType)
private Table	readTableOrView()
private Table	readTableOrView(boolean resolveMaterializedView)
private Table	readTableOrView(String tableName, boolean resolveMaterializedView)
private TableFilter	readTablePrimary()
private TableFilter	readTableReference()
private Expression	readTerm()
private Expression	readTermObjectDot(String objectName)
private Expression	readTermWithIdentifier()
private Expression	readTermWithIdentifier(String name, boolean quoted)
private Expression	readTermWithoutIdentifier()
private Expression	readTildeCondition(Expression r, boolean not)
private Expression	readTrimFunction()
private TypePredicate	readTypePredicate(Expression left, boolean not, boolean whenOperand)
private ArrayTableFunction	readUnnestFunction()
private SetClauseList	readUpdateSetClause(TableFilter filter)
private Expression[]	readUpdateSetClauseArrayIndexes()
private Expression	readUserDefinedFunctionIf(Schema schema, String functionName)
private Expression	readWhenOperand(Expression caseOperand)
private WindowFrame	readWindowFrame()
private WindowFrameBound	readWindowFrameRange()
private WindowFrameBound	readWindowFrameStarting()
private WindowFunction	readWindowFunction(String name)
private Window	readWindowNameOrSpecification()
private Window	readWindowSpecification()
private Aggregate	readWithinGroup(AggregateType aggregateType, Expression[] args, boolean distinct, Object extraArguments, boolean forHypotheticalSet, boolean simple)
private int	scanToCloseParen(int offset)
public void	setQueryScope(QueryScope the query scope queryScope) Sets the query scope.
public void	setRightsChecked(boolean rightsChecked)
private void	setSQL(Prepared command, int start)
private Table	tableIfTableExists(Schema schema, String tableName, boolean ifTableExists)

public final Class Parser

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary