BNF for sqlgrammar.jj

<DEFAULT> SKIP : {
" "
| "\t"
| "\n"
| "\r"
}

   

<DEFAULT> MORE : {
"/*" : IN_BRACKETED_COMMENT
}

   

<IN_BRACKETED_COMMENT> MORE : {
"/*" : IN_NESTED_BRACKETED_COMMENT
}

   

<IN_BRACKETED_COMMENT> SKIP : {
"*/" : DEFAULT
}

   

<IN_NESTED_BRACKETED_COMMENT> MORE : {
"/*" : {
}

   

<IN_NESTED_BRACKETED_COMMENT> MORE : {
"*/" : {
}

   

<IN_BRACKETED_COMMENT,IN_NESTED_BRACKETED_COMMENT> MORE : {
<~[]>
}

   

<DEFAULT> SKIP : {
"--" : IN_COMMENT
}

   

<IN_COMMENT> SKIP : {
" "
| "\t"
}

   

/*
	Check if the comment characters -- are followed by DERBY-PROPERTIES
	token. 

	If yes, then this comment is providing user-supplied optimizer 
	overrides. There should be keyname=value [,keyname=value] pairs
	after -- DERBY-PROPERTIES otherwise throw an exception. These
	optimier overrides should be used in correct context only, 
	otherwise, the parser will throw an exception.

	If this comment does not start with DERBY-PROPERTOIES, then it is 
	just a regular comment. Skip the comment and move on to the next line.
 */

<IN_COMMENT> MORE [IGNORE_CASE] : {
"D" : LOOKFOR_DE
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_D: ~["D"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DE> MORE [IGNORE_CASE] : {
"E" : LOOKFOR_DER
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DE: ~["E"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DER> MORE [IGNORE_CASE] : {
"R" : LOOKFOR_DERB
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DER: ~["R"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERB> MORE [IGNORE_CASE] : {
"B" : LOOKFOR_DERBY
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERB: ~["B"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBY> MORE [IGNORE_CASE] : {
"Y" : LOOKFOR_DERBYDASH
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBY: ~["Y"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASH> MORE [IGNORE_CASE] : {
"-" : LOOKFOR_DERBYDASHP
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASH: ~["-"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHP> MORE [IGNORE_CASE] : {
"P" : LOOKFOR_DERBYDASHPR
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHP: ~["P"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPR> MORE [IGNORE_CASE] : {
"R" : LOOKFOR_DERBYDASHPRO
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPR: ~["R"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPRO> MORE [IGNORE_CASE] : {
"O" : LOOKFOR_DERBYDASHPROP
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPRO: ~["O"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROP> MORE [IGNORE_CASE] : {
"P" : LOOKFOR_DERBYDASHPROPE
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROP: ~["P"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPE> MORE [IGNORE_CASE] : {
"E" : LOOKFOR_DERBYDASHPROPER
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROPE: ~["E"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPER> MORE [IGNORE_CASE] : {
"R" : LOOKFOR_DERBYDASHPROPERT
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROPER: ~["R"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPERT> MORE [IGNORE_CASE] : {
"T" : LOOKFOR_DERBYDASHPROPERTI
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROPERT: ~["T"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPERTI> MORE [IGNORE_CASE] : {
"I" : LOOKFOR_DERBYDASHPROPERTIE
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROPERTI: ~["I"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPERTIE> MORE [IGNORE_CASE] : {
"E" : LOOKFOR_DERBYDASHPROPERTIES
| <("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_DERBYDASHPROPERTIE: ~["E"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<LOOKFOR_DERBYDASHPROPERTIES> TOKEN [IGNORE_CASE] : {
<DERBYDASHPROPERTIES: "DERBYDASHPROPERTIES">
}

   

//once we find comment starting with -- DERBY-PROPERTIES, we want to switch 
//from SKIP mode to the TOKEN mode in the parser so the rest of the characters 
//on the comment line can be treated as part of one big token so we can get 
//keyname=value pairs from that token. The reason for treating them as one big
//token is that the existing code in parser allows newline characters between
//individual token but with optimizer overrides, all the properties have to
//be specified on the -- DERBY-PROPERTIES comment line. 

<LOOKFOR_DERBYDASHPROPERTIES> TOKEN [IGNORE_CASE] : {
"S" : PROPERTIES_LIST
}

   

//We found -- DERBY-PROPERTIE? where ? is a character other than S
//and hence we should the rest of the characters on this line as 
//a regular comment

<LOOKFOR_DERBYDASHPROPERTIES> SKIP : {
<("\n" | "\r" | "\r\n")?> : DEFAULT
| <NOT_PROPERTIES: ~["S","s"]> : IT_IS_NOT_DERBYPROPERTIES_COMMENT
}

   

<IT_IS_NOT_DERBYPROPERTIES_COMMENT> SKIP : {
<SINGLE_LINE_SQLCOMMENT: (~["\n","\r"])* ("\n" | "\r" | "\r\n")?> : DEFAULT
}

   

//found -- DERBY-PROPERTIES. Treat rest of the characters on the line
//as one big token and then fetch keyname=value pairs from that token.

<PROPERTIES_LIST> TOKEN : {
<CHECK_PROPERTIES: (~["\n","\r"])* ("\n" | "\r" | "\r\n")?> : DEFAULT
}

   

/*
	This list should contain only and all SQL92 keywords that are reserved.
	Reserved keywords can be used as identifiers in the language only
	as delimited identifiers.
 */
/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
 *	      or nonReservedKeyword() as well!
 */

<DEFAULT> TOKEN [IGNORE_CASE] : {
<ADD: "add">
| <ALL: "all">
| <ALLOCATE: "allocate">
| <ALTER: "alter">
| <AND: "and">
| <ANY: "any">
| <ARE: "are">
| <AS: "as">
| <ASC: "asc">
| <ASSERTION: "assertion">
| <AT: "at">
| <AUTHORIZATION: "authorization">
| <AVG: "avg">
| <BEGIN: "begin">
| <BETWEEN: "between">
| <BINARY: "binary">
| <BIT: "bit">
| <BOTH: "both">
| <BY: "by">
| <CASCADE: "cascade">
| <CASCADED: "cascaded">
| <CASE: "case">
| <CAST: "cast">
| <CHAR: "char">
| <CHARACTER: "character">
| <CHARACTER_LENGTH: "character_length">
| <CHECK: "check">
| <CLOSE: "close">
| <COALESCE: "coalesce">
| <COLLATE: "collate">
| <COLLATION: "collation">
| <COLUMN: "column">
| <COMMIT: "commit">
| <CONNECT: "connect">
| <CONNECTION: "connection">
| <CONSTRAINT: "constraint">
| <CONSTRAINTS: "constraints">
| <CONTINUE: "continue">
| <CONVERT: "convert">
| <CORRESPONDING: "corresponding">
| <COUNT: "count">
| <CREATE: "create">
| <CROSS: "cross">
| <CURRENT: "current">
| <CURRENT_DATE: "current_date">
| <CURRENT_TIME: "current_time">
| <CURRENT_TIMESTAMP: "current_timestamp">
| <CURRENT_USER: "current_user">
| <CURSOR: "cursor">
| <D: "d">
| <DEALLOCATE: "deallocate">
| <DEC: "dec">
| <DECIMAL: "decimal">
| <DECLARE: "declare">
| <_DEFAULT: "default">
| <DEFERRABLE: "deferrable">
| <DEFERRED: "deferred">
| <DELETE: "delete">
| <DESC: "desc">
| <DESCRIBE: "describe">
| <DIAGNOSTICS: "diagnostics">
| <DISCONNECT: "disconnect">
| <DISTINCT: "distinct">
| <DOUBLE: "double">
| <DROP: "drop">
| <ELSE: "else">
| <END: "end">
| <ENDEXEC: "end-exec">
| <ESCAPE: "escape">
| <EXCEPT: "except">
| <EXCEPTION: "exception">
| <EXEC: "exec">
| <EXECUTE: "execute">
| <EXISTS: "exists">
| <EXTERNAL: "external">
| <FALSE: "false">
| <FETCH: "fetch">
| <FIRST: "first">
| <FLOAT: "float">
| <FOR: "for">
| <FOREIGN: "foreign">
| <FOUND: "found">
| <FROM: "from">
| <FULL: "full">
| <FUNCTION: "function">
| <GET: "get">
| <GLOBAL: "global">
| <GO: "go">
| <GOTO: "goto">
| <GRANT: "grant">
| <GROUP: "group">
| <HAVING: "having">
| <HOUR: "hour">
| <IDENTITY: "identity">
| <IMMEDIATE: "immediate">
| <IN: "in">
| <INDICATOR: "indicator">
| <INITIALLY: "initially">
| <INNER: "inner">
| <INPUT: "input">
| <INSENSITIVE: "insensitive">
| <INSERT: "insert">
| <INT: "int">
| <INTEGER: "integer">
| <INTERSECT: "intersect">
| <INTO: "into">
| <IS: "is">
| <ISOLATION: "isolation">
| <JOIN: "join">
| <KEY: "key">
| <LAST: "last">
| <LEADING: "leading">
| <LEFT: "left">
| <LIKE: "like">
| <LOWER: "lower">
| <MATCH: "match">
| <MAX: "max">
| <MIN: "min">
| <MINUTE: "minute">
| <MODULE: "module">
| <NATIONAL: "national">
| <NATURAL: "natural">
| <NCHAR: "nchar">
| <NEXT: "next">
| <NO: "no">
| <NOT: "not">
| <NULL: "null">
| <NULLIF: "nullif">
| <NUMERIC: "numeric">
| <OF: "of">
| <ON: "on">
| <ONLY: "only">
| <OPEN: "open">
| <OPTION: "option">
| <OR: "or">
| <ORDER: "order">
| <OUTER: "outer">
| <OUTPUT: "output">
| <OVERLAPS: "overlaps">
| <PAD: "pad">
| <PARTIAL: "partial">
| <PREPARE: "prepare">
| <PRESERVE: "preserve">
| <PRIMARY: "primary">
| <PRIOR: "prior">
| <PRIVILEGES: "privileges">
| <PROCEDURE: "procedure">
| <PUBLIC: "public">
| <READ: "read">
| <REAL: "real">
| <REFERENCES: "references">
| <RELATIVE: "relative">
| <RESTRICT: "restrict">
| <REVOKE: "revoke">
| <RIGHT: "right">
| <ROLLBACK: "rollback">
| <ROWS: "rows">
| <SCHEMA: "schema">
| <SCROLL: "scroll">
| <SECOND: "second">
| <SELECT: "select">
| <SESSION_USER: "session_user">
| <SET: "set">
| <SMALLINT: "smallint">
| <SOME: "some">
| <SPACE: "space">
| <SQL: "sql">
| <SQLCODE: "sqlcode">
| <SQLERROR: "sqlerror">
| <SQLSTATE: "sqlstate">
| <SUBSTRING: "substring">
| <SUM: "sum">
| <SYSTEM_USER: "system_user">
| <T: "t">
| <TABLE: "table">
| <TEMPORARY: "temporary">
| <TIMEZONE_HOUR: "timezone_hour">
| <TIMEZONE_MINUTE: "timezone_minute">
| <TO: "to">
| <TRANSACTION: "transaction">
| <TRANSLATE: "translate">
| <TRANSLATION: "translation">
| <TRAILING: "trailing">
| <TRIM: "trim">
| <TRUE: "true">
| <TS: "ts">
| <UNION: "union">
| <UNIQUE: "unique">
| <UNKNOWN: "unknown">
| <UPDATE: "update">
| <UPPER: "upper">
| <USER: "user">
| <USING: "using">
| <VALUE: "value">
| <VALUES: "values">
| <VARBINARY: "varbinary">
| <VARCHAR: "varchar">
| <VARYING: "varying">
| <VIEW: "view">
| <WHENEVER: "whenever">
| <WHERE: "where">
| <WINDOW: "window">
| <WITH: "with">
| <WORK: "work">
| <WRITE: "write">
| <YEAR: "year">
}

   

/*
	This list should contain only and all SQL92 keywords that are non-reserved.
	Non-reserved keywords can be used as identifiers in the language.
	To make that happen, the individual tokens have to be repeated in
	the nonReservedKeyword() rule -- unless there's some other JavaCC shorthand?

	NOTE: I've commented out most of these because we won't be using them
	right away and the grammar is taking forever to process.
 */
/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
 *	      or nonReservedKeyword() as well!
 */

<DEFAULT> TOKEN [IGNORE_CASE] : {
<ABS: "abs">
| <ABSVAL: "absval">
| <ACTION: "action">
| <ALWAYS: "always">
| <BLOB: "blob">
| <C: "c">
| <CALLED: "called">
| <CLOB: "clob">
| <COBOL: "cobol">
| <COMMITTED: "committed">
| <CONCAT: "concat">
| <CONTAINS: "contains">
| <CYCLE: "cycle">
| <DATA: "data">
| <DATE: "date">
| <DAY: "day">
| <DEFINER: "definer">
| <DETERMINISTIC: "deterministic">
| <DYNAMIC: "dynamic">
| <ENFORCED: "enforced">
| <FORTRAN: "fortran">
| <GENERATED: "generated">
| <IDENTITY_VAL_LOCAL: "identity_val_local">
| <INCREMENT: "increment">
| <INITIAL: "initial">
| <INOUT: "inout">
| <INTERVAL: "interval">
| <INVOKER: "invoker">
| <LANGUAGE: "language">
| <LARGE: "large">
| <LENGTH: "length">
| <LEVEL: "level">
| <LIMIT: "limit">
| <LOCKS: "locks">
| <LOCKSIZE: "locksize">
| <LOGGED: "logged">
| <MATCHED: "matched">
| <MAXVALUE: "maxvalue">
| <MERGE: "merge">
| <MINVALUE: "minvalue">
| <MOD: "mod">
| <MODIFIES: "modifies">
| <MODIFY: "modify">
| <MONTH: "month">
| <_MORE: "more">
| <MUMPS: "mumps">
| <NAME: "name">
| <NCLOB: "nclob">
| <NULLABLE: "nullable">
| <NULLS: "nulls">
| <NUMBER: "number">
| <OBJECT: "object">
| <OFFSET: "offset">
| <PASCAL: "pascal">
| <PLI: "pli">
| <PRECISION: "precision">
| <RELEASE: "release">
| <REPEATABLE: "repeatable">
| <RESTART: "restart">
| <RETURNS: "returns">
| <ROLLUP: "rollup">
| <ROW: "row">
| <SAVEPOINT: "savepoint">
| <SCALE: "scale">
| <SECURITY: "security">
| <SERIALIZABLE: "serializable">
| <SQL_TSI_FRAC_SECOND: "sql_tsi_frac_second">
| <SQL_TSI_SECOND: "sql_tsi_second">
| <SQL_TSI_MINUTE: "sql_tsi_minute">
| <SQL_TSI_HOUR: "sql_tsi_hour">
| <SQL_TSI_DAY: "sql_tsi_day">
| <SQL_TSI_WEEK: "sql_tsi_week">
| <SQL_TSI_MONTH: "sql_tsi_month">
| <SQL_TSI_QUARTER: "sql_tsi_quarter">
| <SQL_TSI_YEAR: "sql_tsi_year">
| <START: "start">
| <STATEMENT: "statement">
| <SYNONYM: "synonym">
| <THEN: "then">
| <TIME: "time">
| <TIMESTAMP: "timestamp">
| <TIMESTAMPADD: "timestampadd">
| <TIMESTAMPDIFF: "timestampdiff">
| <TRUNCATE: "truncate">
| <TYPE: "type">
| <UNCOMMITTED: "uncommitted">
| <USAGE: "usage">
| <WHEN: "when">
| <DERBYPLAN: "--derbyplan">
}

   

/*
	The next lists should contain non-SQL92 keywords, and should
	specify whether their keywords are reserved or non-reserved.
	If they are non-reserved, they need to be added to the identifier() rule.

	NOTE: XML, XMLPARSE, XMLSERIALIZE, and XMLEXISTS are considered reserved
	words to comply with the SQL/XML (2003) standard, section 5.1.  Similarly,
	XMLQUERY is a reserved word per SQL/XML (2006).
 */

/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
 *	      or nonReservedKeyword() as well!
 */

<DEFAULT> TOKEN [IGNORE_CASE] : {
<BOOLEAN: "boolean">
| <CALL: "call">
| <CURDATE: "curdate">
| <CURRENT_ROLE: "current_role">
| <CURTIME: "curtime">
| <DATABASE: "database">
| <GET_CURRENT_CONNECTION: "getCurrentConnection">
| <EXPLAIN: "explain">
| <BIGINT: "bigint">
| <LONG: "long">
| <LTRIM: "ltrim">
| <NONE: "none">
| <OVER: "over">
| <ROLE: "role">
| <ROWNUMBER: "row_number">
| <RTRIM: "rtrim">
| <SUBSTR: "substr">
| <XML: "xml">
| <XMLEXISTS: "xmlexists">
| <XMLPARSE: "xmlparse">
| <XMLQUERY: "xmlquery">
| <XMLSERIALIZE: "xmlserialize">
}

   

/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
 *	      or nonReservedKeyword() as well!
 *
 * NOTE: CONTENT, DOCUMENT, STRIP, WHITESPACE and PASSING are considered NON-
 * reserved words to comply with the SQL/XML (2003) standard, section 5.1.
 * Similarly, EMPTY, RETURNING, and SEQUENCE are all considered NON-reserved
 * words per SQL/XML (2006).  PRESERVE is also listed as non-reserved in the
 * SQL/XML spec, but since that word is already reserved, we leave it alone.
 */

<DEFAULT> TOKEN [IGNORE_CASE] : {
<AFTER: "after">
| <AGGREGATE: "aggregate">
| <BEFORE: "before">
| <CLASS: "class">
| <COMPRESS: "compress">
| <CONTENT: "content">
| <CS: "cs">
| <CURSORS: "cursors">
| <DB2SQL: "db2sql">
| <DERBY: "derby">
| <DERBY_JDBC_RESULT_SET: "derby_jdbc_result_set">
| <DEFRAGMENT: "defragment">
| <DIRTY: "dirty">
| <DOCUMENT: "document">
| <EACH: "each">
| <EMPTY: "empty">
| <EXCLUSIVE: "exclusive">
| <FN: "fn">
| <INDEX: "index">
| <INPLACE: "inplace">
| <JAVA: "java">
| <LCASE: "lcase">
| <LOCATE: "locate">
| <LOCK: "lock">
| <MESSAGE_LOCALE: "message_locale">
| <METHOD: "method">
| <MODE: "mode">
| <NEW: "new">
| <NEW_TABLE: "new_table">
| <NVARCHAR: "nvarchar">
| <OJ: "oj">
| <OFF: "off">
| <OLD: "old">
| <OLD_TABLE: "old_table">
| <OUT: "out">
| <PARAMETER: "parameter">
| <PASSING: "passing">
| <PROPERTIES: "properties">
| <PURGE: "purge">
| <READS: "reads">
| <REF: "ref">
| <REFERENCING: "referencing">
| <RENAME: "rename">
| <RESET: "reset">
| <RESULT: "result">
| <RETAIN: "retain">
| <RETURNING: "returning">
| <RR: "rr">
| <RS: "rs">
| <STATISTICS: "statistics">
| <SEQUENCE: "sequence">
| <SEQUENTIAL: "sequential">
| <SETS: "sets">
| <SHARE: "share">
| <SQLID: "sqlid">
| <SPECIFIC: "specific">
| <SQRT: "sqrt">
| <STABILITY: "stability">
| <STRIP: "strip">
| <STYLE: "style">
| <TRIGGER: "trigger">
| <TRUNCATE_END: "truncate_end">
| <UCASE: "ucase">
| <UR: "ur">
| <WHITESPACE: "whitespace">
}

   

<DEFAULT> TOKEN : {
<DOUBLE_QUOTE: "\"">
| <PERCENT: "%">
| <AMPERSAND: "&">
| <QUOTE: "\'">
| <LEFT_BRACE: "{">
| <RIGHT_BRACE: "}">
| <LEFT_PAREN: "(">
| <RIGHT_PAREN: ")">
| <ASTERISK: "*">
| <HASH: "#">
| <PLUS_SIGN: "+">
| <COMMA: ",">
| <MINUS_SIGN: "-">
| <PERIOD: ".">
| <SOLIDUS: "/">
| <COLON: ":">
| <DOUBLE_COLON: "::">
| <SEMICOLON: ";">
| <LESS_THAN_OPERATOR: "<">
| <LESS_THAN_OR_EQUALS_OPERATOR: "<=">
| <EQUALS_OPERATOR: "=">
| <NOT_EQUALS_OPERATOR: "<>">
| <NOT_EQUALS_OPERATOR2: "!=">
| <GREATER_THAN_OPERATOR: ">">
| <GREATER_THAN_OR_EQUALS_OPERATOR: ">=">
| <QUESTION_MARK: "?">
| <UNDERSCORE: "_">
| <VERTICAL_BAR: "|">
| <LEFT_BRACKET: "[">
| <RIGHT_BRACKET: "]">
| <CONCATENATION_OPERATOR: "||">
| <FIELD_REFERENCE: "->">
| <ELLIPSIS: "...">
}

   

<DEFAULT> TOKEN : {
<IDENTIFIER: <LETTER> (<LETTER> | "_" | <DIGIT>)*>
}

   

<DEFAULT> TOKEN : {
<K: "K">
}

   

<DEFAULT> TOKEN : {
<M: "M">
}

   

<DEFAULT> TOKEN : {
<G: "G">
}

   

<DEFAULT> TOKEN : {
<#LETTER: ["a"-"z","A"-"Z","\u00aa","\u00b5","\u00ba","\u00c0"-"\u00d6","\u00d8"-"\u00f6","\u00f8"-"\u01f5","\u01fa"-"\u0217","\u0250"-"\u02a8","\u02b0"-"\u02b8","\u02bb"-"\u02c1","\u02d0"-"\u02d1","\u02e0"-"\u02e4","\u037a","\u0386","\u0388"-"\u038a","\u038c","\u038e"-"\u03a1","\u03a3"-"\u03ce","\u03d0"-"\u03d6","\u03da","\u03dc","\u03de","\u03e0","\u03e2"-"\u03f3","\u0401"-"\u040c","\u040e"-"\u044f","\u0451"-"\u045c","\u045e"-"\u0481","\u0490"-"\u04c4","\u04c7"-"\u04c8","\u04cb"-"\u04cc","\u04d0"-"\u04eb","\u04ee"-"\u04f5","\u04f8"-"\u04f9","\u0531"-"\u0556","\u0559","\u0561"-"\u0587","\u05d0"-"\u05ea","\u05f0"-"\u05f2","\u0621"-"\u063a","\u0640"-"\u064a","\u0671"-"\u06b7","\u06ba"-"\u06be","\u06c0"-"\u06ce","\u06d0"-"\u06d3","\u06d5","\u06e5"-"\u06e6","\u0905"-"\u0939","\u093d","\u0958"-"\u0961","\u0985"-"\u098c","\u098f"-"\u0990","\u0993"-"\u09a8","\u09aa"-"\u09b0","\u09b2","\u09b6"-"\u09b9","\u09dc"-"\u09dd","\u09df"-"\u09e1","\u09f0"-"\u09f1","\u0a05"-"\u0a0a","\u0a0f"-"\u0a10","\u0a13"-"\u0a28","\u0a2a"-"\u0a30","\u0a32"-"\u0a33","\u0a35"-"\u0a36","\u0a38"-"\u0a39","\u0a59"-"\u0a5c","\u0a5e","\u0a72"-"\u0a74","\u0a85"-"\u0a8b","\u0a8d","\u0a8f"-"\u0a91","\u0a93"-"\u0aa8","\u0aaa"-"\u0ab0","\u0ab2"-"\u0ab3","\u0ab5"-"\u0ab9","\u0abd","\u0ae0","\u0b05"-"\u0b0c","\u0b0f"-"\u0b10","\u0b13"-"\u0b28","\u0b2a"-"\u0b30","\u0b32"-"\u0b33","\u0b36"-"\u0b39","\u0b3d","\u0b5c"-"\u0b5d","\u0b5f"-"\u0b61","\u0b85"-"\u0b8a","\u0b8e"-"\u0b90","\u0b92"-"\u0b95","\u0b99"-"\u0b9a","\u0b9c","\u0b9e"-"\u0b9f","\u0ba3"-"\u0ba4","\u0ba8"-"\u0baa","\u0bae"-"\u0bb5","\u0bb7"-"\u0bb9","\u0c05"-"\u0c0c","\u0c0e"-"\u0c10","\u0c12"-"\u0c28","\u0c2a"-"\u0c33","\u0c35"-"\u0c39","\u0c60"-"\u0c61","\u0c85"-"\u0c8c","\u0c8e"-"\u0c90","\u0c92"-"\u0ca8","\u0caa"-"\u0cb3","\u0cb5"-"\u0cb9","\u0cde","\u0ce0"-"\u0ce1","\u0d05"-"\u0d0c","\u0d0e"-"\u0d10","\u0d12"-"\u0d28","\u0d2a"-"\u0d39","\u0d60"-"\u0d61","\u0e01"-"\u0e2e","\u0e30","\u0e32"-"\u0e33","\u0e40"-"\u0e46","\u0e81"-"\u0e82","\u0e84","\u0e87"-"\u0e88","\u0e8a","\u0e8d","\u0e94"-"\u0e97","\u0e99"-"\u0e9f","\u0ea1"-"\u0ea3","\u0ea5","\u0ea7","\u0eaa"-"\u0eab","\u0ead"-"\u0eae","\u0eb0","\u0eb2"-"\u0eb3","\u0ebd","\u0ec0"-"\u0ec4","\u0ec6","\u0edc"-"\u0edd","\u0f40"-"\u0f47","\u0f49"-"\u0f69","\u10a0"-"\u10c5","\u10d0"-"\u10f6","\u1100"-"\u1159","\u115f"-"\u11a2","\u11a8"-"\u11f9","\u1e00"-"\u1e9b","\u1ea0"-"\u1ef9","\u1f00"-"\u1f15","\u1f18"-"\u1f1d","\u1f20"-"\u1f45","\u1f48"-"\u1f4d","\u1f50"-"\u1f57","\u1f59","\u1f5b","\u1f5d","\u1f5f"-"\u1f7d","\u1f80"-"\u1fb4","\u1fb6"-"\u1fbc","\u1fbe","\u1fc2"-"\u1fc4","\u1fc6"-"\u1fcc","\u1fd0"-"\u1fd3","\u1fd6"-"\u1fdb","\u1fe0"-"\u1fec","\u1ff2"-"\u1ff4","\u1ff6"-"\u1ffc","\u207f","\u2102","\u2107","\u210a"-"\u2113","\u2115","\u2118"-"\u211d","\u2124","\u2126","\u2128","\u212a"-"\u2131","\u2133"-"\u2138","\u3005","\u3031"-"\u3035","\u3041"-"\u3094","\u309b"-"\u309e","\u30a1"-"\u30fa","\u30fc"-"\u30fe","\u3105"-"\u312c","\u3131"-"\u318e","\u4e00"-"\u9fa5","\uac00"-"\ud7a3","\uf900"-"\ufa2d","\ufb00"-"\ufb06","\ufb13"-"\ufb17","\ufb1f"-"\ufb28","\ufb2a"-"\ufb36","\ufb38"-"\ufb3c","\ufb3e","\ufb40"-"\ufb41","\ufb43"-"\ufb44","\ufb46"-"\ufbb1","\ufbd3"-"\ufd3d","\ufd50"-"\ufd8f","\ufd92"-"\ufdc7","\ufdf0"-"\ufdfb","\ufe70"-"\ufe72","\ufe74","\ufe76"-"\ufefc","\uff21"-"\uff3a","\uff41"-"\uff5a","\uff66"-"\uffbe","\uffc2"-"\uffc7","\uffca"-"\uffcf","\uffd2"-"\uffd7","\uffda"-"\uffdc"]>
}

   

<DEFAULT> TOKEN : {
<#DIGIT: ["0"-"9","\u0660"-"\u0669","\u06f0"-"\u06f9","\u0966"-"\u096f","\u09e6"-"\u09ef","\u0a66"-"\u0a6f","\u0ae6"-"\u0aef","\u0b66"-"\u0b6f","\u0be7"-"\u0bef","\u0c66"-"\u0c6f","\u0ce6"-"\u0cef","\u0d66"-"\u0d6f","\u0e50"-"\u0e59","\u0ed0"-"\u0ed9","\u0f20"-"\u0f29","\uff10"-"\uff19"]>
}

   

<DEFAULT> TOKEN : {
<DELIMITED_IDENTIFIER: "\"" ("\"\"" | ~["\""])+ "\"">
}

   

<DEFAULT> TOKEN : {
<EXACT_NUMERIC: <UINT> ("." (<UINT>)?)? | "." <UINT>>
| <UINT: (["0"-"9"])+>
| <LENGTH_MODIFIER: <UINT> ["K","M","G","k","m","g"]>
| <STRING: "\'" ("\'\'" | ~["\'"])* "\'">
| <HEX_STRING: ["X","x"] "\'" (["0"-"9","a"-"f","A"-"F"])* "\'">
| <APPROXIMATE_NUMERIC: <EXACT_NUMERIC> ["e","E"] ("+" | "-")? (["0"-"9"])+>
| <INTERVAL_LITERAL: "INTERVAL" "\'" (["+","-"])? <INTERVAL_STRING> <INTERVAL_QUALIFIER>>
| <#INTERVAL_STRING: "\'" (<YEAR_MONTH_LITERAL> | <DAY_TIME_LITERAL>) "\'">
| <#INTERVAL_QUALIFIER: <SINGLE_DATETIME_FIELD> | <START_FIELD> <TO> <END_FIELD>>
| <#SINGLE_DATETIME_FIELD: <NON_SECOND_DATETIME_FIELD> (<LEFT_PAREN> <UINT> <RIGHT_PAREN>)?>
| <#START_FIELD: <NON_SECOND_DATETIME_FIELD> (<LEFT_PAREN> <UINT> <RIGHT_PAREN>)?>
| <#END_FIELD: <NON_SECOND_DATETIME_FIELD>>
| <#NON_SECOND_DATETIME_FIELD: <YEAR> | <MONTH> | <DAY> | <HOUR> | <MINUTE>>
| <#YEAR_MONTH_LITERAL: (<UINT> | <UINT> "-")? <UINT>>
| <#DAY_TIME_LITERAL: <DAY_TIME_INTERVAL> | <TIME_INTERVAL>>
| <#DAY_TIME_INTERVAL: <UINT> (" " <UINT> (":" <UINT> (":" <SECONDS_VALUE>)?)?)?>
| <#SECONDS_VALUE: <UINT> ("." (<UINT>)?)?>
| <#TIME_INTERVAL: <UINT> (":" <UINT> (":" <SECONDS_VALUE>)?)? | <UINT> (":" <SECONDS_VALUE>)? | <SECONDS_VALUE>>
}