Repository: empire-db Updated Branches: refs/heads/master f94e46389 -> 7f35a3514
EMPIREDB-264 MySQL Keywords Project: http://git-wip-us.apache.org/repos/asf/empire-db/repo Commit: http://git-wip-us.apache.org/repos/asf/empire-db/commit/7f35a351 Tree: http://git-wip-us.apache.org/repos/asf/empire-db/tree/7f35a351 Diff: http://git-wip-us.apache.org/repos/asf/empire-db/diff/7f35a351 Branch: refs/heads/master Commit: 7f35a3514b5505257413a755a6ec2c74aa3bc77d Parents: f94e463 Author: Jan Glaubitz <[email protected]> Authored: Fri Oct 13 10:32:50 2017 +0200 Committer: Jan Glaubitz <[email protected]> Committed: Fri Oct 13 10:32:50 2017 +0200 ---------------------------------------------------------------------- .../empire/db/mysql/DBDatabaseDriverMySQL.java | 398 ++++++++++++++++++- 1 file changed, 397 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/empire-db/blob/7f35a351/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java ---------------------------------------------------------------------- diff --git a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java index da0680c..316eb36 100644 --- a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java +++ b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java @@ -153,98 +153,235 @@ public class DBDatabaseDriverMySQL extends DBDatabaseDriver private void setReservedKeywords(){ // list of reserved keywords - // http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html + // https://dev.mysql.com/doc/refman/5.7/en/keywords.html addReservedKeyWord("ACCESSIBLE".toLowerCase()); + addReservedKeyWord("ACCOUNT".toLowerCase()); + addReservedKeyWord("ACTION".toLowerCase()); addReservedKeyWord("ADD".toLowerCase()); + addReservedKeyWord("AFTER".toLowerCase()); + addReservedKeyWord("AGAINST".toLowerCase()); + addReservedKeyWord("AGGREGATE".toLowerCase()); + addReservedKeyWord("ALGORITHM".toLowerCase()); addReservedKeyWord("ALL".toLowerCase()); addReservedKeyWord("ALTER".toLowerCase()); + addReservedKeyWord("ALWAYS".toLowerCase()); + addReservedKeyWord("ANALYSE".toLowerCase()); addReservedKeyWord("ANALYZE".toLowerCase()); addReservedKeyWord("AND".toLowerCase()); + addReservedKeyWord("ANY".toLowerCase()); addReservedKeyWord("AS".toLowerCase()); addReservedKeyWord("ASC".toLowerCase()); + addReservedKeyWord("ASCII".toLowerCase()); addReservedKeyWord("ASENSITIVE".toLowerCase()); + addReservedKeyWord("AT".toLowerCase()); + addReservedKeyWord("AUTOEXTEND_SIZE".toLowerCase()); + addReservedKeyWord("AUTO_INCREMENT".toLowerCase()); + addReservedKeyWord("AVG".toLowerCase()); + addReservedKeyWord("AVG_ROW_LENGTH".toLowerCase()); + addReservedKeyWord("BACKUP".toLowerCase()); addReservedKeyWord("BEFORE".toLowerCase()); + addReservedKeyWord("BEGIN".toLowerCase()); addReservedKeyWord("BETWEEN".toLowerCase()); addReservedKeyWord("BIGINT".toLowerCase()); addReservedKeyWord("BINARY".toLowerCase()); + addReservedKeyWord("BINLOG".toLowerCase()); + addReservedKeyWord("BIT".toLowerCase()); addReservedKeyWord("BLOB".toLowerCase()); + addReservedKeyWord("BLOCK".toLowerCase()); + addReservedKeyWord("BOOL".toLowerCase()); + addReservedKeyWord("BOOLEAN".toLowerCase()); addReservedKeyWord("BOTH".toLowerCase()); + addReservedKeyWord("BTREE".toLowerCase()); addReservedKeyWord("BY".toLowerCase()); + addReservedKeyWord("BYTE".toLowerCase()); + addReservedKeyWord("CACHE".toLowerCase()); addReservedKeyWord("CALL".toLowerCase()); addReservedKeyWord("CASCADE".toLowerCase()); + addReservedKeyWord("CASCADED".toLowerCase()); addReservedKeyWord("CASE".toLowerCase()); + addReservedKeyWord("CATALOG_NAME".toLowerCase()); + addReservedKeyWord("CHAIN".toLowerCase()); addReservedKeyWord("CHANGE".toLowerCase()); + addReservedKeyWord("CHANGED".toLowerCase()); + addReservedKeyWord("CHANNEL".toLowerCase()); addReservedKeyWord("CHAR".toLowerCase()); addReservedKeyWord("CHARACTER".toLowerCase()); + addReservedKeyWord("CHARSET".toLowerCase()); addReservedKeyWord("CHECK".toLowerCase()); + addReservedKeyWord("CHECKSUM".toLowerCase()); + addReservedKeyWord("CIPHER".toLowerCase()); + addReservedKeyWord("CLASS_ORIGIN".toLowerCase()); + addReservedKeyWord("CLIENT".toLowerCase()); + addReservedKeyWord("CLOSE".toLowerCase()); + addReservedKeyWord("COALESCE".toLowerCase()); + addReservedKeyWord("CODE".toLowerCase()); addReservedKeyWord("COLLATE".toLowerCase()); + addReservedKeyWord("COLLATION".toLowerCase()); addReservedKeyWord("COLUMN".toLowerCase()); + addReservedKeyWord("COLUMNS".toLowerCase()); + addReservedKeyWord("COLUMN_FORMAT".toLowerCase()); + addReservedKeyWord("COLUMN_NAME".toLowerCase()); + addReservedKeyWord("COMMENT".toLowerCase()); + addReservedKeyWord("COMMIT".toLowerCase()); + addReservedKeyWord("COMMITTED".toLowerCase()); + addReservedKeyWord("COMPACT".toLowerCase()); + addReservedKeyWord("COMPLETION".toLowerCase()); + addReservedKeyWord("COMPRESSED".toLowerCase()); + addReservedKeyWord("COMPRESSION".toLowerCase()); + addReservedKeyWord("CONCURRENT".toLowerCase()); addReservedKeyWord("CONDITION".toLowerCase()); + addReservedKeyWord("CONNECTION".toLowerCase()); + addReservedKeyWord("CONSISTENT".toLowerCase()); addReservedKeyWord("CONSTRAINT".toLowerCase()); + addReservedKeyWord("CONSTRAINT_CATALOG".toLowerCase()); + addReservedKeyWord("CONSTRAINT_NAME".toLowerCase()); + addReservedKeyWord("CONSTRAINT_SCHEMA".toLowerCase()); + addReservedKeyWord("CONTAINS".toLowerCase()); + addReservedKeyWord("CONTEXT".toLowerCase()); addReservedKeyWord("CONTINUE".toLowerCase()); addReservedKeyWord("CONVERT".toLowerCase()); + addReservedKeyWord("CPU".toLowerCase()); addReservedKeyWord("CREATE".toLowerCase()); addReservedKeyWord("CROSS".toLowerCase()); + addReservedKeyWord("CUBE".toLowerCase()); + addReservedKeyWord("CURRENT".toLowerCase()); addReservedKeyWord("CURRENT_DATE".toLowerCase()); addReservedKeyWord("CURRENT_TIME".toLowerCase()); addReservedKeyWord("CURRENT_TIMESTAMP".toLowerCase()); addReservedKeyWord("CURRENT_USER".toLowerCase()); addReservedKeyWord("CURSOR".toLowerCase()); + addReservedKeyWord("CURSOR_NAME".toLowerCase()); + addReservedKeyWord("DATA".toLowerCase()); addReservedKeyWord("DATABASE".toLowerCase()); addReservedKeyWord("DATABASES".toLowerCase()); + addReservedKeyWord("DATAFILE".toLowerCase()); + addReservedKeyWord("DATE".toLowerCase()); + addReservedKeyWord("DATETIME".toLowerCase()); + addReservedKeyWord("DAY".toLowerCase()); addReservedKeyWord("DAY_HOUR".toLowerCase()); addReservedKeyWord("DAY_MICROSECOND".toLowerCase()); addReservedKeyWord("DAY_MINUTE".toLowerCase()); addReservedKeyWord("DAY_SECOND".toLowerCase()); + addReservedKeyWord("DEALLOCATE".toLowerCase()); addReservedKeyWord("DEC".toLowerCase()); addReservedKeyWord("DECIMAL".toLowerCase()); addReservedKeyWord("DECLARE".toLowerCase()); addReservedKeyWord("DEFAULT".toLowerCase()); + addReservedKeyWord("DEFAULT_AUTH".toLowerCase()); + addReservedKeyWord("DEFINER".toLowerCase()); addReservedKeyWord("DELAYED".toLowerCase()); + addReservedKeyWord("DELAY_KEY_WRITE".toLowerCase()); addReservedKeyWord("DELETE".toLowerCase()); addReservedKeyWord("DESC".toLowerCase()); addReservedKeyWord("DESCRIBE".toLowerCase()); + addReservedKeyWord("DES_KEY_FILE".toLowerCase()); addReservedKeyWord("DETERMINISTIC".toLowerCase()); + addReservedKeyWord("DIAGNOSTICS".toLowerCase()); + addReservedKeyWord("DIRECTORY".toLowerCase()); + addReservedKeyWord("DISABLE".toLowerCase()); + addReservedKeyWord("DISCARD".toLowerCase()); + addReservedKeyWord("DISK".toLowerCase()); addReservedKeyWord("DISTINCT".toLowerCase()); addReservedKeyWord("DISTINCTROW".toLowerCase()); addReservedKeyWord("DIV".toLowerCase()); + addReservedKeyWord("DO".toLowerCase()); addReservedKeyWord("DOUBLE".toLowerCase()); addReservedKeyWord("DROP".toLowerCase()); addReservedKeyWord("DUAL".toLowerCase()); + addReservedKeyWord("DUMPFILE".toLowerCase()); + addReservedKeyWord("DUPLICATE".toLowerCase()); + addReservedKeyWord("DYNAMIC".toLowerCase()); addReservedKeyWord("EACH".toLowerCase()); addReservedKeyWord("ELSE".toLowerCase()); addReservedKeyWord("ELSEIF".toLowerCase()); + addReservedKeyWord("ENABLE".toLowerCase()); addReservedKeyWord("ENCLOSED".toLowerCase()); + addReservedKeyWord("ENCRYPTION".toLowerCase()); + addReservedKeyWord("END".toLowerCase()); + addReservedKeyWord("ENDS".toLowerCase()); + addReservedKeyWord("ENGINE".toLowerCase()); + addReservedKeyWord("ENGINES".toLowerCase()); + addReservedKeyWord("ENUM".toLowerCase()); + addReservedKeyWord("ERROR".toLowerCase()); + addReservedKeyWord("ERRORS".toLowerCase()); + addReservedKeyWord("ESCAPE".toLowerCase()); addReservedKeyWord("ESCAPED".toLowerCase()); + addReservedKeyWord("EVENT".toLowerCase()); + addReservedKeyWord("EVENTS".toLowerCase()); + addReservedKeyWord("EVERY".toLowerCase()); + addReservedKeyWord("EXCHANGE".toLowerCase()); + addReservedKeyWord("EXECUTE".toLowerCase()); addReservedKeyWord("EXISTS".toLowerCase()); addReservedKeyWord("EXIT".toLowerCase()); + addReservedKeyWord("EXPANSION".toLowerCase()); + addReservedKeyWord("EXPIRE".toLowerCase()); addReservedKeyWord("EXPLAIN".toLowerCase()); + addReservedKeyWord("EXPORT".toLowerCase()); + addReservedKeyWord("EXTENDED".toLowerCase()); + addReservedKeyWord("EXTENT_SIZE".toLowerCase()); addReservedKeyWord("FALSE".toLowerCase()); + addReservedKeyWord("FAST".toLowerCase()); + addReservedKeyWord("FAULTS".toLowerCase()); addReservedKeyWord("FETCH".toLowerCase()); + addReservedKeyWord("FIELDS".toLowerCase()); + addReservedKeyWord("FILE".toLowerCase()); + addReservedKeyWord("FILE_BLOCK_SIZE".toLowerCase()); + addReservedKeyWord("FILTER".toLowerCase()); + addReservedKeyWord("FIRST".toLowerCase()); + addReservedKeyWord("FIXED".toLowerCase()); addReservedKeyWord("FLOAT".toLowerCase()); addReservedKeyWord("FLOAT4".toLowerCase()); addReservedKeyWord("FLOAT8".toLowerCase()); + addReservedKeyWord("FLUSH".toLowerCase()); + addReservedKeyWord("FOLLOWS".toLowerCase()); addReservedKeyWord("FOR".toLowerCase()); addReservedKeyWord("FORCE".toLowerCase()); addReservedKeyWord("FOREIGN".toLowerCase()); + addReservedKeyWord("FORMAT".toLowerCase()); + addReservedKeyWord("FOUND".toLowerCase()); addReservedKeyWord("FROM".toLowerCase()); + addReservedKeyWord("FULL".toLowerCase()); addReservedKeyWord("FULLTEXT".toLowerCase()); + addReservedKeyWord("FUNCTION".toLowerCase()); + addReservedKeyWord("GENERAL".toLowerCase()); + addReservedKeyWord("GENERATED".toLowerCase()); + addReservedKeyWord("GEOMETRY".toLowerCase()); + addReservedKeyWord("GEOMETRYCOLLECTION".toLowerCase()); + addReservedKeyWord("GET".toLowerCase()); + addReservedKeyWord("GET_FORMAT".toLowerCase()); + addReservedKeyWord("GLOBAL".toLowerCase()); addReservedKeyWord("GRANT".toLowerCase()); + addReservedKeyWord("GRANTS".toLowerCase()); addReservedKeyWord("GROUP".toLowerCase()); + addReservedKeyWord("GROUP_REPLICATION".toLowerCase()); + addReservedKeyWord("HANDLER".toLowerCase()); + addReservedKeyWord("HASH".toLowerCase()); addReservedKeyWord("HAVING".toLowerCase()); + addReservedKeyWord("HELP".toLowerCase()); addReservedKeyWord("HIGH_PRIORITY".toLowerCase()); + addReservedKeyWord("HOST".toLowerCase()); + addReservedKeyWord("HOSTS".toLowerCase()); + addReservedKeyWord("HOUR".toLowerCase()); addReservedKeyWord("HOUR_MICROSECOND".toLowerCase()); addReservedKeyWord("HOUR_MINUTE".toLowerCase()); addReservedKeyWord("HOUR_SECOND".toLowerCase()); + addReservedKeyWord("IDENTIFIED".toLowerCase()); addReservedKeyWord("IF".toLowerCase()); addReservedKeyWord("IGNORE".toLowerCase()); + addReservedKeyWord("IGNORE_SERVER_IDS".toLowerCase()); + addReservedKeyWord("IMPORT".toLowerCase()); addReservedKeyWord("IN".toLowerCase()); addReservedKeyWord("INDEX".toLowerCase()); + addReservedKeyWord("INDEXES".toLowerCase()); addReservedKeyWord("INFILE".toLowerCase()); + addReservedKeyWord("INITIAL_SIZE".toLowerCase()); addReservedKeyWord("INNER".toLowerCase()); addReservedKeyWord("INOUT".toLowerCase()); addReservedKeyWord("INSENSITIVE".toLowerCase()); addReservedKeyWord("INSERT".toLowerCase()); + addReservedKeyWord("INSERT_METHOD".toLowerCase()); + addReservedKeyWord("INSTALL".toLowerCase()); + addReservedKeyWord("INSTANCE".toLowerCase()); addReservedKeyWord("INT".toLowerCase()); addReservedKeyWord("INT1".toLowerCase()); addReservedKeyWord("INT2".toLowerCase()); @@ -254,130 +391,389 @@ public class DBDatabaseDriverMySQL extends DBDatabaseDriver addReservedKeyWord("INTEGER".toLowerCase()); addReservedKeyWord("INTERVAL".toLowerCase()); addReservedKeyWord("INTO".toLowerCase()); + addReservedKeyWord("INVOKER".toLowerCase()); + addReservedKeyWord("IO".toLowerCase()); + addReservedKeyWord("IO_AFTER_GTIDS".toLowerCase()); + addReservedKeyWord("IO_BEFORE_GTIDS".toLowerCase()); + addReservedKeyWord("IO_THREAD".toLowerCase()); + addReservedKeyWord("IPC".toLowerCase()); addReservedKeyWord("IS".toLowerCase()); + addReservedKeyWord("ISOLATION".toLowerCase()); + addReservedKeyWord("ISSUER".toLowerCase()); addReservedKeyWord("ITERATE".toLowerCase()); addReservedKeyWord("JOIN".toLowerCase()); + addReservedKeyWord("JSON".toLowerCase()); addReservedKeyWord("KEY".toLowerCase()); addReservedKeyWord("KEYS".toLowerCase()); + addReservedKeyWord("KEY_BLOCK_SIZE".toLowerCase()); addReservedKeyWord("KILL".toLowerCase()); + addReservedKeyWord("LANGUAGE".toLowerCase()); + addReservedKeyWord("LAST".toLowerCase()); addReservedKeyWord("LEADING".toLowerCase()); addReservedKeyWord("LEAVE".toLowerCase()); + addReservedKeyWord("LEAVES".toLowerCase()); addReservedKeyWord("LEFT".toLowerCase()); + addReservedKeyWord("LESS".toLowerCase()); + addReservedKeyWord("LEVEL".toLowerCase()); addReservedKeyWord("LIKE".toLowerCase()); addReservedKeyWord("LIMIT".toLowerCase()); addReservedKeyWord("LINEAR".toLowerCase()); addReservedKeyWord("LINES".toLowerCase()); + addReservedKeyWord("LINESTRING".toLowerCase()); + addReservedKeyWord("LIST".toLowerCase()); addReservedKeyWord("LOAD".toLowerCase()); + addReservedKeyWord("LOCAL".toLowerCase()); addReservedKeyWord("LOCALTIME".toLowerCase()); addReservedKeyWord("LOCALTIMESTAMP".toLowerCase()); addReservedKeyWord("LOCK".toLowerCase()); + addReservedKeyWord("LOCKS".toLowerCase()); + addReservedKeyWord("LOGFILE".toLowerCase()); + addReservedKeyWord("LOGS".toLowerCase()); addReservedKeyWord("LONG".toLowerCase()); addReservedKeyWord("LONGBLOB".toLowerCase()); addReservedKeyWord("LONGTEXT".toLowerCase()); addReservedKeyWord("LOOP".toLowerCase()); addReservedKeyWord("LOW_PRIORITY".toLowerCase()); + addReservedKeyWord("MASTER".toLowerCase()); + addReservedKeyWord("MASTER_AUTO_POSITION".toLowerCase()); + addReservedKeyWord("MASTER_BIND".toLowerCase()); + addReservedKeyWord("MASTER_CONNECT_RETRY".toLowerCase()); + addReservedKeyWord("MASTER_DELAY".toLowerCase()); + addReservedKeyWord("MASTER_HEARTBEAT_PERIOD".toLowerCase()); + addReservedKeyWord("MASTER_HOST".toLowerCase()); + addReservedKeyWord("MASTER_LOG_FILE".toLowerCase()); + addReservedKeyWord("MASTER_LOG_POS".toLowerCase()); + addReservedKeyWord("MASTER_PASSWORD".toLowerCase()); + addReservedKeyWord("MASTER_PORT".toLowerCase()); + addReservedKeyWord("MASTER_RETRY_COUNT".toLowerCase()); + addReservedKeyWord("MASTER_SERVER_ID".toLowerCase()); + addReservedKeyWord("MASTER_SSL".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CA".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CAPATH".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CERT".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CIPHER".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CRL".toLowerCase()); + addReservedKeyWord("MASTER_SSL_CRLPATH".toLowerCase()); + addReservedKeyWord("MASTER_SSL_KEY".toLowerCase()); addReservedKeyWord("MASTER_SSL_VERIFY_SERVER_CERT".toLowerCase()); + addReservedKeyWord("MASTER_TLS_VERSION".toLowerCase()); + addReservedKeyWord("MASTER_USER".toLowerCase()); addReservedKeyWord("MATCH".toLowerCase()); addReservedKeyWord("MAXVALUE".toLowerCase()); + addReservedKeyWord("MAX_CONNECTIONS_PER_HOUR".toLowerCase()); + addReservedKeyWord("MAX_QUERIES_PER_HOUR".toLowerCase()); + addReservedKeyWord("MAX_ROWS".toLowerCase()); + addReservedKeyWord("MAX_SIZE".toLowerCase()); + addReservedKeyWord("MAX_STATEMENT_TIME".toLowerCase()); + addReservedKeyWord("MAX_UPDATES_PER_HOUR".toLowerCase()); + addReservedKeyWord("MAX_USER_CONNECTIONS".toLowerCase()); + addReservedKeyWord("MEDIUM".toLowerCase()); addReservedKeyWord("MEDIUMBLOB".toLowerCase()); addReservedKeyWord("MEDIUMINT".toLowerCase()); addReservedKeyWord("MEDIUMTEXT".toLowerCase()); + addReservedKeyWord("MEMORY".toLowerCase()); + addReservedKeyWord("MERGE".toLowerCase()); + addReservedKeyWord("MESSAGE_TEXT".toLowerCase()); + addReservedKeyWord("MICROSECOND".toLowerCase()); addReservedKeyWord("MIDDLEINT".toLowerCase()); + addReservedKeyWord("MIGRATE".toLowerCase()); + addReservedKeyWord("MINUTE".toLowerCase()); addReservedKeyWord("MINUTE_MICROSECOND".toLowerCase()); addReservedKeyWord("MINUTE_SECOND".toLowerCase()); + addReservedKeyWord("MIN_ROWS".toLowerCase()); addReservedKeyWord("MOD".toLowerCase()); + addReservedKeyWord("MODE".toLowerCase()); addReservedKeyWord("MODIFIES".toLowerCase()); + addReservedKeyWord("MODIFY".toLowerCase()); + addReservedKeyWord("MONTH".toLowerCase()); + addReservedKeyWord("MULTILINESTRING".toLowerCase()); + addReservedKeyWord("MULTIPOINT".toLowerCase()); + addReservedKeyWord("MULTIPOLYGON".toLowerCase()); + addReservedKeyWord("MUTEX".toLowerCase()); + addReservedKeyWord("MYSQL_ERRNO".toLowerCase()); + addReservedKeyWord("NAME".toLowerCase()); + addReservedKeyWord("NAMES".toLowerCase()); + addReservedKeyWord("NATIONAL".toLowerCase()); addReservedKeyWord("NATURAL".toLowerCase()); + addReservedKeyWord("NCHAR".toLowerCase()); + addReservedKeyWord("NDB".toLowerCase()); + addReservedKeyWord("NDBCLUSTER".toLowerCase()); + addReservedKeyWord("NEVER".toLowerCase()); + addReservedKeyWord("NEW".toLowerCase()); + addReservedKeyWord("NEXT".toLowerCase()); + addReservedKeyWord("NO".toLowerCase()); + addReservedKeyWord("NODEGROUP".toLowerCase()); + addReservedKeyWord("NONBLOCKING".toLowerCase()); + addReservedKeyWord("NONE".toLowerCase()); addReservedKeyWord("NOT".toLowerCase()); + addReservedKeyWord("NO_WAIT".toLowerCase()); addReservedKeyWord("NO_WRITE_TO_BINLOG".toLowerCase()); addReservedKeyWord("NULL".toLowerCase()); + addReservedKeyWord("NUMBER".toLowerCase()); addReservedKeyWord("NUMERIC".toLowerCase()); + addReservedKeyWord("NVARCHAR".toLowerCase()); + addReservedKeyWord("OFFSET".toLowerCase()); + addReservedKeyWord("OLD_PASSWORD".toLowerCase()); addReservedKeyWord("ON".toLowerCase()); + addReservedKeyWord("ONE".toLowerCase()); + addReservedKeyWord("ONLY".toLowerCase()); + addReservedKeyWord("OPEN".toLowerCase()); addReservedKeyWord("OPTIMIZE".toLowerCase()); + addReservedKeyWord("OPTIMIZER_COSTS".toLowerCase()); addReservedKeyWord("OPTION".toLowerCase()); addReservedKeyWord("OPTIONALLY".toLowerCase()); + addReservedKeyWord("OPTIONS".toLowerCase()); addReservedKeyWord("OR".toLowerCase()); addReservedKeyWord("ORDER".toLowerCase()); addReservedKeyWord("OUT".toLowerCase()); addReservedKeyWord("OUTER".toLowerCase()); addReservedKeyWord("OUTFILE".toLowerCase()); + addReservedKeyWord("OWNER".toLowerCase()); + addReservedKeyWord("PACK_KEYS".toLowerCase()); + addReservedKeyWord("PAGE".toLowerCase()); + addReservedKeyWord("PARSER".toLowerCase()); + addReservedKeyWord("PARSE_GCOL_EXPR".toLowerCase()); + addReservedKeyWord("PARTIAL".toLowerCase()); + addReservedKeyWord("PARTITION".toLowerCase()); + addReservedKeyWord("PARTITIONING".toLowerCase()); + addReservedKeyWord("PARTITIONS".toLowerCase()); + addReservedKeyWord("PASSWORD".toLowerCase()); + addReservedKeyWord("PHASE".toLowerCase()); + addReservedKeyWord("PLUGIN".toLowerCase()); + addReservedKeyWord("PLUGINS".toLowerCase()); + addReservedKeyWord("PLUGIN_DIR".toLowerCase()); + addReservedKeyWord("POINT".toLowerCase()); + addReservedKeyWord("POLYGON".toLowerCase()); + addReservedKeyWord("PORT".toLowerCase()); + addReservedKeyWord("PRECEDES".toLowerCase()); addReservedKeyWord("PRECISION".toLowerCase()); + addReservedKeyWord("PREPARE".toLowerCase()); + addReservedKeyWord("PRESERVE".toLowerCase()); + addReservedKeyWord("PREV".toLowerCase()); addReservedKeyWord("PRIMARY".toLowerCase()); + addReservedKeyWord("PRIVILEGES".toLowerCase()); addReservedKeyWord("PROCEDURE".toLowerCase()); + addReservedKeyWord("PROCESSLIST".toLowerCase()); + addReservedKeyWord("PROFILE".toLowerCase()); + addReservedKeyWord("PROFILES".toLowerCase()); + addReservedKeyWord("PROXY".toLowerCase()); addReservedKeyWord("PURGE".toLowerCase()); + addReservedKeyWord("QUARTER".toLowerCase()); + addReservedKeyWord("QUERY".toLowerCase()); + addReservedKeyWord("QUICK".toLowerCase()); addReservedKeyWord("RANGE".toLowerCase()); addReservedKeyWord("READ".toLowerCase()); addReservedKeyWord("READS".toLowerCase()); + addReservedKeyWord("READ_ONLY".toLowerCase()); addReservedKeyWord("READ_WRITE".toLowerCase()); addReservedKeyWord("REAL".toLowerCase()); + addReservedKeyWord("REBUILD".toLowerCase()); + addReservedKeyWord("RECOVER".toLowerCase()); + addReservedKeyWord("REDOFILE".toLowerCase()); + addReservedKeyWord("REDO_BUFFER_SIZE".toLowerCase()); + addReservedKeyWord("REDUNDANT".toLowerCase()); addReservedKeyWord("REFERENCES".toLowerCase()); addReservedKeyWord("REGEXP".toLowerCase()); + addReservedKeyWord("RELAY".toLowerCase()); + addReservedKeyWord("RELAYLOG".toLowerCase()); + addReservedKeyWord("RELAY_LOG_FILE".toLowerCase()); + addReservedKeyWord("RELAY_LOG_POS".toLowerCase()); + addReservedKeyWord("RELAY_THREAD".toLowerCase()); addReservedKeyWord("RELEASE".toLowerCase()); + addReservedKeyWord("RELOAD".toLowerCase()); + addReservedKeyWord("REMOVE".toLowerCase()); addReservedKeyWord("RENAME".toLowerCase()); + addReservedKeyWord("REORGANIZE".toLowerCase()); + addReservedKeyWord("REPAIR".toLowerCase()); addReservedKeyWord("REPEAT".toLowerCase()); + addReservedKeyWord("REPEATABLE".toLowerCase()); addReservedKeyWord("REPLACE".toLowerCase()); + addReservedKeyWord("REPLICATE_DO_DB".toLowerCase()); + addReservedKeyWord("REPLICATE_DO_TABLE".toLowerCase()); + addReservedKeyWord("REPLICATE_IGNORE_DB".toLowerCase()); + addReservedKeyWord("REPLICATE_IGNORE_TABLE".toLowerCase()); + addReservedKeyWord("REPLICATE_REWRITE_DB".toLowerCase()); + addReservedKeyWord("REPLICATE_WILD_DO_TABLE".toLowerCase()); + addReservedKeyWord("REPLICATE_WILD_IGNORE_TABLE".toLowerCase()); + addReservedKeyWord("REPLICATION".toLowerCase()); addReservedKeyWord("REQUIRE".toLowerCase()); + addReservedKeyWord("RESET".toLowerCase()); addReservedKeyWord("RESIGNAL".toLowerCase()); + addReservedKeyWord("RESTORE".toLowerCase()); addReservedKeyWord("RESTRICT".toLowerCase()); + addReservedKeyWord("RESUME".toLowerCase()); addReservedKeyWord("RETURN".toLowerCase()); + addReservedKeyWord("RETURNED_SQLSTATE".toLowerCase()); + addReservedKeyWord("RETURNS".toLowerCase()); + addReservedKeyWord("REVERSE".toLowerCase()); addReservedKeyWord("REVOKE".toLowerCase()); addReservedKeyWord("RIGHT".toLowerCase()); addReservedKeyWord("RLIKE".toLowerCase()); + addReservedKeyWord("ROLLBACK".toLowerCase()); + addReservedKeyWord("ROLLUP".toLowerCase()); + addReservedKeyWord("ROTATE".toLowerCase()); + addReservedKeyWord("ROUTINE".toLowerCase()); + addReservedKeyWord("ROW".toLowerCase()); + addReservedKeyWord("ROWS".toLowerCase()); + addReservedKeyWord("ROW_COUNT".toLowerCase()); + addReservedKeyWord("ROW_FORMAT".toLowerCase()); + addReservedKeyWord("RTREE".toLowerCase()); + addReservedKeyWord("SAVEPOINT".toLowerCase()); + addReservedKeyWord("SCHEDULE".toLowerCase()); addReservedKeyWord("SCHEMA".toLowerCase()); addReservedKeyWord("SCHEMAS".toLowerCase()); + addReservedKeyWord("SCHEMA_NAME".toLowerCase()); + addReservedKeyWord("SECOND".toLowerCase()); addReservedKeyWord("SECOND_MICROSECOND".toLowerCase()); + addReservedKeyWord("SECURITY".toLowerCase()); addReservedKeyWord("SELECT".toLowerCase()); addReservedKeyWord("SENSITIVE".toLowerCase()); addReservedKeyWord("SEPARATOR".toLowerCase()); + addReservedKeyWord("SERIAL".toLowerCase()); + addReservedKeyWord("SERIALIZABLE".toLowerCase()); + addReservedKeyWord("SERVER".toLowerCase()); + addReservedKeyWord("SESSION".toLowerCase()); addReservedKeyWord("SET".toLowerCase()); + addReservedKeyWord("SHARE".toLowerCase()); addReservedKeyWord("SHOW".toLowerCase()); + addReservedKeyWord("SHUTDOWN".toLowerCase()); addReservedKeyWord("SIGNAL".toLowerCase()); + addReservedKeyWord("SIGNED".toLowerCase()); + addReservedKeyWord("SIMPLE".toLowerCase()); + addReservedKeyWord("SLAVE".toLowerCase()); + addReservedKeyWord("SLOW".toLowerCase()); addReservedKeyWord("SMALLINT".toLowerCase()); + addReservedKeyWord("SNAPSHOT".toLowerCase()); + addReservedKeyWord("SOCKET".toLowerCase()); + addReservedKeyWord("SOME".toLowerCase()); + addReservedKeyWord("SONAME".toLowerCase()); + addReservedKeyWord("SOUNDS".toLowerCase()); + addReservedKeyWord("SOURCE".toLowerCase()); addReservedKeyWord("SPATIAL".toLowerCase()); addReservedKeyWord("SPECIFIC".toLowerCase()); addReservedKeyWord("SQL".toLowerCase()); addReservedKeyWord("SQLEXCEPTION".toLowerCase()); addReservedKeyWord("SQLSTATE".toLowerCase()); addReservedKeyWord("SQLWARNING".toLowerCase()); + addReservedKeyWord("SQL_AFTER_GTIDS".toLowerCase()); + addReservedKeyWord("SQL_AFTER_MTS_GAPS".toLowerCase()); + addReservedKeyWord("SQL_BEFORE_GTIDS".toLowerCase()); addReservedKeyWord("SQL_BIG_RESULT".toLowerCase()); + addReservedKeyWord("SQL_BUFFER_RESULT".toLowerCase()); + addReservedKeyWord("SQL_CACHE".toLowerCase()); addReservedKeyWord("SQL_CALC_FOUND_ROWS".toLowerCase()); + addReservedKeyWord("SQL_NO_CACHE".toLowerCase()); addReservedKeyWord("SQL_SMALL_RESULT".toLowerCase()); + addReservedKeyWord("SQL_THREAD".toLowerCase()); + addReservedKeyWord("SQL_TSI_DAY".toLowerCase()); + addReservedKeyWord("SQL_TSI_HOUR".toLowerCase()); + addReservedKeyWord("SQL_TSI_MINUTE".toLowerCase()); + addReservedKeyWord("SQL_TSI_MONTH".toLowerCase()); + addReservedKeyWord("SQL_TSI_QUARTER".toLowerCase()); + addReservedKeyWord("SQL_TSI_SECOND".toLowerCase()); + addReservedKeyWord("SQL_TSI_WEEK".toLowerCase()); + addReservedKeyWord("SQL_TSI_YEAR".toLowerCase()); addReservedKeyWord("SSL".toLowerCase()); + addReservedKeyWord("STACKED".toLowerCase()); + addReservedKeyWord("START".toLowerCase()); addReservedKeyWord("STARTING".toLowerCase()); + addReservedKeyWord("STARTS".toLowerCase()); + addReservedKeyWord("STATS_AUTO_RECALC".toLowerCase()); + addReservedKeyWord("STATS_PERSISTENT".toLowerCase()); + addReservedKeyWord("STATS_SAMPLE_PAGES".toLowerCase()); + addReservedKeyWord("STATUS".toLowerCase()); + addReservedKeyWord("STOP".toLowerCase()); + addReservedKeyWord("STORAGE".toLowerCase()); + addReservedKeyWord("STORED".toLowerCase()); addReservedKeyWord("STRAIGHT_JOIN".toLowerCase()); + addReservedKeyWord("STRING".toLowerCase()); + addReservedKeyWord("SUBCLASS_ORIGIN".toLowerCase()); + addReservedKeyWord("SUBJECT".toLowerCase()); + addReservedKeyWord("SUBPARTITION".toLowerCase()); + addReservedKeyWord("SUBPARTITIONS".toLowerCase()); + addReservedKeyWord("SUPER".toLowerCase()); + addReservedKeyWord("SUSPEND".toLowerCase()); + addReservedKeyWord("SWAPS".toLowerCase()); + addReservedKeyWord("SWITCHES".toLowerCase()); addReservedKeyWord("TABLE".toLowerCase()); + addReservedKeyWord("TABLES".toLowerCase()); + addReservedKeyWord("TABLESPACE".toLowerCase()); + addReservedKeyWord("TABLE_CHECKSUM".toLowerCase()); + addReservedKeyWord("TABLE_NAME".toLowerCase()); + addReservedKeyWord("TEMPORARY".toLowerCase()); + addReservedKeyWord("TEMPTABLE".toLowerCase()); addReservedKeyWord("TERMINATED".toLowerCase()); + addReservedKeyWord("TEXT".toLowerCase()); + addReservedKeyWord("THAN".toLowerCase()); addReservedKeyWord("THEN".toLowerCase()); + addReservedKeyWord("TIME".toLowerCase()); + addReservedKeyWord("TIMESTAMP".toLowerCase()); + addReservedKeyWord("TIMESTAMPADD".toLowerCase()); + addReservedKeyWord("TIMESTAMPDIFF".toLowerCase()); addReservedKeyWord("TINYBLOB".toLowerCase()); addReservedKeyWord("TINYINT".toLowerCase()); addReservedKeyWord("TINYTEXT".toLowerCase()); addReservedKeyWord("TO".toLowerCase()); addReservedKeyWord("TRAILING".toLowerCase()); + addReservedKeyWord("TRANSACTION".toLowerCase()); addReservedKeyWord("TRIGGER".toLowerCase()); + addReservedKeyWord("TRIGGERS".toLowerCase()); addReservedKeyWord("TRUE".toLowerCase()); + addReservedKeyWord("TRUNCATE".toLowerCase()); + addReservedKeyWord("TYPE".toLowerCase()); + addReservedKeyWord("TYPES".toLowerCase()); + addReservedKeyWord("UNCOMMITTED".toLowerCase()); + addReservedKeyWord("UNDEFINED".toLowerCase()); addReservedKeyWord("UNDO".toLowerCase()); + addReservedKeyWord("UNDOFILE".toLowerCase()); + addReservedKeyWord("UNDO_BUFFER_SIZE".toLowerCase()); + addReservedKeyWord("UNICODE".toLowerCase()); + addReservedKeyWord("UNINSTALL".toLowerCase()); addReservedKeyWord("UNION".toLowerCase()); addReservedKeyWord("UNIQUE".toLowerCase()); + addReservedKeyWord("UNKNOWN".toLowerCase()); addReservedKeyWord("UNLOCK".toLowerCase()); addReservedKeyWord("UNSIGNED".toLowerCase()); + addReservedKeyWord("UNTIL".toLowerCase()); addReservedKeyWord("UPDATE".toLowerCase()); + addReservedKeyWord("UPGRADE".toLowerCase()); addReservedKeyWord("USAGE".toLowerCase()); addReservedKeyWord("USE".toLowerCase()); + addReservedKeyWord("USER".toLowerCase()); + addReservedKeyWord("USER_RESOURCES".toLowerCase()); + addReservedKeyWord("USE_FRM".toLowerCase()); addReservedKeyWord("USING".toLowerCase()); addReservedKeyWord("UTC_DATE".toLowerCase()); addReservedKeyWord("UTC_TIME".toLowerCase()); addReservedKeyWord("UTC_TIMESTAMP".toLowerCase()); + addReservedKeyWord("VALIDATION".toLowerCase()); + addReservedKeyWord("VALUE".toLowerCase()); addReservedKeyWord("VALUES".toLowerCase()); addReservedKeyWord("VARBINARY".toLowerCase()); addReservedKeyWord("VARCHAR".toLowerCase()); addReservedKeyWord("VARCHARACTER".toLowerCase()); + addReservedKeyWord("VARIABLES".toLowerCase()); addReservedKeyWord("VARYING".toLowerCase()); + addReservedKeyWord("VIEW".toLowerCase()); + addReservedKeyWord("VIRTUAL".toLowerCase()); + addReservedKeyWord("WAIT".toLowerCase()); + addReservedKeyWord("WARNINGS".toLowerCase()); + addReservedKeyWord("WEEK".toLowerCase()); + addReservedKeyWord("WEIGHT_STRING".toLowerCase()); addReservedKeyWord("WHEN".toLowerCase()); addReservedKeyWord("WHERE".toLowerCase()); addReservedKeyWord("WHILE".toLowerCase()); addReservedKeyWord("WITH".toLowerCase()); + addReservedKeyWord("WITHOUT".toLowerCase()); + addReservedKeyWord("WORK".toLowerCase()); + addReservedKeyWord("WRAPPER".toLowerCase()); addReservedKeyWord("WRITE".toLowerCase()); + addReservedKeyWord("X509".toLowerCase()); + addReservedKeyWord("XA".toLowerCase()); + addReservedKeyWord("XID".toLowerCase()); + addReservedKeyWord("XML".toLowerCase()); addReservedKeyWord("XOR".toLowerCase()); + addReservedKeyWord("YEAR".toLowerCase()); addReservedKeyWord("YEAR_MONTH".toLowerCase()); addReservedKeyWord("ZEROFILL".toLowerCase()); }
