SQL_Parser #
| Syntax | Description | Type |
|---|---|---|
| ALTER SQL_PARSER RULE SQL_COMMENT_PARSE_ENABLE=xx, PARSE_TREE_CACHE(INITIAL_CAPACITY=xx, MAXIMUM_SIZE=xx, CONCURRENCY_LEVEL=xx), SQL_STATEMENT_CACHE(INITIAL_CAPACITY=xxx, MAXIMUM_SIZE=xxx, CONCURRENCY_LEVEL=xxx) | Update parser engine rule configuration | RAL |
| SHOW SQL_PARSER RULE | Query parser engine rule configuration | RQL |
1. Update Parser Engine Rule Configuration #
ALTER SQL_PARSER RULE SQL_COMMENT_PARSE_ENABLED=xx, PARSE_TREE_CACHE(INITIAL_CAPACITY=xx, MAXIMUM_SIZE=xx, CONCURRENCY_LEVEL=xx), SQL_STATEMENT_CACHE(INITIAL_CAPACITY=xxx, MAXIMUM_SIZE=xxx, CONCURRENCY_LEVEL=xxx)
Parameter Explanation
SQL_COMMENT_PARSE_ENABLED: Whether to use string interception to parse SQL comments; PARSE_TREE_CACHE: Parse tree local cache configuration; SQL_STATEMENT_CACHE: SQL statement local cache configuration
Example
ALTER SQL_PARSER RULE SQL_COMMENT_PARSE_ENABLED=false, PARSE_TREE_CACHE(INITIAL_CAPACITY=10, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=1), SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100)
2. Query Parser Engine Rule Configuration #
SHOW SQL_PARSER RULE
Parameter Explanation
None
Example
SHOW SQL_PARSER RULE;