ALTER SQL_TRANSLATOR RULE 语法用于修改 SQL 翻译器规则配置。
AlterSQLTranslatorRule ::=
'ALTER' 'SQL_TRANSLATOR' 'RULE' '(' sqlTranslatorRuleDefinition ')'
sqlTranslatorRuleDefinition ::=
algorithmDefinition (',' useOriginalSQLWhenTranslatingFailedClause)?
algorithmDefinition ::=
'TYPE' '(' 'NAME' '=' translatorType (',' 'PROPERTIES' '(' propertiesDefinition ')' )? ')'
useOriginalSQLWhenTranslatingFailedClause ::=
'USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED' '=' booleanLiteral
translatorType ::=
identifier
propertiesDefinition ::=
property (',' property)*
property ::=
key '=' value
booleanLiteral ::=
'TRUE' | 'FALSE'
TYPE 用于声明 SQL 翻译器实现及其 PROPERTIES。USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED 用于控制翻译失败时是否回退到原始 SQL。ALTER SQL_TRANSLATOR RULE (
TYPE(NAME='NATIVE', PROPERTIES('key'='value')),
USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED=TRUE
);
ALTER SQL_TRANSLATOR RULE (
TYPE(NAME='NATIVE', PROPERTIES('key'='value'))
);
ALTER、SQL_TRANSLATOR、RULE、TYPE、NAME、PROPERTIES、USE_ORIGINAL_SQL_WHEN_TRANSLATING_FAILED、TRUE、FALSE