SHOW SQL_PARSER RULE

Description

The SHOW SQL_PARSER RULE syntax is used to query sql parser rule configuration.

Syntax

Grammar Railroad diagram

  1. ShowSqlParserRule ::=
  2.   'SHOW' 'SQL_PARSER' 'RULE'

Return Value Description

ColumeDescription
sql_comment_parse_enablesql comment parse enable status
parse_tree_cacheparse tree cache configuration
sql_statement_cachesql statement cache configuration

Example

  • Query sql parser rule configuration
  1. SHOW SQL_PARSER RULE;
  1. mysql> SHOW SQL_PARSER RULE;
  2. +--------------------------+-----------------------------------------+-------------------------------------------+
  3. | sql_comment_parse_enable | parse_tree_cache                        | sql_statement_cache                       |
  4. +--------------------------+-----------------------------------------+-------------------------------------------+
  5. | false                    | initialCapacity: 128, maximumSize: 1024 | initialCapacity: 2000, maximumSize: 65535 |
  6. +--------------------------+-----------------------------------------+-------------------------------------------+
  7. 1 row in set (0.05 sec)

Reserved word

SHOW, SQL_PARSER, RULE