ALTER SQL_PARSER RULE

Description

The ALTER SQL_PARSER RULE syntax is used to alter sql parser rule configuration.

Syntax

Grammar Railroad diagram

  1. AlterSqlParserRule ::=
  2.   'ALTER' 'SQL_PARSER' 'RULE' 'SQL_COMMENT_PARSE_ENABLE' '=' sqlCommentParseEnable ',' 'PARSE_TREE_CACHE' parseTreeCacheDefinition ',' 'SQL_STATEMENT_CACHE' sqlStatementCacheDefinition
  4. sqlCommentParseEnable ::=
  5.   boolean
  7. parseTreeCacheDefinition ::=
  8.   '(' 'INITIAL_CAPACITY' '=' initialCapacity ',' 'MAXIMUM_SIZE' '=' maximumSize ',' 'CONCURRENCY_LEVEL' '=' concurrencyLevel ')'
  10. sqlStatementCacheDefinition ::=
  11.   '(' 'INITIAL_CAPACITY' '=' initialCapacity ',' 'MAXIMUM_SIZE' '=' maximumSize ',' 'CONCURRENCY_LEVEL' '=' concurrencyLevel ')'
  13. initialCapacity ::=
  14.   int
  16. maximumSize ::=
  17.   int
  19. concurrencyLevel ::=
  20.   int

Supplement

  • SQL_COMMENT_PARSE_ENABLE: whether to parse the SQL comment

  • PARSE_TREE_CACHE: local cache configuration of syntax tree

  • SQL_STATEMENT_CACHE: local cache of SQL statement

Example

  • Alter sql parser rule
  1. ALTER SQL_PARSER RULE 
  2.   SQL_COMMENT_PARSE_ENABLE=false, 
  3.   PARSE_TREE_CACHE(INITIAL_CAPACITY=10, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=1), 
  4.   SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100);

Reserved word

ALTER, SQL_PARSER, RULE, SQL_COMMENT_PARSE_ENABLE, PARSE_TREE_CACHE, INITIAL_CAPACITY, MAXIMUM_SIZE, CONCURRENCY_LEVEL, SQL_STATEMENT_CACHE