CREATE DEFAULT SHADOW ALGORITHM

Description

The CREATE DEFAULT SHADOW ALGORITHM syntax is used to create a default shadow algorithm.

Syntax

Grammar Railroad diagram

  1. CreateDefaultShadowAlgorithm ::=
  2.   'CREATE' 'DEFAULT' 'SHADOW' 'ALGORITHM' ifNotExists? shadowAlgorithm 
  4. ifNotExists ::=
  5.   'IF' 'NOT' 'EXISTS'
  7. shadowAlgorithm ::=
  8.   'TYPE' '(' 'NAME' '=' shadowAlgorithmType ',' propertiesDefiinition ')'
  10. shadowAlgorithmType ::=
  11.   string
  13. propertiesDefinition ::=
  14.   'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  16. key ::=
  17.   string
  19. value ::=
  20.   literal

Supplement

  • shadowAlgorithmType currently supports VALUE_MATCH, REGEX_MATCH and SQL_HINT;
  • ifNotExists clause is used for avoid Duplicate default shadow algorithm error.

Example

  • Create default shadow algorithm
  1. CREATE DEFAULT SHADOW ALGORITHM TYPE(NAME="SQL_HINT");
  • Create default shadow algorithm with ifNotExist clause
  1. CREATE DEFAULT SHADOW ALGORITHM IF NOT EXISTS TYPE(NAME="SQL_HINT");

Reserved word

CREATE, DEFAULT, SHADOW, ALGORITHM, TYPE, NAME, PROPERTIES