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

ColumnDescription
sql_comment_parse_enabledSQL comment parse enabled 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_enabled | 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