Retro Eye care Haitian Deep Dark Default

CREATE SHARDING AUDITOR

Description

The CREATE SHARDING AUDITOR syntax is used to add a sharding key auditor for the currently selected logic database

Syntax

CreateShardingAlgorithm ::=
  'CREATE' 'SHARDING' 'AUDITOR' auditorName '(' algorithmDefinition ')'

algorithmDefinition ::=
  'TYPE' '(' 'NAME' '=' algorithmType ( ',' 'PROPERTIES'  '(' propertyDefinition  ')' )?')'  

propertyDefinition ::=
  ( key  '=' value ) ( ',' key  '=' value )*

auditorName ::=
  identifier
  
algorithmType ::=
  string

Supplement

  • algorithmType is the sharding audit algorithm type. For detailed sharding audit algorithm type information, please refer to SHARDING AUDIT ALGORITHM.

Example

Create a sharding auditor

CREATE SHARDING AUDITOR sharding_key_required_auditor (
    TYPE(NAME="DML_SHARDING_CONDITIONS", PROPERTIES("a"="b"))
);

Reserved word

CREATE, SHARDING, AUDITOR, TYPE, NAME, PROPERTIES