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
