Java > Open Source Codes > org > hsqldb > Token


1 /* Copyright (c) 2001-2005, The HSQL Development Group
2  * All rights reserved.
3  *
4  * Redistribution and use in source and binary forms, with or without
5  * modification, are permitted provided that the following conditions are met:
6  *
7  * Redistributions of source code must retain the above copyright notice, this
8  * list of conditions and the following disclaimer.
9  *
10  * Redistributions in binary form must reproduce the above copyright notice,
11  * this list of conditions and the following disclaimer in the documentation
12  * and/or other materials provided with the distribution.
13  *
14  * Neither the name of the HSQL Development Group nor the names of its
15  * contributors may be used to endorse or promote products derived from this
16  * software without specific prior written permission.
17  *
18  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19  * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21  * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22  * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25  * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29  */
30
31
32 package org.hsqldb;
33
34 import org.hsqldb.lib.HashSet;
35 import org.hsqldb.lib.IntValueHashMap;
36
37 /**
38  * Defines and enumerates reserved and non-reserved SQL
39  * keywords. <p>
40  *
41  * @author Nitin Chauhan
42  * @author fredt@users
43  * @since 1.7.2
44  * @version 1.7.2
45  */
46 public class Token {
47
48     private static IntValueHashMap commandSet;
49
50     //
51 static final String T_ASTERISK = "*";
52     static final String T_COMMA = ",";
53     static final String T_CLOSEBRACKET = ")";
54     static final String T_EQUALS = "=";
55     public static final String T_DIVIDE = "/";
56     static final String T_OPENBRACKET = "(";
57     static final String T_SEMICOLON = ";";
58     static final String T_MULTIPLY = "*";
59     static final String T_PERCENT = "%";
60     static final String T_PLUS = "+";
61     static final String T_QUESTION = "?";
62
63     // SQL 200n reserved tokens
64 static final String T_ADD = "ADD"; //reserved
65 static final String T_ALL = "ALL"; //reserved
66 static final String T_ALLOCATE = "ALLOCATE"; //reserved
67 public static final String T_ALTER = "ALTER"; //reserved
68 static final String T_AND = "AND"; //reserved
69 static final String T_ANY = "ANY"; //reserved
70 static final String T_ARE = "ARE"; //reserved
71 static final String T_ARRAY = "ARRAY"; //reserved
72 static final String T_AS = "AS"; //reserved
73 static final String T_ASENSITIVE =
74         "ASENSITIVE"; //reserved
75 static final String T_ASYMMETRIC =
76         "ASYMMETRIC"; //reserved
77 static final String T_AT = "AT"; //reserved
78 static final String T_ATOMIC = "ATOMIC"; //reserved
79 static final String T_AUTHORIZATION =
80         "AUTHORIZATION"; //reserved
81 static final String T_BEGIN = "BEGIN"; //reserved
82 static final String T_BETWEEN = "BETWEEN";
83     static final String T_BIGINT = "BIGINT"; //reserved
84 public static final String T_BINARY = "BINARY"; //reserved
85 static final String T_BLOB = "BLOB"; //reserved
86 static final String T_BOOLEAN = "BOOLEAN"; //reserved
87 static final String T_BOTH = "BOTH";
88     static final String T_BY = "BY"; //reserved
89 static final String T_CALL = "CALL"; //reserved
90 static final String T_CALLED = "CALLED"; //reserved
91 static final String T_CASCADED = "CASCADED"; //reserved
92 static final String T_CASE = "CASE"; //reserved
93 static final String T_CAST = "CAST"; //reserved
94 static final String T_CHAR = "CHAR"; //reserved
95 static final String T_CHARACTER =
96         "CHARACTER"; //reserved
97 static final String T_CHECK = "CHECK"; //reserved
98 static final String T_CLOB = "CLOB"; //reserved
99 static final String T_CLOSE = "CLOSE"; //reserved
100 static final String T_COLLATE = "COLLATE"; //reserved
101 static final String T_COLUMN = "COLUMN"; //reserved
102 public static final String T_COMMIT = "COMMIT"; //reserved
103 static final String T_CONDITION =
104         "CONDIITON"; //reserved
105 static final String T_CONNECT = "CONNECT"; //reserved
106 static final String T_CONSTRAINT =
107         "CONSTRAINT"; //reserved
108 static final String T_CONTINUE = "CONTINUE"; //reserved
109 static final String T_CORRESPONDING =
110         "CORRESPONDING"; //reserved
111 static final String T_CREATE = "CREATE"; //reserved
112 static final String T_CROSS = "CROSS"; //reserved
113 static final String T_CUBE = "CUBE"; //reserved
114 static final String T_CURRENT = "CURRENT"; //reserved
115 static final String T_CURRENT_DATE =
116         "CURRENT_DATE"; //reserved
117 static final String T_CURRENT_DEFAULT_TRANSFORM_GROUP =
118         "CURRENT_DEFAULT_TRANSFORM_GROUP"; //reserved
119 static final String T_CURRENT_PATH = "CURRENT_PATH"; //reserved
120 static final String T_CURRENT_ROLE = "CURRENT_ROLE"; //reserved
121 static final String T_CURRENT_TIME = "CURRENT_TIME"; //reserved
122 static final String T_CURRENT_TIMESTAMP =
123         "CURRENT_TIMESTAMP"; //reserved
124 static final String T_CURRENT_TRANSFORM_TROUP_FOR_TYPE =
125         "CURRENT_TRANSFORM_GROUP_FOR_TYPE"; //reserved
126 static final String T_CURRENT_USER = "CURRENT_USER"; //reserved
127 static final String T_CURSOR = "CURSOR"; //reserved
128 static final String T_CYCLE = "CYCLE"; //reserved
129 static final String T_DATE = "DATE"; //reserved
130 static final String T_DAY = "DAY"; //reserved
131 static final String T_DEALLOCATE = "DEALLOCATE"; //reserved
132 static final String T_DEC = "DEC"; //reserved
133 static final String T_DECIMAL = "DECIMAL"; //reserved
134 static final String T_DECLARE = "DECLARE"; //reserved
135 static final String T_DEFAULT = "DEFAULT"; //reserved
136 public static final String T_DELETE = "DELETE"; //reserved
137 static final String T_DEREF = "DEREF"; //reserved
138 static final String T_DESCRIBE = "DESCRIBE"; //reserved
139 static final String T_DETERMINISTIC = "DETERMINISTIC"; //reserved
140 static final String T_DISCONNECT = "DISCONNECT"; //reserved
141 static final String T_DISTINCT = "DISTINCT"; //reserved
142 static final String T_DO = "DO"; //reserved
143 static final String T_DOUBLE = "DOUBLE"; //reserved
144 static final String T_DOW = "DAYOFWEEK"; //reserved
145 static final String T_DROP = "DROP"; //reserved
146 static final String T_DYNAMIC = "DYNAMIC"; //reserved
147 static final String T_EACH = "EACH"; //reserved
148 static final String T_ELEMENT = "ELEMENT"; //reserved
149 static final String T_ELSE = "ELSE"; //reserved
150 static final String T_ELSEIF = "ELSEIF"; //reserved
151 static final String T_END = "END"; //reserved
152 static final String T_ESCAPE = "ESCAPE"; //reserved
153 static final String T_EXCEPT = "EXCEPT"; //reserved
154 static final String T_EXEC = "EXEC"; //reserved
155 static final String T_EXECUTE = "EXECUTE"; //reserved
156 static final String T_EXISTS = "EXISTS"; //reserved
157 static final String T_EXIT = "EXIT"; //reserved
158 static final String T_EXTERNAL = "EXTERNAL"; //reserved
159 static final String T_FALSE = "FALSE"; //reserved
160 static final String T_FETCH = "FETCH"; //reserved
161 static final String T_FILTER = "FILTER"; //reserved
162 static final String T_FLOAT = "FLOAT"; //reserved
163 static final String T_FOR = "FOR"; //reserved
164 static final String T_FOREIGN = "FOREIGN"; //reserved
165 static final String T_FREE = "FREE"; //reserved
166 static final String T_FROM = "FROM"; //reserved
167 static final String T_FULL = "FULL"; //reserved
168 static final String T_FUNCTION = "FUNCTION"; //reserved
169 static final String T_GET = "GET"; //reserved
170 static final String T_GLOBAL = "GLOBAL"; //reserved
171 static final String T_GRANT = "GRANT"; //reserved
172 static final String T_GROUP = "GROUP"; //reserved
173 static final String T_GROUPING = "GROUPING"; //reserved
174 static final String T_HANDLER = "HANDLER"; //reserved
175 static final String T_HAVING = "HAVING"; //reserved
176 static final String T_HEADER = "HEADER"; //reserved
177 static final String T_HOLD = "HOLD"; //reserved
178 static final String T_HOUR = "HOUR"; //reserved
179 static final String T_IDENTITY = "IDENTITY"; //reserved
180 static final String T_IF = "IF"; //reserved
181 static final String T_IMMEDIATE = "IMMEDIATE"; //reserved
182 static final String T_IN = "IN"; //reserved
183 static final String T_INDICATOR = "INDICATOR"; //reserved
184 static final String T_INNER = "INNER"; //reserved
185 static final String T_INOUT = "INOUT"; //reserved
186 static final String T_INPUT = "INPUT"; //reserved
187 static final String T_INSENSITIVE = "INSENSITIVE"; //reserved
188 public static final String T_INSERT = "INSERT"; //reserved
189 static final String T_INT = "INT"; //reserved
190 static final String T_INTEGER = "INTEGER"; //reserved
191 static final String T_INTERSECT = "INTERSECT"; //reserved
192 static final String T_INTERVAL = "INTERVAL"; //reserved
193 static final String T_INTO = "INTO"; //reserved
194 static final String T_IS = "IS"; //reserved
195 static final String T_ITERATE = "ITERATE"; //reserved
196 static final String T_JOIN = "JOIN"; //reserved
197 static final String T_LANGUAGE = "LANGUAGE"; //reserved
198 static final String T_LARGE = "LARGE"; //reserved
199 static final String T_LATERAL = "LATERAL"; //reserved
200 static final String T_LEADING = "LEADING"; //reserved
201 static final String T_LEAVE = "LEAVE"; //reserved
202 static final String T_LEFT = "LEFT"; //reserved
203 static final String T_LIKE = "LIKE"; //reserved
204 static final String T_LOCAL = "LOCAL"; //reserved
205 static final String T_LOCALTIME = "LOCALTIME"; //reserved
206 static final String T_LOCALTIMESTAMP = "LOCALTIMESTAMP"; //reserved
207 static final String T_LOOP = "LOOP"; //reserved
208 static final String T_MATCH = "MATCH"; //reserved
209 static final String T_MEMBER = "MEMBER"; //reserved
210 static final String T_METHOD = "METHOD"; //reserved
211 static final String T_MINUTE = "MINUTE"; //reserved
212 static final String T_MODIFIES = "MODIFIES"; //reserved
213 static final String T_MODULE = "MODULE"; //reserved
214 static final String T_MONTH = "MONTH"; //reserved
215 static final String T_MULTISET = "MULTISET"; //reserved
216 static final String T_NATIONAL = "NATIONAL"; //reserved
217 static final String T_NATURAL = "NAUTRAL"; //reserved
218 static final String T_NCHAR = "NCHAR"; //reserved
219 static final String T_NCLOB = "NCLOB"; //reserved
220 static final String T_NEW = "NEW"; //reserved
221 static final String T_NEXT = "NEXT"; //reserved
222 static final String T_NO = "NO"; //reserved
223 static final String T_NONE = "NONE"; //reserved
224 static final String T_NOT = "NOT"; //reserved
225 static final String T_NULL = "NULL"; //reserved
226 static final String T_NUMERIC = "NUMERIC"; //reserved
227 static final String T_OF = "OF"; //reserved
228 static final String T_OLD = "OLD"; //reserved
229 static final String T_ON = "ON"; //reserved
230 static final String T_ONLY = "ONLY"; //reserved
231 static final String T_OPEN = "OPEN"; //reserved
232 static final String T_OR = "OR"; //reserved
233 static final String T_ORDER = "ORDER"; //reserved
234 static final String T_OUT = "OUT"; //reserved
235 static final String T_OUTER = "OUTER"; //reserved
236 static final String T_OUTPUT = "OUTPUT"; //reserved
237 static final String T_OVER = "OVER"; //reserved
238 static final String T_OVERLAPS = "OVERLAPS"; //reserved
239 static final String T_PARAMETER = "PARAMETER"; //reserved
240 static final String T_PARTITION = "PARTITION"; //reserved
241 static final String T_PRECISION = "PRECISION"; //reserved
242 static final String T_PREPARE = "PREPARE"; //reserved
243 static final String T_PRIMARY = "PRIMARY"; //reserved
244 static final String T_PROCEDURE = "PROCEDURE"; //reserved
245 static final String T_RANGE = "RANGE"; //reserved
246 static final String T_READS = "READS"; //reserved
247 static final String T_REAL = "REAL"; //reserved
248 static final String T_RECURSIVE = "RECURSIVE"; //reserved
249 static final String T_REF = "REF"; //reserved
250 static final String T_REFERENCES = "REFERENCES"; //reserved
251 static final String T_REFERENCING = "REFERENCING"; //reserved
252 static final String T_RELEASE = "RELEASE"; //reserved
253 static final String T_REPEAT = "REPEAT"; //reserved
254 static final String T_RESIGNAL = "RESIGNAL"; //reserved
255 static final String T_RESULT = "RESULT"; //reserved
256 static final String T_RETURN = "RETURN"; //reserved
257 static final String T_RETURNS = "RETURNS"; //reserved
258 static final String T_REVOKE = "REVOKE"; //reserved
259 static final String T_RIGHT = "RIGHT"; //reserved
260 static final String T_ROLLBACK = "ROLLBACK"; //reserved
261 static final String T_ROLLUP = "ROLLUP"; //reserved
262 static final String T_ROW = "ROW"; //reserved
263 static final String T_ROWS = "ROWS"; //reserved
264 static final String T_SAVEPOINT = "SAVEPOINT"; //reserved
265 static final String T_SCOPE = "SCOPE"; //reserved
266 static final String T_SCROLL = "SCROLL"; //reserved
267 static final String T_SECOND = "SECOND"; //reserved
268 static final String T_SEARCH = "SEARCH"; //reserved
269 static final String T_SELECT = "SELECT"; //reserved
270 static final String T_SENSITIVE = "SENSITIVE"; //reserved
271 static final String T_SESSION_USER = "SESSION_USER"; //reserved
272 public static final String T_SET = "SET"; //reserved
273 static final String T_SIGNAL = "SIGNAL"; //reserved
274 static final String T_SIMILAR = "SIMILAR"; //reserved
275 static final String T_SMALLINT = "SMALLINT"; //reserved
276 static final String T_SOME = "SOME"; //reserved
277 static final String T_SPECIFIC = "SPECIFIC"; //reserved
278 static final String T_SPECIFICTYPE = "SPECIFICTYPE"; //reserved
279 static final String T_SQL = "SQL"; //reserved
280 static final String T_SQLEXCEPTION = "SQLEXCEPTION"; //reserved
281 static final String T_SQLSTATE = "SQLSTATE"; //reserved
282 static final String T_SQLWARNING = "SQLWARNING"; //reserved
283 static final String T_START = "START"; //reserved
284 static final String T_STATIC = "STATIC"; //reserved
285 static final String T_SUBMULTISET = "SUBMULTISET"; //reserved
286 static final String T_SYMMETRIC = "SYMMETRIC"; //reserved
287 static final String T_SYSTEM = "SYSTEM"; //reserved
288 static final String T_SYSTEM_USER = "SYSTEM_USER"; //reserved
289 static final String T_TABLE = "TABLE"; //reserved
290 static final String T_TABLESAMPLE = "TABLESAMPLE"; //reserved
291 static final String T_THEN = "THEN"; //reserved
292 static final String T_TIME = "TIME"; //reserved
293 static final String T_TIMESTAMP = "TIMESTAMP"; //reserved
294 static final String T_TIMEZONE_HOUR = "TIMEZONE_HOUR"; //reserved
295 static final String T_TIMEZONE_MINUTE = "TIMEZONE_MINUTE"; //reserved
296 static final String T_TO = "TO"; //reserved
297 static final String T_TRAILING = "TRAILING"; //reserved
298 static final String T_TRANSLATION = "TRANSLATION"; //reserved
299 static final String T_TREAT = "TREAT"; //reserved
300 static final String T_TRIGGER = "TRIGGER"; //reserved
301 static final String T_TRUE = "TRUE"; //reserved
302 static final String T_UNDO = "UNDO"; //reserved
303 static final String T_UNION = "UNION"; //reserved
304 static final String T_UNIQUE = "UNIQUE"; //reserved
305 static final String T_UNKNOWN = "UNKNOWN"; //reserved
306 static final String T_UNNEST = "UNNEST"; //reserved
307 static final String T_UNTIL = "UNTIL"; //reserved
308 static final String T_UPDATE = "UPDATE"; //reserved
309 static final String T_USER = "USER"; //reserved
310 static final String T_USING = "USING"; //reserved
311 static final String T_VALUE = "VALUE"; //reserved
312 static final String T_VALUES = "VALUES"; //reserved
313 static final String T_VARCHAR = "VARCHAR"; //reserved
314 static final String T_VARYING = "VARYING"; //reserved
315 static final String T_WHEN = "WHEN"; //reserved
316 static final String T_WHENEVER = "WHENEVER"; //reserved
317 static final String T_WHERE = "WHERE"; //reserved
318 static final String T_WHILE = "WHILE"; //reserved
319 static final String T_WINDOW = "WINDOW"; //reserved
320 static final String T_WITH = "WITH"; //reserved
321 static final String T_WITHIN = "WITHIN"; //reserved
322 static final String T_WITHOUT = "WITHOUT"; //reserved
323 static final String T_YEAR = "YEAR"; //reserved
324
325     // other tokens
326 static final String T_ALWAYS = "ALWAYS";
327     static final String T_ACTION = "ACTION";
328     static final String T_ADMIN = "ADMIN";
329     static final String T_AFTER = "AFTER";
330     static final String T_ALIAS = "ALIAS";
331     static final String T_ASC = "ASC";
332     static final String T_AUTOCOMMIT = "AUTOCOMMIT";
333     static final String T_AVG = "AVG";
334     static final String T_BACKUP = "BACKUP";
335     static final String T_BEFORE = "BEFORE";
336     static final String T_CACHED = "CACHED";
337     static final String T_CASCADE = "CASCADE";
338     static final String T_CASEWHEN = "CASEWHEN";
339     static final String T_CHECKPOINT = "CHECKPOINT";
340     static final String T_CLASS = "CLASS";
341     static final String T_COALESCE = "COALESCE";
342     static final String T_COLLATION = "COLLATION";
343     static final String T_COMPACT = "COMPACT";
344     public static final String T_COMPRESSED = "COMPRESSED";
345     static final String T_CONVERT = "CONVERT";
346     static final String T_COUNT = "COUNT";
347     static final String T_DATABASE = "DATABASE";
348     static final String T_DEFRAG = "DEFRAG";
349     static final String T_DESC = "DESC";
350     static final String T_EVERY = "EVERY";
351     static final String T_EXPLAIN = "EXPLAIN";
352     static final String T_EXTRACT = "EXTRACT";
353     static final String T_GENERATED = "GENERATED";
354     static final String T_IFNULL = "IFNULL";
355     static final String T_IGNORECASE = "IGNORECASE";
356     static final String T_IMMEDIATELY = "IMMEDIATELY";
357     static final String T_INCREMENT = "INCREMENT";
358     static final String T_INDEX = "INDEX";
359     static final String T_INITIAL = "INITIAL";
360     static final String T_KEY = "KEY";
361     static final String T_LIMIT = "LIMIT";
362     static final String T_LOGSIZE = "LOGSIZE";
363     static final String T_MAX = "MAX";
364     static final String T_MAXROWS = "MAXROWS";
365     static final String T_MEMORY = "MEMORY";
366     static final String T_MERGE = "MERGE";
367     static final String T_MIN = "MIN";
368     static final String T_MINUS = "MINUS";
369     static final String T_NOW = "NOW";
370     static final String T_NOWAIT = "NOWAIT";
371     static final String T_NULLIF = "NULLIF";
372     static final String T_NVL = "NVL";
373     static final String T_OFFSET = "OFFSET";
374     static final String T_PASSWORD = "PASSWORD";
375     public static final String T_SCHEMA = "SCHEMA";
376     static final String T_PLAN = "PLAN";
377     static final String T_PRESERVE = "PRESERVE";
378     static final String T_PRIVILEGES = "PRIVILEGES";
379     static final String T_POSITION = "POSITION";
380     static final String T_PROPERTY = "PROPERTY";
381     static final String T_PUBLIC = "PUBLIC";
382