OceanBase1.0版本中保留的关键字 ,如下表所示。
NAMEOB | STRING_VALUE | INTNUM | DATE_VALUE | TIMESTAMP_VALUE |
HINT_VALUE | BOOL_VALUE | APPROXNUM | DECIMAL_VAL | NULLX |
QUESTIONMARK | SYSTEM_VARIABLE | TEMP_VARIABLE | CLIENT_VERSION | MYSQL_DRIVER |
HEX_STRING_VALUE | EXCEPT | UNION | INTERSECT | INNER |
RIGHT | FULL | LEFT | CROSS | JOIN |
SET_VAR | OR_OP | OR | XOR | AND_OP |
AND | ELSE | THEN | WHEN | CASE |
BETWEEN | LOWER_THAN_COMP | REGEXP | IN | LIKE |
IS | COMP_NE | COMP_LT | COMP_LE | COMP_GT |
COMP_GE | COMP_NSEQ | COMP_EQ | ESCAPE | SHIFT_RIGHT |
SHIFT_LEFT | POW | DIV | MOD | LOWER_THAN_NEG |
CNNOP | NEG | NOT2 | NOT | COLLATE |
BINARY | INTERVAL | LOWER_KEY | KEY | ERROR |
READ_STATIC | INDEX_HINT | USE_NL | FROZEN_VERSION | TOPK |
QUERY_TIMEOUT | READ_CONSISTENCY | HOTSPOT | LOG_LEVEL | LEADING_HINT |
ORDERED | FULL_HINT | USE_MERGE | USE_HASH | USE_PLAN_CACHE |
STRONG | FROZEN | STATIC | WEAK | _BINARY |
_UTF8 | _UTF8MB4 | HINT_BEGIN | HINT_END | END_P |
ACCESSIBLE | ADD | ALTER | ANALYZE | ALL |
AS | ASENSITIVE | ASC | BEFORE | BIGINT |
BLOB | BOTH | BY | CALL | CASCADE |
CHANGE | CHAR | CHARACTER | CHECK | CONDITION |
CONSTRAINT | CONTINUE | CONVERT | COLUMN | CREATE |
CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
DAY_HOUR | DAY_MICROSECOND | DAY_MINUTE | DAY_SECOND | DATABASE |
DATABASES | DEC | DECIMAL | DECLARE | DEFAULT |
DELAYED | DELETE | DESC | DESCRIBE | DETERMINISTIC |
DISTINCT | DISTINCTROW | DOUBLE | DROP | DUAL |
EACH | ENCLOSED | ELSEIF | ESCAPED | EXISTS |
EXIT | EXPLAIN | FETCH | FOREIGN | FLOAT |
FLOAT4 | FLOAT8 | FOR | FORCE | FROM |
FULLTEXT | GET | GRANT | GROUP | HAVING |
HIGH_PRIORITY | HOUR_MICROSECOND | HOUR_MINUTE | HOUR_SECOND | IF |
IFIGNORE | INDEX | INFILE | INOUT | INSENSITIVE |
INT | INT1 | INT2 | INT3 | INT4 |
INT8 | INTEGER | INSERT | INTO | IO_AFTER_GTIDS |
IO_BEFORE_GTIDS | ISNULL | ITERATE | KEYS | KILL |
LEADING | LEAVE | LIMIT | LINEAR | LINES |
LOAD | LOCALTIME | LOCALTIMESTAMP | LOCK | LONG |
LONGBLOB | LONGTEXT | LOOP | LOWPRIORITY | MASTER_BIND |
MASTER_SSL_VERIFY_SERVER_CERT | MATCH | MAXVALUE | MEDIUMBLOB | MEDIUMINT |
MEDIUMTEXT | MIDDLEINT | MINUTE_MICROSECOND | MINUTE_SECOND | MODIFIES |
NATURAL | NO_WRITE_TO_BINLOG | NUMERIC | ON | OPTION |
OPTIMIZE | OPTIONALLY | ORDER | OUT | OUTER |
OUTFILE | PROCEDURE | PURGE | PARTITION | PRECISION |
PRIMARY | RANGE | READ | READ_WRITE | READS |
REAL | RELEASE | REFERENCES | RENAME | REPLACE |
REPEAT | REQUIRE | RESIGNAL | RESTRICT | RETURN |
REVOKE | RLIKE | SECOND_MICROSECOND | SELECT | SCHEMA |
SCHEMAS | SEPARATOR | SET | SENSITIVE | SHOW |
SIGNAL | SMALLINT | SPATIAL | SPECIFIC | SQL |
SQLEXCEPTION | SQLSTATE | SQLWARNING | SQL_BIG_RESULT | SQL_CALC_FOUND_ROWS |
SQL_SMALL_RESULT | SSL | STARTING | STRAIGHTJOIN | TERMINATED |
TINYBLOB | TINYINTTINYTEXT | TABLE | TABLEGROUP | TO |
TRAILING | TRIGGER | UNDO | UNIQUE | UNLOCK |
UNSIGNED | UPDATE | USAGE | USE | USING |
UTC_DATE | UTC_TIME | UTC_TIMESTAMP | VALUES | VARBINARY |
VARCHAR | VARCHARACTER | VARYING | WHERE | WHILE |
WITH | WRITE | YEAR_MONTH | ZEROFILL | GLOBAL_ALIAS |
SESSION_ALIAS | ACCOUNT | ACTION | ACTIVE | ADDDATE |
AFTER | AGAINST | AGGREGATE | ALGORITHM | ANALYSE |
ANY | ASCII | AT | AUTHORS | AUTOEXTEND_SIZE |
AUTO_INCREMENT | AVG | AVG_ROW_LENGTH | BACKUP | BASIC |
BEGI | BINLOG | BIT | BLOCK | BLOCK_SIZE |
BOOL | BOOLEAN | BOOTSTRAP | BTREE | BYTE |
CACHE | CANCEL | CASCADED | CAST | CATALOG_NAME |
CHAIN | CHANGED | CHARSET | CHECKSUM | CIPHER |
CLASS_ORIGIN | CLEAN | CLEAR | CLIENT | CLOSE |
COALESCE | CODE | COLLATION | COLUMN_FORMAT | COLUMN_NAME |
COLUMNS | COMMENT | COMMIT | COMMITTED | COMPACT |
COMPLETION | COMPRESSED | COMPRESSION | CONCURRENT | CONNECTION |
CONSISTENT | CONSISTENT_MODE | CONSTRAINT_CATALOG | CONSTRAINT_NAME | CONSTRAINT_SCHEMA |
CONTAINS | CONTEXT | CONTRIBUTORS | COPY | COUNT |
CPU | CREATE_TIMESTAMP | CUBE | CURDATE | CURRENT |
CURTIME | CURSOR_NAME | DATA | DATAFILE | DATE |
DATE_ADD | DATE_SUB | DATETIME | DAY | DEALLOCATE |
DEFAULT_AUTH | DEFINER | DELAY | DELAY_KEY_WRITE | DES_KEY_FILE |
DESTINATION | DIAGNOSTICS | DIRECTORY | DISABLE | DISCARD |
DISK | DO | DUMP | DUMPFILE | DUPLICATE |
DYNAMIC | EFFECTIVE | ENABLE | END | ENDS |
ENGINE | ENGINES | ENUM | ERRORP | ERRORS |
EVENT | EVENTS | EVERY | EXCHANGE | EXECUTE |
EXPANSION | EXPIRE | EXPIRE_INFO | EXPORT | EXTENDED |
EXTENT_SIZE | EXTRACT | FAST | FAULTS | FIELDS |
FILEX | FINAL_COUNT | FIRST | FIXED | FLUSH |
FOLLOWER | FORMAT | FOUND | FREEZE | FUNCTION |
GENERAL | GEOMETRY | GEOMETRYCOLLECTION | GET_FORMAT | GLOBAL |
GRANTS | GROUP_CONCAT | HANDLER | HASH | HELP |
HOST | HOSTS | HOUR | IDENTIFIED | IGNORE |
IGNORE_SERVER_IDS | IMPORT | INDEXES | INITIAL_SIZE | INSERT_METHOD |
INSTALL | INVOKER | IO | IO_THREAD | IPC |
ISOLATION | ISSUER | JSON | KEY_BLOCK_SIZE | KEY_VERSION |
LANGUAGE | LAST | LEADER | LEAVES | LESS |
LEVEL | LINESTRING | LIST | LOCAL | LOCKED |
LOCKS | LOGFILE | LOGS | MAJOR | MASTER |
MASTERAUTO_POSITION | MASTER_CONNECT_RETRY | MASTER_DELAY | MASTER_HEARTBEAT_PERIOD | MASTER_HOST |
MASTER_LOG_FILE | MASTER_LOG_POS | MASTER_PASSWORD | MASTER_PORT | MASTER_RETRY_COUNT |
MASTER_SERVER_ID | MASTER_SSL | MASTER_SSL_CA | MASTER_SSL_CAPATH | MASTER_SSL_CERT |
MASTER_SSL_CIPHER | MASTER_SSL_CRL | MASTER_SSL_CRLPATH | MASTER_SSL_KEY | MASTER_USER |
MAX | MAX_CONNECTIONS_PER_HOUR | MAX_CPU | MAX_DISK_SIZE | MAX_IOPS |
MAX_MEMORY | MAX_QUERIES_PER_HOUR | MAX_ROWS | MAX_SESSION_NUM | MAX_SIZE |
MAX_UPDATES_PER_HOUR | MAX_USER_CONNECTIONS | MEDIUM | MEMORY | MEMTABLE |
MERGE | MESSAGE_TEXT | META | MICROSECOND | MIGRATE |
MIN | MIN_CPU | MIN_IOPS | MIN_MEMORY | MINOR |
MIN_ROWS | MINUTE | MODE | MODIFY | MONTH |
MOVE | MULTILINESTRING | MULTIPOINT | MULTIPOLYGON | MUTEX |
MYSQL_ERRNO | NAME | NAMES | NATIONAL | NCHAR |
NDB | NDBCLUSTER | NEW | NEXT | NO |
NODEGROUP | NONE | NORMAL | NOW | NOWAIT |
NO_WAIT | NUMBER | NVARCHAR | OFF | OFFSET |
OLD_PASSWORD | ONE | ONE_SHOT | ONLY | OPEN |
OPTIONS | OWNER | PACK_KEYS | PAGE | PARAMETERS |
PARSER | PARTIAL | PARTITION_ID | PARTITIONING | PARTITIONS |
PASSWORD | PAUSE | PHASE | PLUGIN | PLUGIN_DIR |
PLUGINS | POINT | POLYGON | POOL | PORT |
PREPARE | PRESERVE | PREV | PRIMARY_ZONE | PRIVILEGES |
PROCESSLIST | PROFILE | PROFILES | PROXY | QUARTER |
QUERY | QUICK | READ_ONLY | REBUILD | RECOVER |
RECYCLE | REDO_BUFFER_SIZE | REDOFILE | REDUNDANT | REFRESH |
RELAY | RELAYLOG | RELAY_LOG_FILE | RELAY_LOG_POS | RELAY_THREAD |
RELOAD | REMOVE | REORGANIZE | REPAIR | REPEATABLE |
REPLICA | REPLICA_NUM | REPLICATION | REPORT | RESET |
RESOURCE | RESOURCE_POOL_LIST | RESTART | RESTORE | RESUME |
RETURNED_SQLSTATE | RETURNS | REVERSE | ROLLBACK | ROLLUP |
ROOT | ROOTTABLE | ROUTINE | ROW | ROW_COUNT |
ROW_FORMAT | ROWS | RTREE | SAVEPOINT | SCHEDULE |
SCHEMA_NAME | SCOPE | SECOND | SECURITY | SERIAL |
SERIALIZABLE | SERVER | SERVER_IP | SERVER_PORT | SERVER_TYPE |
SESSION | SESSION_USER | SET_MASTER_CLUSTER | SET_SLAVE_CLUSTER | SHARE |
SHUTDOWN | SIGNED | SIMPLE | SLAVE | SLOW |
SNAPSHOT | SOCKET | SOME | SONAME | SOUNDS |
SOURCE | SPFILE | SQL_AFTER_GTIDS | SQL_AFTER_MTS_GAPS | SQL_BEFORE_GTIDS |
SQL_BUFFER_RESULT | SQL_CACHE | SQL_NO_CACHE | SQL_THREAD | SQL_TSI_DAY |
SQL_TSI_HOUR | SQL_TSI_MINUTE | SQL_TSI_MONTH | SQL_TSI_QUARTER | SQL_TSI_SECOND |
SQL_TSI_WEEK | SQL_TSI_YEAR | START | STARTS | STATS_AUTO_RECALC |
STATS_PERSISTENT | STATS_SAMPLE_PAGES | STATUS | STEP_MERGE_NUM | STOP |
STORAGE | STORING | STRING | SUBCLASS_ORIGIN | SUBDATE |
SUBJECT | SUBPARTITION | SUBPARTITIONS | SUBSTR | SUBSTRING |
SUM | SUPER | SUSPEND | SWAPS | SWITCH |
SWITCHES | SYSTEM | SYSTEM_USER | TABLE_CHECKSUM | TABLE_ID |
TABLE_NAME | TABLEGROUPS | TABLES | TABLESPACE | TABLET |
TABLET_MAX_SIZE | TEMPORARY | TEMPTABLE | TENANT | TEXT |
THAN | TIME | TIMESTAMP | TIMESTAMPADD | TIMESTAMPDIFF |
TINYINT | TRADITIONAL | TRANSACTION | TRIGGERS | TRIM |
TRUNCATE | TYPE | TYPES | UNCOMMITTED | UNDEFINED |
UNDO_BUFFER_SIZE | UNDOFILE | UNICODE | UNINSTALL | UNIT |
UNIT_NUM | UNLOCKED | UNTIL | UNUSUAL | UPGRADE |
USE_BLOOM_FILTER | UNKNOWN | USE_FRM | USER | USER_RESOURCES |
VALUE | VARIABLES | VERBOSE | VIEW | WAIT |
WARNINGS | WEEK | WEIGHT_STRING | WORK | WRAPPER |
X509 | XA | XML | YEAR | ZONE |
ZONE_LIST | LOCATION | PLAN | HIGHER_THAN_NEG |
|