ALTER SQL_PARSER RULE
描述
ALTER SQL_PARSER RULE 语法用于修改解析引擎规则配置。
语法
AlterSqlParserRule ::=
'ALTER' 'SQL_PARSER' 'RULE' '(' sqlParserRuleDefinition ')'
sqlParserRuleDefinition ::=
parseTreeCacheDefinition? (',' sqlStatementCacheDefinition)?
parseTreeCacheDefinition ::=
'PARSE_TREE_CACHE' '(' cacheOption ')'
sqlStatementCacheDefinition ::=
'SQL_STATEMENT_CACHE' '(' cacheOption ')'
cacheOption ::=
('INITIAL_CAPACITY' '=' initialCapacity)? (','? 'MAXIMUM_SIZE' '=' maximumSize)?
initialCapacity ::=
int
maximumSize ::=
int补充说明
-
PARSE_TREE_CACHE：语法树本地缓存配置 -
SQL_STATEMENT_CACHE：SQL 语句本地缓存配置项
示例
- 修改 SQL 解析引擎规则
ALTER SQL_PARSER RULE (
PARSE_TREE_CACHE(INITIAL_CAPACITY=128, MAXIMUM_SIZE=1024),
SQL_STATEMENT_CACHE(INITIAL_CAPACITY=2000, MAXIMUM_SIZE=65535)
);保留字
ALTER、SQL_PARSER、RULE、PARSE_TREE_CACHE、INITIAL_CAPACITY、MAXIMUM_SIZE、SQL_STATEMENT_CACHE