OceanBase 通用語法

常量

• ?INT_VALUE?：匹配整數(shù)類型常量，如? 123?。

• ?DECIMAL_VALUE?：匹配定點(diǎn)類型常量，如?123.456?。

• ?STR_VALUE?：匹配字符串常量，如 ?abc?。

• ?NULL?：匹配 NULL 常量。

• ?STORAGE_SIZE?：匹配存儲長度常量，整數(shù)形式默認(rèn)單位為字節(jié)，字符串形式可指定單位為M或G，如?1024?或?'500M'?。

const_value:
      INT_VALUE
    | DECIMAL_VALUE
    | STR_VALUE
    | NULL
    | STORAGE_SIZE

STORAGE_SIZE:
      INT_VALUE
    | 'INT_VALUE[M|G]'

字符集

charset:
      default_charset
    | column_charset

default_charset:
    [DEFAULT] {CHARSET | CHARACTER SET} [=] {UTF8 | UTF8MB4 | BINARY}

column_charset:
    {CHARSET | CHARACTER SET} {UTF8 | UTF8MB4 | BINARY}

排序規(guī)則

collate:
      default_collate
    | column_collate

default_collate:
    [DEFAULT] COLLATE [=] {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY}

column_collate:
    COLLATE {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY}

數(shù)據(jù)類型

data_type:
      TINYINT[(precision)] [UNSIGNED] [ZEROFILL] 
    | SMALLINT[(precision)] [UNSIGNED] [ZEROFILL] 
    | MEDIUMINT[(precision)] [UNSIGNED] [ZEROFILL] 
    | INT[(precision)] [UNSIGNED] [ZEROFILL] 
    | INTEGER[(precision)] [UNSIGNED] [ZEROFILL] 
    | BIGINT[(precision)] [UNSIGNED] [ZEROFILL] 
    | FLOAT[(precision, scale)] [UNSIGNED] [ZEROFILL] 
    | DOUBLE[(precision, scale)] [UNSIGNED] [ZEROFILL] 
    | DECIMAL[(precision [, scale])] [UNSIGNED] [ZEROFILL] 
    | NUMERIC[(precision [, scale])] [UNSIGNED] [ZEROFILL] 
    | DATETIME[(scale)] 
    | TIMESTAMP[(scale)] 
    | DATE
    | TIME[(scale)] 
    | YEAR
    | VARCHAR(length) column_charset column_collate
    | VARBINARY(length)
    | CHAR[(length)] column_charset column_collate
    | BINARY[(length)]
    | TINYTEXT column_charset column_collate
    | TINYLOB
    | TEXT[(length)] column_charset column_collate
    | BLOB[(length)]
    | MEDIUMTEXT column_charset column_collate
    | MEDIUMBLOB
    | LONGTEXT column_charset column_collate
    | LONGBLOB

precision | scale | length:
    INT_VALUE

SQL屬性

• 對象名

tenant_name | pool_name | unit_name | zone_name | region_name:
    STR_VALUE

database_name | table_name | table_alias_name | column_name| column_alias_name  | partition_name | subpartition_name:
    STR_VALUE

index_name | view_name | object_name | constraint_name | tablegroup_name:
    STR_VALUE

outline_name | user_name:
    STR_VALUE

table_factor:
    [[database_name].] table_name

column_factor:
    [table_factor.] column_name

• 表達(dá)式

expression:
      const_value
    | column_factor
    | operator_expression
    | function_expression

• 注釋

comment:
    COMMENT 'comment_text'

comment_text:
    STR_VALUE

分布式屬性

• ?PRIMARY_ZONE?：指定數(shù)據(jù)的主副本分布策略。

primary_zone:
    PRIMARY_ZONE [=] zone_name

• ?ZONE_LIST?：指定租戶的資源分布策略。

zone_list:
    ZONE_LIST [=] (zone_name [, zone_name ...])

• ?REPLICA_NUM?：指定數(shù)據(jù)的副本份數(shù)。

replica_num:
    REPLICA_NUM [=] INT_VALUE

• ?TABLEGROUP?：指定多份數(shù)據(jù)的主副本分布策略。

tablegroup:
      default_tablegroup
    | table_tablegroup

default_tablegroup:
    DEFAULT TABLEGROUP [=] {tablegroup_name | NULL}

table_tablegroup:
    TABLEGROUP [=] {tablegroup_name | NULL}

存儲屬性

• ?BLOCK_SIZE?：指定對象存儲的微塊長度。

block_size:
    BLOCK_SIZE [=] INT_VALUE

• ?COMPRESSION?：指定對象存儲的壓縮算法。

compression:
    COMPRESSION [=] {NONE | LZ4_1.0 | LZ0_1.0 | SNAPPY_1.0 | ZLIB_1.0}

• ?PCTFREE?：指定對象存儲的宏塊預(yù)留百分比。

pctfree:
    PCTFREE [=] INT_VALUE

• ?TABLET_SIZE?：指定并行合并時(shí)單個(gè)任務(wù)的最小分片。

tablet_size:
    TABLET_SIZE [=] INT_VALUE