The CREATE DEFAULT SHADOW ALGORITHM
syntax is used to create a default shadow algorithm.
CreateDefaultShadowAlgorithm ::=
'CREATE' 'DEFAULT' 'SHADOW' 'ALGORITHM' ifNotExists? shadowAlgorithm
ifNotExists ::=
'IF' 'NOT' 'EXISTS'
shadowAlgorithm ::=
'TYPE' '(' 'NAME' '=' shadowAlgorithmType ',' propertiesDefiinition ')'
shadowAlgorithmType ::=
string
propertiesDefinition ::=
'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
key ::=
string
value ::=
literal
shadowAlgorithmType
currently supports VALUE_MATCH
, REGEX_MATCH
and SIMPLE_HINT
;ifNotExists
clause is used for avoid Duplicate default shadow algorithm
error.CREATE DEFAULT SHADOW ALGORITHM TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"));
ifNotExist
clauseCREATE DEFAULT SHADOW ALGORITHM IF NOT EXISTS TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"));
CREATE
, DEFAULT
, SHADOW
, ALGORITHM
, TYPE
, NAME
, PROPERTIES