复古 护眼 海天 深邃 暗黑 默认

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)
);

保留字

ALTERSQL_PARSERRULEPARSE_TREE_CACHEINITIAL_CAPACITYMAXIMUM_SIZESQL_STATEMENT_CACHE

相关链接