The ALTER SHADOW RULE syntax is used to alter shadow rule.
AlterShadowRule ::=
'ALTER' 'SHADOW' 'RULE' shadowDefinition ( ',' shadowDefinition )*
shadowDefinition ::=
ruleName '(' storageUnitMapping shadowTableRule ( ',' shadowTableRule )* ')'
storageUnitMapping ::=
'SOURCE' '=' storageUnitName ',' 'SHADOW' '=' storageUnitName
shadowTableRule ::=
tableName '(' shadowAlgorithm ')'
shadowAlgorithm ::=
'TYPE' '(' 'NAME' '=' shadowAlgorithmType ',' 'PROPERTIES' '(' 'key' '=' 'value' ( ',' 'key' '=' 'value' ) ')'
ruleName ::=
identifier
storageUnitName ::=
identifier
tableName ::=
identifier
algorithmName ::=
identifier
shadowAlgorithmType ::
storageUnitMapping specifies the mapping relationship between the source database and the shadow library. You need to
use the storage unit managed by RDL, please refer
to STORAGE UNIT;shadowAlgorithm can act on multiple shadowTableRule at the same time;algorithmName is not specified, it will be automatically generated according to ruleName, tableName
and shadowAlgorithmType;shadowAlgorithmType currently supports VALUE_MATCH, REGEX_MATCH and SIMPLE_HINT.ALTER SHADOW RULE shadow_rule(
SOURCE=demo_su,
SHADOW=demo_su_shadow,
t_order(TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))),
t_order_item(TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))
);
ALTER, SHADOW, RULE, SOURCE, SHADOW, TYPE, NAME, PROPERTIES