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