com.metamatrix.query.parser
Class SQLParser

java.lang.Object
  com.metamatrix.query.parser.SQLParserUtil
      com.metamatrix.query.parser.SQLParser

All Implemented Interfaces:

SQLParserConstants

public class SQLParser
extends SQLParserUtil
implements SQLParserConstants

The SQLParser is a JavaCC-generated parser that reads a SQL string and produces a Query object. The SQLParser.java file is generated by JavaCC from the SQLParser.jj file. WARNING: DO NOT MODIFY the SQLParser.java file as it will be regenerated from the .jj file and your changes will be lost!

Field Summary

Token	jj_nt
boolean	lookingAhead
Token	token
SQLParserTokenManager	token_source

Fields inherited from interface com.metamatrix.query.parser.SQLParserConstants

ALL, ALL_IN_GROUP, AND, ANY, AS, ASC, AVG, BEGIN, BETWEEN, BIGDECIMAL, BIGINTEGER, BLOB, BOOLEAN, BOOLEANTYPE, BREAK, BY, BYTE, CASE, CAST, CHAR, CLOB, COLON, COMMA, CONCAT_OP, CONTINUE, CONVERT, COUNT, CREATE, CRITERIA, CROSS, DATE, DATETYPE, DEBUG, DECLARE, DEFAULT, DELETE, DESC, DIGIT, DISTINCT, DOLLAR, DOTTED_ID, DOUBLE, DROP, ELEMENT, ELSE, END, EOF, EQ, ERROR, ESCAPE, EXCEPT, EXEC, EXECUTE, EXISTS, FALSE, FLOAT, FLOATVAL, FN, FOR, FROM, FULL, GE, GROUP, GROUP_PART, GT, HAS, HAVING, ID, ID_CHAR, ID_PART, IF, IN, IN_MULTI_LINE_COMMENT, INNER, INSERT, INTEGER, INTEGERVAL, INTERSECT, INTO, IS, JOIN, LBRACE, LE, LEFT, LETTER, LIKE, LIMIT, LOCAL, LONG, LOOP, LPAREN, LT, MAKEDEP, MAKENOTDEP, MAX, MIN, MINUS, MMUUID, MMUUID_CHAR, MMUUID_PART, MULTI_LINE_COMMENT, NE, NE2, NOCACHE, NOT, NULL, OBJECT, OJ, ON, OPTION, OR, ORDER, OUTER, PERIOD, PLANONLY, PLUS, PROCEDURE, QMARK, QUOTED_ID, RBRACE, RIGHT, RPAREN, SELECT, SEMICOLON, SET, SHORT, SHOWPLAN, SLASH, SOME, SQL_TSI_DAY, SQL_TSI_FRAC_SECOND, SQL_TSI_HOUR, SQL_TSI_MINUTE, SQL_TSI_MONTH, SQL_TSI_QUARTER, SQL_TSI_SECOND, SQL_TSI_WEEK, SQL_TSI_YEAR, STAR, STRING, STRINGA, STRINGB, STRINGVAL, SUM, TABLE, TEMPORARY, THEN, TIME, TIMESTAMP, TIMESTAMPADD, TIMESTAMPDIFF, TIMESTAMPTYPE, TIMETYPE, tokenImage, TRANSLATE, TRUE, UNION, UNKNOWN, UPDATE, USING, VALUES, VARIABLE, VIRTUAL, WHEN, WHERE, WHILE, WITH, XML

Constructor Summary

SQLParser(java.io.InputStream stream)

SQLParser(java.io.InputStream stream, java.lang.String encoding)

SQLParser(java.io.Reader stream)

SQLParser(SQLParserTokenManager tm)

Method Summary

AggregateSymbol	aggregateSymbol(ParseInfo info)
AssignmentStatement	assignStatement(ParseInfo info) Parse assignment statement
LanguageObject	assignStatementOperand(ParseInfo info) Parse operand of assignment statement, which can be nested arbitrarily deeply in parentheses.
Expression	basicExpression(ParseInfo info) Parse a basic expression.
BetweenCriteria	betweenCrit(ParseInfo info) Parse an [NOT] BETWEEN criteria.
Block	block(ParseInfo info) Parse block
BreakStatement	breakStatement(ParseInfo info) Parse break statement
StoredProcedure	callableStatement(ParseInfo info)
CaseExpression	caseExpression(ParseInfo info) Parse a non-searched CASE expression.
Command	command(ParseInfo info) Parse any of several command types - this is the main parser entry point.
CompareCriteria	compareCrit(ParseInfo info) Parse a compare criteria.
Criteria	compoundCritAnd(ParseInfo info) Parse a compound logical AND criteria.
Criteria	compoundCritOr(ParseInfo info) Parse a compound logical OR criteria.
Expression	concatExpression(ParseInfo info) Parse an expression - made up of literals and functions.
ContinueStatement	continueStatement(ParseInfo info) Parse break statement
java.util.List	createElementsWithTypes(ParseInfo info) * Create elementes with datatypes
Command	createTempTable(ParseInfo info) Parse create temp table command.
CreateUpdateProcedureCommand	createUpdateProcedure(ParseInfo info) Parse create update procedure command
Criteria	criteria(ParseInfo info) Parse a criteria.
CriteriaSelector	criteriaSelector() Parse criteria selector
JoinPredicate	crossJoin(ParseInfo info)
Constant	dataType() Parse a data type name - used only in conversion.
DeclareStatement	declareStatement(ParseInfo info) Parse declare statement
Delete	delete(ParseInfo info) Parse a DELETE command
Statement	delimitedStatement(ParseInfo info)
void	disable_tracing()
Command	dropTable(ParseInfo info) Parse drop table command.
DynamicCommand	dynamicCommand(ParseInfo info) Parse error statement
void	enable_tracing()
RaiseErrorStatement	errorStatement(ParseInfo info) Parse error statement
java.lang.Character	escapeChar(ParseInfo info)
StoredProcedure	executeNamedParams(ParseInfo info, StoredProcedure storedProcedure) Parse an exec statement with named parameters
StoredProcedure	executeUnnamedParams(ParseInfo info, StoredProcedure storedProcedure, int parameterIndex) Parse an exec statement with unnamed parameters
ExistsCriteria	existsCriteria(ParseInfo info) Parse an exists criteria.
Expression	expression(ParseInfo info) Parse an expression - made up of literals and functions.
From	from(ParseInfo info) Parse a FROM.
Function	function(ParseInfo info) Parse a function.
ParseException	generateParseException()
Token	getNextToken()
Token	getToken(int index)
GroupBy	groupBy(ParseInfo info) Parse a GROUP BY clause.
SingleElementSymbol	groupByItem(ParseInfo info) Parse a GROUP BY list item.
HasCriteria	hasCriteria() Parse has criteria
Criteria	having(ParseInfo info) Parse a HAVING clause.
IfStatement	ifStatement(ParseInfo info) Parse if statement
Insert	insert(ParseInfo info) Parse an INSERT command
Constant	intervalType() Parse an interval type name - used only in TIMESTAMPADD and TIMESTAMPDIFF functions.
Into	into(ParseInfo info)
IsNullCriteria	isNullCrit(ParseInfo info) Parse an IS [NOT] NULL criteria.
FromClause	joinedTable(ParseInfo info)
Limit	limit(ParseInfo info) Parse an LIMIT clause.
Constant	literal() Parse a literal - strings must be wrapped in either '' or "".
LoopStatement	loopStatement(ParseInfo info) Parse loop statement
MatchCriteria	matchCrit(ParseInfo info) Parse a match criteria.
Criteria	notCrit(ParseInfo info) Parse a logical NOT criteria.
Option	option(ParseInfo info) Parse an OPTION clause.
OrderBy	orderby(ParseInfo info) Parse an ORDER BY clause.
java.lang.String	paramName(ParseInfo info) Parse an execute statement parameter name (must not be enclosed in single or double ticks)
Expression	plusExpression(ParseInfo info) Parse an expression - made up of literals and functions.
java.lang.String	plusOperator() Parse the add/subtract operators.
PredicateCriteria	predicate(ParseInfo info) Parse a predicate criteria.
Criteria	primary(ParseInfo info) Parses the basic atomic criteria - either a predicate criteria or a criteria wrapped in ( ).
JoinPredicate	qualifiedJoin(ParseInfo info)
Query	query(ParseInfo info) Parse a SELECT query
QueryCommand	queryExpression(ParseInfo info) Currently just a place holder to keep consistency with the spec
QueryCommand	queryExpressionBody(ParseInfo info)
QueryCommand	queryPrimary(ParseInfo info)
QueryCommand	queryTerm(ParseInfo info)
void	ReInit(java.io.InputStream stream)
void	ReInit(java.io.InputStream stream, java.lang.String encoding)
void	ReInit(java.io.Reader stream)
void	ReInit(SQLParserTokenManager tm)
java.util.List	rowValues(ParseInfo info) Parse row values - this is a comma separated list of values.
SearchedCaseExpression	searchedCaseExpression(ParseInfo info) Parse a searched CASE expression.
Select	select(ParseInfo info) Parse a SELECT clause.
SelectSymbol	selectSymbol(ParseInfo info)
SetClauseList	setClauseList(boolean shortName, ParseInfo info)
AbstractSetCriteria	setCrit(ParseInfo info) Parse a set criteria.
CommandStatement	sqlStatement(ParseInfo info) Parse sql statement
Statement	statement(ParseInfo info) Parse statement
StoredProcedure	storedProcedure(ParseInfo info) * Parse stored query command
Command	subquery(ParseInfo info)
SubqueryCompareCriteria	subqueryCompareCriteria(ParseInfo info) Parse a subquery compare criteria.
SubqueryFromClause	subqueryFromClause(ParseInfo info) Parse a unary from clause, which is just a single group name and an optional alias.
FromClause	tablePrimary(ParseInfo info)
FromClause	tableReference(ParseInfo info) Parse a join predicate clause, which occurs as an element in the FROM clause.
FromClause	tableReferenceUnescaped(ParseInfo info)
Expression	timesExpression(ParseInfo info) Parse an expression - made up of literals and functions.
java.lang.String	timesOperator() Parse the multiply/divide operator.
TranslateCriteria	translateCriteria(ParseInfo info)
UnaryFromClause	unaryFromClause(ParseInfo info) Parse a unary from clause, which is just a single group name and an optional alias.
Update	update(ParseInfo info) Parse an UPDATE command
Command	userCommand(ParseInfo info)
Criteria	where(ParseInfo info) Parse a WHERE clause.
WhileStatement	whileStatement(ParseInfo info) Parse while statement

Methods inherited from class java.lang.Object

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

Field Detail

token_source

public SQLParserTokenManager token_source

token

public Token token

jj_nt

public Token jj_nt

lookingAhead

public boolean lookingAhead

Constructor Detail

SQLParser

public SQLParser(java.io.InputStream stream)

SQLParser

public SQLParser(java.io.InputStream stream,
                 java.lang.String encoding)

SQLParser

public SQLParser(java.io.Reader stream)

SQLParser

public SQLParser(SQLParserTokenManager tm)

Method Detail

command

public final Command command(ParseInfo info)
                      throws ParseException

Parse any of several command types - this is the main parser entry point.

Parameters:

info - instructions to parse the command

Returns:

Parsed command

Throws:

ParseException - if parsing failed

userCommand

public final Command userCommand(ParseInfo info)
                          throws ParseException

Throws:

ParseException

dropTable

public final Command dropTable(ParseInfo info)
                        throws ParseException

Parse drop table command.

Parameters:

info - instructions to parse the command

Returns:

Parsed command

Throws:

ParseException - if parsing failed

createTempTable

public final Command createTempTable(ParseInfo info)
                              throws ParseException

Parse create temp table command.

Parameters:

info - instructions to parse the command

Returns:

Parsed command

Throws:

ParseException - if parsing failed

errorStatement

public final RaiseErrorStatement errorStatement(ParseInfo info)
                                         throws ParseException

Parse error statement

Throws:

ParseException - if parsing failed

statement

public final Statement statement(ParseInfo info)
                          throws ParseException

Parse statement

Throws:

ParseException - if parsing failed

delimitedStatement

public final Statement delimitedStatement(ParseInfo info)
                                   throws ParseException

Throws:

ParseException

block

public final Block block(ParseInfo info)
                  throws ParseException

Parse block

Throws:

ParseException

breakStatement

public final BreakStatement breakStatement(ParseInfo info)
                                    throws ParseException

Parse break statement

Throws:

ParseException - if parsing failed

continueStatement

public final ContinueStatement continueStatement(ParseInfo info)
                                          throws ParseException

Parse break statement

Throws:

ParseException - if parsing failed

whileStatement

public final WhileStatement whileStatement(ParseInfo info)
                                    throws ParseException

Parse while statement

Throws:

ParseException - if parsing failed

loopStatement

public final LoopStatement loopStatement(ParseInfo info)
                                  throws ParseException

Parse loop statement

Throws:

ParseException - if parsing failed

ifStatement

public final IfStatement ifStatement(ParseInfo info)
                              throws ParseException

Parse if statement

Throws:

ParseException - if parsing failed

criteriaSelector

public final CriteriaSelector criteriaSelector()
                                        throws ParseException

Parse criteria selector

Throws:

ParseException - if parsing failed

hasCriteria

public final HasCriteria hasCriteria()
                              throws ParseException

Parse has criteria

Throws:

ParseException

declareStatement

public final DeclareStatement declareStatement(ParseInfo info)
                                        throws ParseException

Parse declare statement

Throws:

ParseException - if parsing failed

assignStatement

public final AssignmentStatement assignStatement(ParseInfo info)
                                          throws ParseException

Parse assignment statement

Throws:

ParseException - if parsing failed

assignStatementOperand

public final LanguageObject assignStatementOperand(ParseInfo info)
                                            throws ParseException

Parse operand of assignment statement, which can be nested arbitrarily deeply in parentheses.

Throws:

ParseException - if parsing failed

sqlStatement

public final CommandStatement sqlStatement(ParseInfo info)
                                    throws ParseException

Parse sql statement

Throws:

ParseException - if parsing failed

translateCriteria

public final TranslateCriteria translateCriteria(ParseInfo info)
                                          throws ParseException

Throws:

ParseException

createUpdateProcedure

public final CreateUpdateProcedureCommand createUpdateProcedure(ParseInfo info)
                                                         throws ParseException

Parse create update procedure command

Throws:

ParseException - if parsing failed

dynamicCommand

public final DynamicCommand dynamicCommand(ParseInfo info)
                                    throws ParseException

Parse error statement

Throws:

ParseException - if parsing failed

setClauseList

public final SetClauseList setClauseList(boolean shortName,
                                         ParseInfo info)
                                  throws ParseException

Throws:

ParseException

createElementsWithTypes

public final java.util.List createElementsWithTypes(ParseInfo info)
                                             throws ParseException

* Create elementes with datatypes

Throws:

ParseException - if parsing failed

callableStatement

public final StoredProcedure callableStatement(ParseInfo info)
                                        throws ParseException

Throws:

ParseException

storedProcedure

public final StoredProcedure storedProcedure(ParseInfo info)
                                      throws ParseException

* Parse stored query command

Throws:

ParseException - if parsing failed

executeUnnamedParams

public final StoredProcedure executeUnnamedParams(ParseInfo info,
                                                  StoredProcedure storedProcedure,
                                                  int parameterIndex)
                                           throws ParseException

Parse an exec statement with unnamed parameters

Throws:

ParseException - if parsing failed

executeNamedParams

public final StoredProcedure executeNamedParams(ParseInfo info,
                                                StoredProcedure storedProcedure)
                                         throws ParseException

Parse an exec statement with named parameters

Throws:

ParseException - if parsing failed

paramName

public final java.lang.String paramName(ParseInfo info)
                                 throws ParseException

Parse an execute statement parameter name (must not be enclosed in single or double ticks)

Returns:

Parsed insert statement

Throws:

ParseException - if parsing failed

insert

public final Insert insert(ParseInfo info)
                    throws ParseException

Parse an INSERT command

Returns:

Parsed insert statement

Throws:

ParseException - if parsing failed

rowValues

public final java.util.List rowValues(ParseInfo info)
                               throws ParseException

Parse row values - this is a comma separated list of values.

Returns:

List of values, never null

Throws:

ParseException - if parsing failed

update

public final Update update(ParseInfo info)
                    throws ParseException

Parse an UPDATE command

Returns:

Parsed update statement

Throws:

ParseException - if parsing failed

delete

public final Delete delete(ParseInfo info)
                    throws ParseException

Parse a DELETE command

Returns:

Parsed delete statement

Throws:

ParseException - if parsing failed

queryExpression

public final QueryCommand queryExpression(ParseInfo info)
                                   throws ParseException

Currently just a place holder to keep consistency with the spec

Throws:

ParseException

queryExpressionBody

public final QueryCommand queryExpressionBody(ParseInfo info)
                                       throws ParseException

Throws:

ParseException

queryTerm

public final QueryCommand queryTerm(ParseInfo info)
                             throws ParseException

Throws:

ParseException

queryPrimary

public final QueryCommand queryPrimary(ParseInfo info)
                                throws ParseException

Throws:

ParseException

query

public final Query query(ParseInfo info)
                  throws ParseException

Parse a SELECT query

Returns:

Parsed query

Throws:

ParseException - if parsing failed

into

public final Into into(ParseInfo info)
                throws ParseException

Throws:

ParseException

select

public final Select select(ParseInfo info)
                    throws ParseException

Parse a SELECT clause. The select must handle elements, aliased elements (x AS y), group.*, and *. It also must handle an optional DISTINCT at the beginning of the select list. It also must handle a scalar subquery expression in parentheses.

Example: "SELECT group.element, group2.element2 AS x, group3.*".

Example: "SELECT *".

Example: "SELECT DISTINCT a, b, c".

Example: "SELECT a, (SELECT b FROM groupC)".

Example: "SELECT a, (SELECT b FROM groupC) as d".

Returns:

Parsed select

Throws:

ParseException - if parsing failed

selectSymbol

public final SelectSymbol selectSymbol(ParseInfo info)
                                throws ParseException

Throws:

ParseException

aggregateSymbol

public final AggregateSymbol aggregateSymbol(ParseInfo info)
                                      throws ParseException

Throws:

ParseException

from

public final From from(ParseInfo info)
                throws ParseException

Parse a FROM. The from must handle groups, aliased groups or joined groups. This also handles JDBC escape processinf syntax for outer joins.

Example: "FROM a, b".

Example: "FROM a AS x, b as Y".

Example: "FROM a right outer join b, c, d join e".

Parameters:

from - object which is to be updated with the details in the from clause.

Returns:

list containing criteria objects.

Throws:

ParseException - if parsing failed

tableReference

public final FromClause tableReference(ParseInfo info)
                                throws ParseException

Parse a join predicate clause, which occurs as an element in the FROM clause. The join predicate combines two from clauses with a join.

Returns:

Join predicate

Throws:

ParseException - if parsing failed

tableReferenceUnescaped

public final FromClause tableReferenceUnescaped(ParseInfo info)
                                         throws ParseException

Throws:

ParseException

joinedTable

public final FromClause joinedTable(ParseInfo info)
                             throws ParseException

Throws:

ParseException

crossJoin

public final JoinPredicate crossJoin(ParseInfo info)
                              throws ParseException

Throws:

ParseException

qualifiedJoin

public final JoinPredicate qualifiedJoin(ParseInfo info)
                                  throws ParseException

Throws:

ParseException

tablePrimary

public final FromClause tablePrimary(ParseInfo info)
                              throws ParseException

Throws:

ParseException

subqueryFromClause

public final SubqueryFromClause subqueryFromClause(ParseInfo info)
                                            throws ParseException

Parse a unary from clause, which is just a single group name and an optional alias.

Returns:

Unary from clause containing the group

Throws:

ParseException - if parsing failed

unaryFromClause

public final UnaryFromClause unaryFromClause(ParseInfo info)
                                      throws ParseException

Parse a unary from clause, which is just a single group name and an optional alias.

Returns:

Unary from clause containing the group

Throws:

ParseException - if parsing failed

where

public final Criteria where(ParseInfo info)
                     throws ParseException

Parse a WHERE clause. The where clause holds a criteria.

Returns:

Parsed where

Throws:

ParseException - if parsing failed

criteria

public final Criteria criteria(ParseInfo info)
                        throws ParseException

Parse a criteria. This will parse any criteria expression.

Returns:

Parsed criteria

Throws:

ParseException - if parsing failed

compoundCritOr

public final Criteria compoundCritOr(ParseInfo info)
                              throws ParseException

Parse a compound logical OR criteria.

Returns:

Parsed OR criteria

Throws:

ParseException - if parsing failed

compoundCritAnd

public final Criteria compoundCritAnd(ParseInfo info)
                               throws ParseException

Parse a compound logical AND criteria.

Returns:

Parsed AND criteria

Throws:

ParseException - if parsing failed

notCrit

public final Criteria notCrit(ParseInfo info)
                       throws ParseException

Parse a logical NOT criteria.

Returns:

Parsed NOT criteria

Throws:

ParseException - if parsing failed

primary

public final Criteria primary(ParseInfo info)
                       throws ParseException

Parses the basic atomic criteria - either a predicate criteria or a criteria wrapped in ( ).

Returns:

Parsed primary criteria

Throws:

ParseException - if parsing failed

predicate

public final PredicateCriteria predicate(ParseInfo info)
                                  throws ParseException

Parse a predicate criteria.

Returns:

Parsed predicate criteria

Throws:

ParseException - if parsing failed

compareCrit

public final CompareCriteria compareCrit(ParseInfo info)
                                  throws ParseException

Parse a compare criteria.

Returns:

Parsed compare criteria

Throws:

ParseException - if parsing failed

subquery

public final Command subquery(ParseInfo info)
                       throws ParseException

Throws:

ParseException

subqueryCompareCriteria

public final SubqueryCompareCriteria subqueryCompareCriteria(ParseInfo info)
                                                      throws ParseException

Parse a subquery compare criteria.

Returns:

Parsed subquery compare criteria

Throws:

ParseException - if parsing failed

matchCrit

public final MatchCriteria matchCrit(ParseInfo info)
                              throws ParseException

Parse a match criteria. Also parses JDBC escape syntax for match criteria.

Returns:

Parsed match criteria

Throws:

ParseException - if parsing failed

escapeChar

public final java.lang.Character escapeChar(ParseInfo info)
                                     throws ParseException

Throws:

ParseException

betweenCrit

public final BetweenCriteria betweenCrit(ParseInfo info)
                                  throws ParseException

Parse an [NOT] BETWEEN criteria.

Returns:

Parsed BETWEEN criteria

Throws:

ParseException - if parsing failed

isNullCrit

public final IsNullCriteria isNullCrit(ParseInfo info)
                                throws ParseException

Parse an IS [NOT] NULL criteria.

Returns:

Parsed IS NULL criteria

Throws:

ParseException - if parsing failed

setCrit

public final AbstractSetCriteria setCrit(ParseInfo info)
                                  throws ParseException

Parse a set criteria.

Returns:

Parsed set criteria

Throws:

ParseException - if parsing failed

existsCriteria

public final ExistsCriteria existsCriteria(ParseInfo info)
                                    throws ParseException

Parse an exists criteria.

Returns:

Parsed exists criteria

Throws:

ParseException - if parsing failed

groupBy

public final GroupBy groupBy(ParseInfo info)
                      throws ParseException

Parse a GROUP BY clause.

Returns:

Parsed group by

Throws:

ParseException - if parsing failed

groupByItem

public final SingleElementSymbol groupByItem(ParseInfo info)
                                      throws ParseException

Parse a GROUP BY list item.

Returns:

Parsed group by item

Throws:

ParseException - if parsing failed

having

public final Criteria having(ParseInfo info)
                      throws ParseException

Parse a HAVING clause.

Returns:

Parsed having

Throws:

ParseException - if parsing failed

orderby

public final OrderBy orderby(ParseInfo info)
                      throws ParseException

Parse an ORDER BY clause.

Returns:

Parsed ORDER BY

Throws:

ParseException - if parsing failed

limit

public final Limit limit(ParseInfo info)
                  throws ParseException

Parse an LIMIT clause.

Returns:

Parsed LIMIT

Throws:

ParseException - if parsing failed

option

public final Option option(ParseInfo info)
                    throws ParseException

Parse an OPTION clause.

Returns:

Parsed OPTION clause

Throws:

ParseException - if parsing failed

expression

public final Expression expression(ParseInfo info)
                            throws ParseException

Parse an expression - made up of literals and functions.

Returns:

Expression

Throws:

ParseException - if parsing failed

concatExpression

public final Expression concatExpression(ParseInfo info)
                                  throws ParseException

Parse an expression - made up of literals and functions.

Returns:

Expression

Throws:

ParseException - if parsing failed

plusExpression

public final Expression plusExpression(ParseInfo info)
                                throws ParseException

Parse an expression - made up of literals and functions.

Returns:

Expression

Throws:

ParseException - if parsing failed

plusOperator

public final java.lang.String plusOperator()
                                    throws ParseException

Parse the add/subtract operators.

Returns:

"+" or "-"

Throws:

ParseException - if parsing failed

timesExpression

public final Expression timesExpression(ParseInfo info)
                                 throws ParseException

Parse an expression - made up of literals and functions.

Returns:

Expression

Throws:

ParseException - if parsing failed

timesOperator

public final java.lang.String timesOperator()
                                     throws ParseException

Parse the multiply/divide operator.

Returns:

"*" or "/"

Throws:

ParseException - if parsing failed

basicExpression

public final Expression basicExpression(ParseInfo info)
                                 throws ParseException

Parse a basic expression.

Returns:

Expression

Throws:

ParseException - if parsing failed

caseExpression

public final CaseExpression caseExpression(ParseInfo info)
                                    throws ParseException

Parse a non-searched CASE expression.

Returns:

CaseExpression

Throws:

ParseException - if parsing failed

searchedCaseExpression

public final SearchedCaseExpression searchedCaseExpression(ParseInfo info)
                                                    throws ParseException

Parse a searched CASE expression.

Returns:

SearchedCaseExpression

Throws:

ParseException - if parsing failed

function

public final Function function(ParseInfo info)
                        throws ParseException

Parse a function.

Returns:

Parsed function

Throws:

ParseException - if parsing failed

dataType

public final Constant dataType()
                        throws ParseException

Parse a data type name - used only in conversion.

Returns:

Data type parsed into a constant string object

Throws:

ParseException - if parsing failed

intervalType

public final Constant intervalType()
                            throws ParseException

Parse an interval type name - used only in TIMESTAMPADD and TIMESTAMPDIFF functions.

Returns:

Interval type parsed into a constant string object

Throws:

ParseException - if parsing failed

literal

public final Constant literal()
                       throws ParseException

Parse a literal - strings must be wrapped in either '' or "". JDBC escape syntax is parsed for Date, Time and Timestamp value.

Returns:

Parsed literal

Throws:

ParseException - if parsing failed

ReInit

public void ReInit(java.io.InputStream stream)

ReInit

public void ReInit(java.io.InputStream stream,
                   java.lang.String encoding)

ReInit

public void ReInit(java.io.Reader stream)

ReInit

public void ReInit(SQLParserTokenManager tm)

getNextToken

public final Token getNextToken()

getToken

public final Token getToken(int index)

generateParseException

public ParseException generateParseException()

enable_tracing

public final void enable_tracing()

disable_tracing

public final void disable_tracing()