java.lang.Object
- com.mckoi.database.sql.SQL

All Implemented Interfaces:: SQLConstants

public class SQL
extends java.lang.Object
implements SQLConstants

Nested Class Summary

Nested Classes
Modifier and Type Class Description

(package private) static class SQL.JJCalls

Field Summary

Fields
Modifier and Type	Field	Description
`private boolean`	`case_insensitive_identifiers`	Set to true if the SQL identifiers are converted to upper case.
`private SQL.JJCalls[]`	`jj_2_rtns`
`private int`	`jj_endpos`
`private java.util.Vector`	`jj_expentries`
`private int[]`	`jj_expentry`
`private int`	`jj_gc`
`private int`	`jj_gen`
`(package private) SimpleCharStream`	`jj_input_stream`
`private int`	`jj_kind`
`private int`	`jj_la`
`private int[]`	`jj_la1`
`private int[]`	`jj_la1_0`
`private int[]`	`jj_la1_1`
`private int[]`	`jj_la1_2`
`private int[]`	`jj_la1_3`
`private int[]`	`jj_la1_4`
`private int[]`	`jj_la1_5`
`private int[]`	`jj_la1_6`
`private Token`	`jj_lastpos`
`private int[]`	`jj_lasttokens`
`Token`	`jj_nt`
`private int`	`jj_ntk`
`private boolean`	`jj_rescan`
`private Token`	`jj_scanpos`
`private boolean`	`jj_semLA`
`boolean`	`lookingAhead`
`private int`	`parameter_id`	The parameter id.
`Token`	`token`
`SQLTokenManager`	`token_source`

Fields inherited from interface com.mckoi.database.sql.SQLConstants
ACCOUNT, ACTION, ADD, AFTER, ALL, ALTER, AND, ANY, AS, ASC, ASSIGNMENT, AUTOCOMMIT, BEFORE, BETWEEN, BIGINT, BINARY, BIT, BLOB, BOOLEAN, BOOLEAN_LITERAL, BOTH, CACHE, CALL, CALLBACK, CANONICAL_DECOMPOSITION, CASCADE, CAST, CHAR, CHARACTER, CHECK, CLOB, COLLATE, COMMIT, COMPACT, CONCAT, CONSTRAINT, COUNT, CREATE, CROSS, CTALIAS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CYCLE, DATE, DECIMAL, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DESC, DESCRIBE, DIGIT, DISTINCT, DIVIDE, DOT_DELIMINATED_REF, DOUBLE, DROP, EACH, EOF, EQUALS, EXCEPT, EXECUTE, EXISTS, EXPLAIN, FLOAT, FOR, FOREIGN, FROM, FULL_DECOMPOSITION, FUNCTION, GLOBVARIABLE, GR, GRANT, GREQ, GROUPBY, GROUPMAX, GROUPS, HAVING, IDENTICAL_STRENGTH, IDENTIFIER, IF, IGNORE, IMMEDIATE, IN, INCREMENT, INDEX, INDEX_BLIST, INDEX_NONE, INITIALLY, INNER, INSERT, INT, INTEGER, INTERSECT, INTO, IS, JAVA, JAVA_OBJECT, JAVA_OBJECT_ARRAY_REF, JOIN, KEY, LANGUAGE, LE, LEADING, LEEQ, LEFT, LETTER, LIKE, LIMIT, LOCK, LONG, LONGVARBINARY, LONGVARCHAR, MAXVALUE, MINVALUE, NAME, NATURAL, NEW, NO, NO_DECOMPOSITION, NOT, NOTEQ, NULL_LITERAL, NUMBER_LITERAL, NUMERIC, OLD, ON, OPTIMIZE, OPTION, OR, ORDERBY, OUTER, PARAMETER_REF, PASSWORD, PRIMARY, PRIMARY_STRENGTH, PRIVILEGES, PROCEDURE, PUBLIC, QUOTED_DELIMINATED_REF, QUOTED_VARIABLE, QUOTEDGLOBVARIABLE, READCOMMITTED, READUNCOMMITTED, REAL, REFERENCES, REGEX, REGEX_LITERAL, REPEATABLEREAD, RESTRICT, RETURNS, REVOKE, RIGHT, ROLLBACK, ROW, SCHEMA, SECONDARY_STRENGTH, SELECT, SEQUENCE, SERIALIZABLE, SET, SHOW, SHUTDOWN, SMALLINT, SOME, SQLADD, SQLCOLUMN, SQLDEFAULT, SQLRETURN, STAR, START, STRING, STRING_LITERAL, SUBTRACT, TABLE, TEMPORARY, TERTIARY_STRENGTH, TEXT, TIME, TIMESTAMP, TINYINT, TO, tokenImage, TRAILING, TRANSACTIONISOLATIONLEVEL, TRIGGER, TRIM, UNION, UNIQUE, UNLOCK, UPDATE, USAGE, USE, USER, USING, VALUES, VARBINARY, VARCHAR, VARYING, VIEW, WHERE, WITH

Constructor Summary

Constructors
Constructor Description

SQL(SQLTokenManager tm)

SQL(java.io.InputStream stream)

SQL(java.io.Reader stream)

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`addOperatorToExpression(Expression exp, Operator op)`	Helper for expression parsing.
`StatementTree`	`Alter()`
`StatementTree`	`AlterTable()`
`StatementTree`	`AlterUser()`
`void`	`AssignmentList(java.util.ArrayList assignment_list)`
`java.util.ArrayList`	`BasicColumnList(java.util.ArrayList list)`
`java.lang.String`	`BeforeOrAfter()`
`void`	`BetweenPredicate(Expression exp, java.util.Stack stack)`
`void`	`BooleanOperator(Expression exp, java.util.Stack stack)`
`StatementTree`	`Call()`
`java.lang.String`	`caseCheck(java.lang.String identif)`	If the parser has been defined as case insensitive then this returns the uppercase version of the given string.
`void`	`ColumnConstraint(ColumnDef column)`
`void`	`ColumnDataType(ColumnDef column)`
`void`	`ColumnDeclarationList(java.util.ArrayList column_list, java.util.ArrayList constraint_list)`
`ColumnDef`	`ColumnDefinition()`
`java.lang.String`	`ColumnName()`
`Variable`	`ColumnNameVariable()`
`void`	`ColumnOrConstraintDefinition(java.util.ArrayList column_list, java.util.ArrayList constraint_list)`
`StatementTree`	`Compact()`
`StatementTree`	`CompleteTransaction()`
`void`	`ConditionsExpression(SearchExpression se)`
`void`	`ConstraintAttributes(ConstraintDef constraint)`
`java.lang.String`	`ConstraintName()`
`StatementTree`	`Create()`
`StatementTree`	`CreateFunction()`
`StatementTree`	`CreateIndex()`
`StatementTree`	`CreateSchema()`
`StatementTree`	`CreateSequence()`
`ParameterSubstitution`	`createSubstitution(java.lang.String image)`	Creates and returns a parameter substitution.
`StatementTree`	`CreateTable()`
`StatementTree`	`CreateTrigger()`
`StatementTree`	`CreateUser()`
`StatementTree`	`CreateView()`
`StatementTree`	`Delete()`
`StatementTree`	`Describe()`
`void`	`disable_tracing()`
`Expression`	`DoExpression()`
`Expression`	`DoNonBooleanExpression()`
`StatementTree`	`Drop()`
`StatementTree`	`DropFunction()`
`StatementTree`	`DropIndex()`
`StatementTree`	`DropSchema()`
`StatementTree`	`DropSequence()`
`StatementTree`	`DropTable()`
`StatementTree`	`DropTrigger()`
`StatementTree`	`DropUser()`
`StatementTree`	`DropView()`
`void`	`enable_tracing()`
`void`	`expEnd(Expression exp, java.util.Stack stack)`	Helper for expression parsing.
`void`	`expEndParen(Expression exp, java.util.Stack stack)`	Helper for expression parsing.
`void`	`expOperator(Expression exp, java.util.Stack stack, Operator op)`	Helper for expression parsing.
`void`	`expression(Expression exp, java.util.Stack stack)`	Parse an expression.
`Expression[]`	`ExpressionList()`
`Expression`	`ExpressionTest()`
`void`	`flushOperatorStack(Expression exp, java.util.Stack stack, int precedence)`	Flush the operator stack until the stack is either empty or the top element is either a "(" or of a precedence lower than the given precedence.
`void`	`FromClauseJoin(FromClause from_clause)`
`FunctionDef`	`Function()`
`Token`	`FunctionIdentifier()`
`java.lang.String`	`FunctionName()`
`Expression[]`	`FunctionParams()`
`ParseException`	`generateParseException()`
`AlterTableAction`	`GetAlterTableAction()`
`int`	`GetBinarySQLType()`
`java.lang.String`	`GetBooleanOperator()`
`int`	`GetBooleanSQLType()`
`int`	`GetCollateDecomposition()`
`int`	`GetCollateStrength()`
`java.lang.String`	`GetComposite()`
`int`	`GetDateSQLType()`
`Token`	`getNextToken()`
`java.lang.String`	`GetNumericOperator()`
`int`	`GetNumericSQLType()`
`java.lang.String`	`GetStringOperator()`
`int`	`GetStringSQLType()`
`java.lang.String`	`GetSubQueryBooleanOperator()`
`TableSelectExpression`	`GetTableSelectExpression()`
`Token`	`getToken(int index)`
`TType`	`GetTType()`
`StatementTree`	`Grant()`
`Variable`	`GroupMaxColumn()`	NOTE: This is an extension, allows for us to specify a column to return the max value for each row representing a group.
`java.lang.String`	`IndexName()`
`StatementTree`	`Insert()`
`void`	`InsertDataList(java.util.ArrayList data_list)`
`java.lang.Object`	`InsertElement()`
`java.util.ArrayList`	`InsertExpressionList()`
`FunctionDef`	`JavaInstantiation()`
`private boolean`	`jj_2_1(int xla)`
`private boolean`	`jj_2_10(int xla)`
`private boolean`	`jj_2_11(int xla)`
`private boolean`	`jj_2_12(int xla)`
`private boolean`	`jj_2_13(int xla)`
`private boolean`	`jj_2_14(int xla)`
`private boolean`	`jj_2_15(int xla)`
`private boolean`	`jj_2_16(int xla)`
`private boolean`	`jj_2_17(int xla)`
`private boolean`	`jj_2_2(int xla)`
`private boolean`	`jj_2_3(int xla)`
`private boolean`	`jj_2_4(int xla)`
`private boolean`	`jj_2_5(int xla)`
`private boolean`	`jj_2_6(int xla)`
`private boolean`	`jj_2_7(int xla)`
`private boolean`	`jj_2_8(int xla)`
`private boolean`	`jj_2_9(int xla)`
`private boolean`	`jj_3_1()`
`private boolean`	`jj_3_10()`
`private boolean`	`jj_3_11()`
`private boolean`	`jj_3_12()`
`private boolean`	`jj_3_13()`
`private boolean`	`jj_3_14()`
`private boolean`	`jj_3_15()`
`private boolean`	`jj_3_16()`
`private boolean`	`jj_3_17()`
`private boolean`	`jj_3_2()`
`private boolean`	`jj_3_3()`
`private boolean`	`jj_3_4()`
`private boolean`	`jj_3_5()`
`private boolean`	`jj_3_6()`
`private boolean`	`jj_3_7()`
`private boolean`	`jj_3_8()`
`private boolean`	`jj_3_9()`
`private boolean`	`jj_3R_100()`
`private boolean`	`jj_3R_101()`
`private boolean`	`jj_3R_102()`
`private boolean`	`jj_3R_103()`
`private boolean`	`jj_3R_104()`
`private boolean`	`jj_3R_105()`
`private boolean`	`jj_3R_106()`
`private boolean`	`jj_3R_107()`
`private boolean`	`jj_3R_108()`
`private boolean`	`jj_3R_109()`
`private boolean`	`jj_3R_110()`
`private boolean`	`jj_3R_111()`
`private boolean`	`jj_3R_112()`
`private boolean`	`jj_3R_113()`
`private boolean`	`jj_3R_114()`
`private boolean`	`jj_3R_115()`
`private boolean`	`jj_3R_116()`
`private boolean`	`jj_3R_117()`
`private boolean`	`jj_3R_118()`
`private boolean`	`jj_3R_119()`
`private boolean`	`jj_3R_120()`
`private boolean`	`jj_3R_121()`
`private boolean`	`jj_3R_122()`
`private boolean`	`jj_3R_123()`
`private boolean`	`jj_3R_124()`
`private boolean`	`jj_3R_125()`
`private boolean`	`jj_3R_126()`
`private boolean`	`jj_3R_127()`
`private boolean`	`jj_3R_128()`
`private boolean`	`jj_3R_129()`
`private boolean`	`jj_3R_130()`
`private boolean`	`jj_3R_131()`
`private boolean`	`jj_3R_132()`
`private boolean`	`jj_3R_133()`
`private boolean`	`jj_3R_134()`
`private boolean`	`jj_3R_135()`
`private boolean`	`jj_3R_136()`
`private boolean`	`jj_3R_137()`
`private boolean`	`jj_3R_138()`
`private boolean`	`jj_3R_17()`
`private boolean`	`jj_3R_18()`
`private boolean`	`jj_3R_19()`
`private boolean`	`jj_3R_20()`
`private boolean`	`jj_3R_21()`
`private boolean`	`jj_3R_22()`
`private boolean`	`jj_3R_23()`
`private boolean`	`jj_3R_24()`
`private boolean`	`jj_3R_25()`
`private boolean`	`jj_3R_26()`
`private boolean`	`jj_3R_27()`
`private boolean`	`jj_3R_28()`
`private boolean`	`jj_3R_29()`
`private boolean`	`jj_3R_30()`
`private boolean`	`jj_3R_31()`
`private boolean`	`jj_3R_32()`
`private boolean`	`jj_3R_33()`
`private boolean`	`jj_3R_34()`
`private boolean`	`jj_3R_35()`
`private boolean`	`jj_3R_36()`
`private boolean`	`jj_3R_37()`
`private boolean`	`jj_3R_38()`
`private boolean`	`jj_3R_39()`
`private boolean`	`jj_3R_40()`
`private boolean`	`jj_3R_41()`
`private boolean`	`jj_3R_42()`
`private boolean`	`jj_3R_43()`
`private boolean`	`jj_3R_44()`
`private boolean`	`jj_3R_45()`
`private boolean`	`jj_3R_46()`
`private boolean`	`jj_3R_47()`
`private boolean`	`jj_3R_48()`
`private boolean`	`jj_3R_49()`
`private boolean`	`jj_3R_50()`
`private boolean`	`jj_3R_51()`
`private boolean`	`jj_3R_52()`
`private boolean`	`jj_3R_53()`
`private boolean`	`jj_3R_54()`
`private boolean`	`jj_3R_55()`
`private boolean`	`jj_3R_56()`
`private boolean`	`jj_3R_57()`
`private boolean`	`jj_3R_58()`
`private boolean`	`jj_3R_59()`
`private boolean`	`jj_3R_60()`
`private boolean`	`jj_3R_61()`
`private boolean`	`jj_3R_62()`
`private boolean`	`jj_3R_63()`
`private boolean`	`jj_3R_64()`
`private boolean`	`jj_3R_65()`
`private boolean`	`jj_3R_66()`
`private boolean`	`jj_3R_67()`
`private boolean`	`jj_3R_68()`
`private boolean`	`jj_3R_69()`
`private boolean`	`jj_3R_70()`
`private boolean`	`jj_3R_71()`
`private boolean`	`jj_3R_72()`
`private boolean`	`jj_3R_73()`
`private boolean`	`jj_3R_74()`
`private boolean`	`jj_3R_75()`
`private boolean`	`jj_3R_76()`
`private boolean`	`jj_3R_77()`
`private boolean`	`jj_3R_78()`
`private boolean`	`jj_3R_79()`
`private boolean`	`jj_3R_80()`
`private boolean`	`jj_3R_81()`
`private boolean`	`jj_3R_82()`
`private boolean`	`jj_3R_83()`
`private boolean`	`jj_3R_84()`
`private boolean`	`jj_3R_85()`
`private boolean`	`jj_3R_86()`
`private boolean`	`jj_3R_87()`
`private boolean`	`jj_3R_88()`
`private boolean`	`jj_3R_89()`
`private boolean`	`jj_3R_90()`
`private boolean`	`jj_3R_91()`
`private boolean`	`jj_3R_92()`
`private boolean`	`jj_3R_93()`
`private boolean`	`jj_3R_94()`
`private boolean`	`jj_3R_95()`
`private boolean`	`jj_3R_96()`
`private boolean`	`jj_3R_97()`
`private boolean`	`jj_3R_98()`
`private boolean`	`jj_3R_99()`
`private void`	`jj_add_error_token(int kind, int pos)`
`private Token`	`jj_consume_token(int kind)`
`private int`	`jj_ntk()`
`private void`	`jj_rescan_token()`
`private void`	`jj_save(int index, int xla)`
`private boolean`	`jj_scan_token(int kind)`
`static void`	`main(java.lang.String[] args)`
`void`	`nonBooleanExpression(Expression exp, java.util.Stack stack)`	Parses a non-boolean expression.
`void`	`NumericOperator(Expression exp, java.util.Stack stack)`
`void`	`Operand(Expression exp, java.util.Stack stack)`
`void`	`OpPart(Expression exp, java.util.Stack stack)`
`boolean`	`OrderingSpec()`
`Expression`	`parseExpression()`
`int`	`PositiveIntegerConstant()`
`java.util.ArrayList`	`PrivList(java.util.ArrayList list)`
`void`	`PrivListItem(java.util.ArrayList list)`
`java.lang.String`	`PrivObject()`
`java.lang.String`	`ProcArgumentName()`
`java.lang.String`	`ProcedureName()`
`void`	`ProcParameterList(java.util.ArrayList decl_names, java.util.ArrayList decl_types)`
`java.lang.String`	`ReferentialTrigger()`
`void`	`ReInit(SQLTokenManager tm)`
`void`	`ReInit(java.io.InputStream stream)`
`void`	`ReInit(java.io.Reader stream)`
`void`	`reset()`	Resets the parameter id.
`StatementTree`	`Revoke()`
`java.lang.String`	`SchemaName()`
`StatementTree`	`Select()`
`SelectColumn`	`SelectColumn()`
`void`	`SelectColumnList(java.util.ArrayList list)`
`void`	`SelectGroupByList(java.util.ArrayList list)`
`void`	`SelectOrderByList(java.util.ArrayList list)`
`void`	`SelectTableList(FromClause from_clause)`
`java.lang.String`	`SequenceName()`
`StatementTree`	`Set()`
`boolean`	`SetQuantifier()`
`StatementTree`	`Show()`
`StatementTree`	`ShutDown()`
`Token`	`SQLIdentifier()`
`StatementTree`	`Statement()`
`void`	`StringOperator(Expression exp, java.util.Stack stack)`
`void`	`SubQueryExpression(Expression exp, java.util.Stack stack)`
`void`	`SubQueryOperator(Expression exp, java.util.Stack stack)`
`java.lang.String`	`TableAliasName()`
`ConstraintDef`	`TableConstraintDefinition()`
`void`	`TableDeclaration(FromClause from_clause)`
`java.lang.String`	`TableName()`
`void`	`Test()`
`java.lang.String`	`TriggerName()`
`java.lang.String`	`TriggerType()`
`void`	`TriggerTypes(java.util.ArrayList list)`
`StatementTree`	`Update()`
`void`	`UserManagerCommand(StatementTree cmd)`
`java.lang.String`	`UserName()`
`java.util.ArrayList`	`UserNameList(java.util.ArrayList list)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

case_insensitive_identifiers
```
private boolean case_insensitive_identifiers
```
Set to true if the SQL identifiers are converted to upper case. NOTE: Purely experimental feature!

parameter_id
```
private int parameter_id
```
The parameter id.

token_source
```
public SQLTokenManager token_source
```

jj_input_stream
```
SimpleCharStream jj_input_stream
```

token
```
public Token token
```

jj_nt
```
public Token jj_nt
```

jj_ntk
```
private int jj_ntk
```

jj_scanpos
```
private Token jj_scanpos
```

jj_lastpos
```
private Token jj_lastpos
```

jj_la
```
private int jj_la
```

lookingAhead
```
public boolean lookingAhead
```

jj_semLA
```
private boolean jj_semLA
```

jj_gen
```
private int jj_gen
```

jj_la1
```
private final int[] jj_la1
```

jj_la1_0
```
private final int[] jj_la1_0
```

jj_la1_1
```
private final int[] jj_la1_1
```

jj_la1_2
```
private final int[] jj_la1_2
```

jj_la1_3
```
private final int[] jj_la1_3
```

jj_la1_4
```
private final int[] jj_la1_4
```

jj_la1_5
```
private final int[] jj_la1_5
```

jj_la1_6
```
private final int[] jj_la1_6
```

jj_2_rtns
```
private final SQL.JJCalls[] jj_2_rtns
```

jj_rescan
```
private boolean jj_rescan
```

jj_gc
```
private int jj_gc
```

jj_expentries
```
private java.util.Vector jj_expentries
```

jj_expentry
```
private int[] jj_expentry
```

jj_kind
```
private int jj_kind
```

jj_lasttokens
```
private int[] jj_lasttokens
```

jj_endpos
```
private int jj_endpos
```

Constructor Detail

SQL

public SQL(java.io.InputStream stream)

SQL
```
public SQL(java.io.Reader stream)
```

SQL
```
public SQL(SQLTokenManager tm)
```

Method Detail

reset
```
public void reset()
```
Resets the parameter id. This MUST be called before a parser is used to parse a statement.

createSubstitution
```
public ParameterSubstitution createSubstitution(java.lang.String image)
```
Creates and returns a parameter substitution. This is called when the parser comes across a '?' style object. This object is used to mark an expression with a place mark that can be substituted for a value later.

caseCheck
```
public java.lang.String caseCheck(java.lang.String identif)
```
If the parser has been defined as case insensitive then this returns the uppercase version of the given string. NOTE: This actually doesn't do anything because the case is now resolved outside the parser.

expEndParen

public void expEndParen(Expression exp,
                        java.util.Stack stack)

Helper for expression parsing. Called when an end parenthese has been found.

expOperator
```
public void expOperator(Expression exp,
                        java.util.Stack stack,
                        Operator op)
```
Helper for expression parsing. Called when an operator has been read in. This needs to check precedence and add the operator to the expression as appropriate.

flushOperatorStack
```
public void flushOperatorStack(Expression exp,
                               java.util.Stack stack,
                               int precedence)
```
Flush the operator stack until the stack is either empty or the top element is either a "(" or of a precedence lower than the given precedence.

expEnd
```
public void expEnd(Expression exp,
                   java.util.Stack stack)
```
Helper for expression parsing. Called when an entire expression has been read in. We need to empty the stack.

addOperatorToExpression

public void addOperatorToExpression(Expression exp,
                                    Operator op)

Helper for expression parsing. Adds an operator to the given expression.

main

public static void main(java.lang.String[] args)
                 throws ParseException

Throws:: ParseException

Test

public final void Test()
                throws ParseException

Throws:: ParseException

parseExpression

public final Expression parseExpression()
                                 throws ParseException

Throws:: ParseException

Statement

public final StatementTree Statement()
                              throws ParseException

Throws:: ParseException

Create

public final StatementTree Create()
                           throws ParseException

Throws:: ParseException

Drop

public final StatementTree Drop()
                         throws ParseException

Throws:: ParseException

Select

public final StatementTree Select()
                           throws ParseException

Throws:: ParseException

Update

public final StatementTree Update()
                           throws ParseException

Throws:: ParseException

Alter

public final StatementTree Alter()
                          throws ParseException

Throws:: ParseException

AlterTable

public final StatementTree AlterTable()
                               throws ParseException

Throws:: ParseException

Compact

public final StatementTree Compact()
                            throws ParseException

Throws:: ParseException

CreateTable

public final StatementTree CreateTable()
                                throws ParseException

Throws:: ParseException

CreateTrigger

public final StatementTree CreateTrigger()
                                  throws ParseException

Throws:: ParseException

DropTrigger

public final StatementTree DropTrigger()
                                throws ParseException

Throws:: ParseException

CreateFunction

public final StatementTree CreateFunction()
                                   throws ParseException

Throws:: ParseException

DropFunction

public final StatementTree DropFunction()
                                 throws ParseException

Throws:: ParseException

CreateSchema

public final StatementTree CreateSchema()
                                 throws ParseException

Throws:: ParseException

DropSchema

public final StatementTree DropSchema()
                               throws ParseException

Throws:: ParseException

CreateView

public final StatementTree CreateView()
                               throws ParseException

Throws:: ParseException

DropView

public final StatementTree DropView()
                             throws ParseException

Throws:: ParseException

CreateIndex

public final StatementTree CreateIndex()
                                throws ParseException

Throws:: ParseException

DropTable

public final StatementTree DropTable()
                              throws ParseException

Throws:: ParseException

DropIndex

public final StatementTree DropIndex()
                              throws ParseException

Throws:: ParseException

Call

public final StatementTree Call()
                         throws ParseException

Throws:: ParseException

CreateSequence

public final StatementTree CreateSequence()
                                   throws ParseException

Throws:: ParseException

DropSequence

public final StatementTree DropSequence()
                                 throws ParseException

Throws:: ParseException

CreateUser

public final StatementTree CreateUser()
                               throws ParseException

Throws:: ParseException

AlterUser

public final StatementTree AlterUser()
                              throws ParseException

Throws:: ParseException

DropUser

public final StatementTree DropUser()
                             throws ParseException

Throws:: ParseException

UserManagerCommand

public final void UserManagerCommand(StatementTree cmd)
                              throws ParseException

Throws:: ParseException

Delete

public final StatementTree Delete()
                           throws ParseException

Throws:: ParseException

Insert

public final StatementTree Insert()
                           throws ParseException

Throws:: ParseException

Describe

public final StatementTree Describe()
                             throws ParseException

Throws:: ParseException

Show

public final StatementTree Show()
                         throws ParseException

Throws:: ParseException

Grant

public final StatementTree Grant()
                          throws ParseException

Throws:: ParseException

Revoke

public final StatementTree Revoke()
                           throws ParseException

Throws:: ParseException

CompleteTransaction

public final StatementTree CompleteTransaction()
                                        throws ParseException

Throws:: ParseException

Set

public final StatementTree Set()
                        throws ParseException

Throws:: ParseException

ShutDown

public final StatementTree ShutDown()
                             throws ParseException

Throws:: ParseException

TriggerType

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

Throws:: ParseException

BeforeOrAfter

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

Throws:: ParseException

TriggerTypes

public final void TriggerTypes(java.util.ArrayList list)
                        throws ParseException

Throws:: ParseException

PrivObject

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

Throws:: ParseException

PrivList

public final java.util.ArrayList PrivList(java.util.ArrayList list)
                                   throws ParseException

Throws:: ParseException

PrivListItem

public final void PrivListItem(java.util.ArrayList list)
                        throws ParseException

Throws:: ParseException

GetTableSelectExpression

public final TableSelectExpression GetTableSelectExpression()
                                                     throws ParseException

Throws:: ParseException

GetAlterTableAction

public final AlterTableAction GetAlterTableAction()
                                           throws ParseException

Throws:: ParseException

InsertElement

public final java.lang.Object InsertElement()
                                     throws ParseException

Throws:: ParseException

InsertExpressionList

public final java.util.ArrayList InsertExpressionList()
                                               throws ParseException

Throws:: ParseException

InsertDataList

public final void InsertDataList(java.util.ArrayList data_list)
                          throws ParseException

Throws:: ParseException

SetQuantifier

public final boolean SetQuantifier()
                            throws ParseException

Throws:: ParseException

SelectColumnList

public final void SelectColumnList(java.util.ArrayList list)
                            throws ParseException

Throws:: ParseException

SelectColumn

public final SelectColumn SelectColumn()
                                throws ParseException

Throws:: ParseException

SelectGroupByList

public final void SelectGroupByList(java.util.ArrayList list)
                             throws ParseException

Throws:: ParseException

GroupMaxColumn
```
public final Variable GroupMaxColumn()
                              throws ParseException
```
NOTE: This is an extension, allows for us to specify a column to return the max value for each row representing a group.

Throws:

ParseException

SelectOrderByList

public final void SelectOrderByList(java.util.ArrayList list)
                             throws ParseException

Throws:: ParseException

OrderingSpec

public final boolean OrderingSpec()
                           throws ParseException

Throws:: ParseException

TableDeclaration

public final void TableDeclaration(FromClause from_clause)
                            throws ParseException

Throws:: ParseException

SelectTableList

public final void SelectTableList(FromClause from_clause)
                           throws ParseException

Throws:: ParseException

FromClauseJoin

public final void FromClauseJoin(FromClause from_clause)
                          throws ParseException

Throws:: ParseException

ProcParameterList

public final void ProcParameterList(java.util.ArrayList decl_names,
                                    java.util.ArrayList decl_types)
                             throws ParseException

Throws:: ParseException

AssignmentList

public final void AssignmentList(java.util.ArrayList assignment_list)
                          throws ParseException

Throws:: ParseException

ColumnDeclarationList

public final void ColumnDeclarationList(java.util.ArrayList column_list,
                                        java.util.ArrayList constraint_list)
                                 throws ParseException

Throws:: ParseException

ColumnOrConstraintDefinition

public final void ColumnOrConstraintDefinition(java.util.ArrayList column_list,
                                               java.util.ArrayList constraint_list)
                                        throws ParseException

Throws:: ParseException

ColumnDefinition

public final ColumnDef ColumnDefinition()
                                 throws ParseException

Throws:: ParseException

ColumnConstraint

public final void ColumnConstraint(ColumnDef column)
                            throws ParseException

Throws:: ParseException

GetCollateStrength

public final int GetCollateStrength()
                             throws ParseException

Throws:: ParseException

GetCollateDecomposition

public final int GetCollateDecomposition()
                                  throws ParseException

Throws:: ParseException

GetStringSQLType

public final int GetStringSQLType()
                           throws ParseException

Throws:: ParseException

GetNumericSQLType

public final int GetNumericSQLType()
                            throws ParseException

Throws:: ParseException

GetBooleanSQLType

public final int GetBooleanSQLType()
                            throws ParseException

Throws:: ParseException

GetDateSQLType

public final int GetDateSQLType()
                         throws ParseException

Throws:: ParseException

GetBinarySQLType

public final int GetBinarySQLType()
                           throws ParseException

Throws:: ParseException

GetTType

public final TType GetTType()
                     throws ParseException

Throws:: ParseException

ColumnDataType

public final void ColumnDataType(ColumnDef column)
                          throws ParseException

Throws:: ParseException

TableConstraintDefinition

public final ConstraintDef TableConstraintDefinition()
                                              throws ParseException

Throws:: ParseException

ReferentialTrigger

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

Throws:: ParseException

ConstraintAttributes

public final void ConstraintAttributes(ConstraintDef constraint)
                                throws ParseException

Throws:: ParseException

BasicColumnList

public final java.util.ArrayList BasicColumnList(java.util.ArrayList list)
                                          throws ParseException

Throws:: ParseException

UserNameList

public final java.util.ArrayList UserNameList(java.util.ArrayList list)
                                       throws ParseException

Throws:: ParseException

ConditionsExpression

public final void ConditionsExpression(SearchExpression se)
                                throws ParseException

Throws:: ParseException

ExpressionTest

public final Expression ExpressionTest()
                                throws ParseException

Throws:: ParseException

DoExpression

public final Expression DoExpression()
                              throws ParseException

Throws:: ParseException

DoNonBooleanExpression

public final Expression DoNonBooleanExpression()
                                        throws ParseException

Throws:: ParseException

expression

public final void expression(Expression exp,
                             java.util.Stack stack)
                      throws ParseException

Parse an expression.

Throws:: ParseException

nonBooleanExpression

public final void nonBooleanExpression(Expression exp,
                                       java.util.Stack stack)
                                throws ParseException

Parses a non-boolean expression.

Throws:: ParseException

OpPart

public final void OpPart(Expression exp,
                         java.util.Stack stack)
                  throws ParseException

Throws:: ParseException

Operand

public final void Operand(Expression exp,
                          java.util.Stack stack)
                   throws ParseException

Throws:: ParseException

SubQueryExpression

public final void SubQueryExpression(Expression exp,
                                     java.util.Stack stack)
                              throws ParseException

Throws:: ParseException

PositiveIntegerConstant

public final int PositiveIntegerConstant()
                                  throws ParseException

Throws:: ParseException

SubQueryOperator

public final void SubQueryOperator(Expression exp,
                                   java.util.Stack stack)
                            throws ParseException

Throws:: ParseException

BetweenPredicate

public final void BetweenPredicate(Expression exp,
                                   java.util.Stack stack)
                            throws ParseException

Throws:: ParseException

BooleanOperator

public final void BooleanOperator(Expression exp,
                                  java.util.Stack stack)
                           throws ParseException

Throws:: ParseException

NumericOperator

public final void NumericOperator(Expression exp,
                                  java.util.Stack stack)
                           throws ParseException

Throws:: ParseException

StringOperator

public final void StringOperator(Expression exp,
                                 java.util.Stack stack)
                          throws ParseException

Throws:: ParseException

GetBooleanOperator

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

Throws:: ParseException

GetSubQueryBooleanOperator

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

Throws:: ParseException

GetNumericOperator

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

Throws:: ParseException

GetStringOperator

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

Throws:: ParseException

FunctionIdentifier

public final Token FunctionIdentifier()
                               throws ParseException

Throws:: ParseException

Function

public final FunctionDef Function()
                           throws ParseException

Throws:: ParseException

JavaInstantiation

public final FunctionDef JavaInstantiation()
                                    throws ParseException

Throws:: ParseException

FunctionParams

public final Expression[] FunctionParams()
                                  throws ParseException

Throws:: ParseException

ExpressionList

public final Expression[] ExpressionList()
                                  throws ParseException

Throws:: ParseException

GetComposite

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

Throws:: ParseException

TableName

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

Throws:: ParseException

SequenceName

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

Throws:: ParseException

TriggerName

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

Throws:: ParseException

IndexName

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

Throws:: ParseException

UserName

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

Throws:: ParseException

SchemaName

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

Throws:: ParseException

ConstraintName

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

Throws:: ParseException

ColumnName

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

Throws:: ParseException

ColumnNameVariable

public final Variable ColumnNameVariable()
                                  throws ParseException

Throws:: ParseException

TableAliasName

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

Throws:: ParseException

ProcedureName

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

Throws:: ParseException

FunctionName

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

Throws:: ParseException

ProcArgumentName

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

Throws:: ParseException

SQLIdentifier

public final Token SQLIdentifier()
                          throws ParseException

Throws:: ParseException

jj_2_1

private final boolean jj_2_1(int xla)

jj_2_2

private final boolean jj_2_2(int xla)

jj_2_3

private final boolean jj_2_3(int xla)

jj_2_4

private final boolean jj_2_4(int xla)

jj_2_5

private final boolean jj_2_5(int xla)

jj_2_6

private final boolean jj_2_6(int xla)

jj_2_7

private final boolean jj_2_7(int xla)

jj_2_8

private final boolean jj_2_8(int xla)

jj_2_9

private final boolean jj_2_9(int xla)

jj_2_10

private final boolean jj_2_10(int xla)

jj_2_11

private final boolean jj_2_11(int xla)

jj_2_12

private final boolean jj_2_12(int xla)

jj_2_13

private final boolean jj_2_13(int xla)

jj_2_14

private final boolean jj_2_14(int xla)

jj_2_15

private final boolean jj_2_15(int xla)

jj_2_16

private final boolean jj_2_16(int xla)

jj_2_17

private final boolean jj_2_17(int xla)

jj_3R_137
```
private final boolean jj_3R_137()
```

jj_3R_36
```
private final boolean jj_3R_36()
```

jj_3R_130
```
private final boolean jj_3R_130()
```

jj_3R_120
```
private final boolean jj_3R_120()
```

jj_3R_55
```
private final boolean jj_3R_55()
```

jj_3R_20
```
private final boolean jj_3R_20()
```

jj_3R_136
```
private final boolean jj_3R_136()
```

jj_3R_19
```
private final boolean jj_3R_19()
```

jj_3_11
```
private final boolean jj_3_11()
```

jj_3R_122
```
private final boolean jj_3R_122()
```

jj_3R_90
```
private final boolean jj_3R_90()
```

jj_3R_18
```
private final boolean jj_3R_18()
```

jj_3R_63
```
private final boolean jj_3R_63()
```

jj_3R_121
```
private final boolean jj_3R_121()
```

jj_3R_29
```
private final boolean jj_3R_29()
```

jj_3R_119
```
private final boolean jj_3R_119()
```

jj_3R_28
```
private final boolean jj_3R_28()
```

jj_3R_87
```
private final boolean jj_3R_87()
```

jj_3R_54
```
private final boolean jj_3R_54()
```

jj_3R_132
```
private final boolean jj_3R_132()
```

jj_3_9
```
private final boolean jj_3_9()
```

jj_3R_135
```
private final boolean jj_3R_135()
```

jj_3R_129
```
private final boolean jj_3R_129()
```

jj_3_10
```
private final boolean jj_3_10()
```

jj_3R_118
```
private final boolean jj_3R_118()
```

jj_3_6
```
private final boolean jj_3_6()
```

jj_3R_85
```
private final boolean jj_3R_85()
```

jj_3R_48
```
private final boolean jj_3R_48()
```

jj_3R_126
```
private final boolean jj_3R_126()
```

jj_3R_83
```
private final boolean jj_3R_83()
```

jj_3_15
```
private final boolean jj_3_15()
```

jj_3R_30
```
private final boolean jj_3R_30()
```

jj_3R_53
```
private final boolean jj_3R_53()
```

jj_3R_25
```
private final boolean jj_3R_25()
```

jj_3R_134
```
private final boolean jj_3R_134()
```

jj_3R_131
```
private final boolean jj_3R_131()
```

jj_3R_117
```
private final boolean jj_3R_117()
```

jj_3R_128
```
private final boolean jj_3R_128()
```

jj_3R_82
```
private final boolean jj_3R_82()
```

jj_3R_127
```
private final boolean jj_3R_127()
```

jj_3R_52
```
private final boolean jj_3R_52()
```

jj_3R_31
```
private final boolean jj_3R_31()
```

jj_3R_98
```
private final boolean jj_3R_98()
```

jj_3_17
```
private final boolean jj_3_17()
```

jj_3R_86
```
private final boolean jj_3R_86()
```

jj_3R_116
```
private final boolean jj_3R_116()
```

jj_3R_51
```
private final boolean jj_3R_51()
```

jj_3R_91
```
private final boolean jj_3R_91()
```

jj_3R_125
```
private final boolean jj_3R_125()
```

jj_3R_115
```
private final boolean jj_3R_115()
```

jj_3R_104
```
private final boolean jj_3R_104()
```

jj_3R_50
```
private final boolean jj_3R_50()
```

jj_3_5
```
private final boolean jj_3_5()
```

jj_3_4
```
private final boolean jj_3_4()
```

jj_3R_49
```
private final boolean jj_3R_49()
```

jj_3R_26
```
private final boolean jj_3R_26()
```

jj_3R_114
```
private final boolean jj_3R_114()
```

jj_3R_124
```
private final boolean jj_3R_124()
```

jj_3R_88
```
private final boolean jj_3R_88()
```

jj_3R_27
```
private final boolean jj_3R_27()
```

jj_3R_106
```
private final boolean jj_3R_106()
```

jj_3R_103
```
private final boolean jj_3R_103()
```

jj_3R_94
```
private final boolean jj_3R_94()
```

jj_3R_113
```
private final boolean jj_3R_113()
```

jj_3R_123
```
private final boolean jj_3R_123()
```

jj_3R_58
```
private final boolean jj_3R_58()
```

jj_3R_102
```
private final boolean jj_3R_102()
```

jj_3R_89
```
private final boolean jj_3R_89()
```

jj_3R_93
```
private final boolean jj_3R_93()
```

jj_3R_112
```
private final boolean jj_3R_112()
```

jj_3R_101
```
private final boolean jj_3R_101()
```

jj_3R_60
```
private final boolean jj_3R_60()
```

jj_3R_97
```
private final boolean jj_3R_97()
```

jj_3R_80
```
private final boolean jj_3R_80()
```

jj_3R_57
```
private final boolean jj_3R_57()
```

jj_3R_64
```
private final boolean jj_3R_64()
```

jj_3R_79
```
private final boolean jj_3R_79()
```

jj_3R_78
```
private final boolean jj_3R_78()
```

jj_3R_77
```
private final boolean jj_3R_77()
```

jj_3R_76
```
private final boolean jj_3R_76()
```

jj_3R_95
```
private final boolean jj_3R_95()
```

jj_3R_92
```
private final boolean jj_3R_92()
```

jj_3R_96
```
private final boolean jj_3R_96()
```

jj_3R_75
```
private final boolean jj_3R_75()
```

jj_3R_35
```
private final boolean jj_3R_35()
```

jj_3R_59
```
private final boolean jj_3R_59()
```

jj_3R_34
```
private final boolean jj_3R_34()
```

jj_3R_56
```
private final boolean jj_3R_56()
```

jj_3R_33
```
private final boolean jj_3R_33()
```

jj_3R_65
```
private final boolean jj_3R_65()
```

jj_3R_32
```
private final boolean jj_3R_32()
```

jj_3R_100
```
private final boolean jj_3R_100()
```

jj_3R_46
```
private final boolean jj_3R_46()
```

jj_3_3
```
private final boolean jj_3_3()
```

jj_3R_17
```
private final boolean jj_3R_17()
```

jj_3_2
```
private final boolean jj_3_2()
```

jj_3R_74
```
private final boolean jj_3R_74()
```

jj_3R_110
```
private final boolean jj_3R_110()
```

jj_3R_108
```
private final boolean jj_3R_108()
```

jj_3R_73
```
private final boolean jj_3R_73()
```

jj_3R_111
```
private final boolean jj_3R_111()
```

jj_3R_72
```
private final boolean jj_3R_72()
```

jj_3R_84
```
private final boolean jj_3R_84()
```

jj_3R_45
```
private final boolean jj_3R_45()
```

jj_3R_44
```
private final boolean jj_3R_44()
```

jj_3R_109
```
private final boolean jj_3R_109()
```

jj_3R_107
```
private final boolean jj_3R_107()
```

jj_3_16
```
private final boolean jj_3_16()
```

jj_3R_105
```
private final boolean jj_3R_105()
```

jj_3R_99
```
private final boolean jj_3R_99()
```

jj_3R_71
```
private final boolean jj_3R_71()
```

jj_3R_81
```
private final boolean jj_3R_81()
```

jj_3R_70
```
private final boolean jj_3R_70()
```

jj_3R_69
```
private final boolean jj_3R_69()
```

jj_3R_43
```
private final boolean jj_3R_43()
```

jj_3R_38
```
private final boolean jj_3R_38()
```

jj_3R_68
```
private final boolean jj_3R_68()
```

jj_3R_67
```
private final boolean jj_3R_67()
```

jj_3R_66
```
private final boolean jj_3R_66()
```

jj_3R_42
```
private final boolean jj_3R_42()
```

jj_3_8
```
private final boolean jj_3_8()
```

jj_3_14
```
private final boolean jj_3_14()
```

jj_3R_39
```
private final boolean jj_3R_39()
```

jj_3_13
```
private final boolean jj_3_13()
```

jj_3_1
```
private final boolean jj_3_1()
```

jj_3R_41
```
private final boolean jj_3R_41()
```

jj_3R_40
```
private final boolean jj_3R_40()
```

jj_3R_21
```
private final boolean jj_3R_21()
```

jj_3R_47
```
private final boolean jj_3R_47()
```

jj_3_7
```
private final boolean jj_3_7()
```

jj_3R_62
```
private final boolean jj_3R_62()
```

jj_3R_37
```
private final boolean jj_3R_37()
```

jj_3R_24
```
private final boolean jj_3R_24()
```

jj_3_12
```
private final boolean jj_3_12()
```

jj_3R_23
```
private final boolean jj_3R_23()
```

jj_3R_22
```
private final boolean jj_3R_22()
```

jj_3R_61
```
private final boolean jj_3R_61()
```

jj_3R_138
```
private final boolean jj_3R_138()
```

jj_3R_133
```
private final boolean jj_3R_133()
```

ReInit

public void ReInit(java.io.InputStream stream)

ReInit

public void ReInit(java.io.Reader stream)

ReInit

public void ReInit(SQLTokenManager tm)

jj_consume_token

private final Token jj_consume_token(int kind)
                              throws ParseException

Throws:: ParseException

jj_scan_token

private final boolean jj_scan_token(int kind)

getNextToken
```
public final Token getNextToken()
```

getToken

public final Token getToken(int index)

jj_ntk
```
private final int jj_ntk()
```

jj_add_error_token

private void jj_add_error_token(int kind,
                                int pos)

generateParseException

public final ParseException generateParseException()

enable_tracing
```
public final void enable_tracing()
```

disable_tracing
```
public final void disable_tracing()
```

jj_rescan_token
```
private final void jj_rescan_token()
```

jj_save

private final void jj_save(int index,
                           int xla)

Constructor	Description
`SQL(SQLTokenManager tm)`
`SQL(java.io.InputStream stream)`
`SQL(java.io.Reader stream)`

Class SQL

Nested Class Summary

Field Summary

Fields inherited from interface com.mckoi.database.sql.SQLConstants

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

case_insensitive_identifiers

parameter_id

token_source

jj_input_stream

token

jj_nt

jj_ntk

jj_scanpos

jj_lastpos

jj_la

lookingAhead

jj_semLA

jj_gen

jj_la1

jj_la1_0

jj_la1_1

jj_la1_2

jj_la1_3

jj_la1_4

jj_la1_5

jj_la1_6

jj_2_rtns

jj_rescan

jj_gc

jj_expentries

jj_expentry

jj_kind

jj_lasttokens

jj_endpos

Constructor Detail

SQL

SQL

SQL

Method Detail

reset

createSubstitution

caseCheck

expEndParen

expOperator

flushOperatorStack

expEnd

addOperatorToExpression

main

Test

parseExpression

Statement

Create

Drop

Select

Update

Alter

AlterTable

Compact

CreateTable

CreateTrigger

DropTrigger

CreateFunction

DropFunction

CreateSchema

DropSchema

CreateView

DropView

CreateIndex

DropTable

DropIndex

Call

CreateSequence

DropSequence

CreateUser

AlterUser

DropUser

UserManagerCommand