parse_tree_nodes.h

Go to the documentation of this file.

/* Copyright (c) 2013, 2024, Oracle and/or its affiliates.
 
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License, version 2.0,
   as published by the Free Software Foundation.
 
   This program is designed to work with certain software (including
   but not limited to OpenSSL) that is licensed under separate terms,
   as designated in a particular file or component or in included license
   documentation.  The authors of MySQL hereby grant you an additional
   permission to link the program and your derivative works with the
   separately licensed software that they have either included with
   the program or referenced in the documentation.
 
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License, version 2.0, for more details.
 
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA */
 
#ifndef PARSE_TREE_NODES_INCLUDED
#define PARSE_TREE_NODES_INCLUDED
 
#include <assert.h>
#include <sys/types.h>  // TODO: replace with cstdint
 
#include <bit>
#include <cctype>  // std::isspace
#include <cstddef>
#include <memory>
 
#include "lex_string.h"
#include "my_alloc.h"
#include "my_base.h"
 
#include "my_inttypes.h"  // TODO: replace with cstdint
#include "my_list.h"
#include "my_sqlcommand.h"
#include "my_sys.h"
#include "my_thread_local.h"
#include "my_time.h"
#include "mysqld_error.h"
#include "sql/check_stack.h"
#include "sql/enum_query_type.h"
#include "sql/handler.h"
#include "sql/key_spec.h"
#include "sql/mem_root_array.h"
#include "sql/opt_explain.h"  // Sql_cmd_explain_other_thread
#include "sql/parse_location.h"
#include "sql/parse_tree_helpers.h"  // PT_item_list
#include "sql/parse_tree_node_base.h"
#include "sql/parser_yystype.h"
#include "sql/partition_info.h"
#include "sql/resourcegroups/resource_group_basic_types.h"
#include "sql/resourcegroups/resource_group_sql_cmd.h"
#include "sql/set_var.h"
#include "sql/sp_head.h"
#include "sql/sql_admin.h"  // Sql_cmd_shutdown etc.
#include "sql/sql_alter.h"
#include "sql/sql_check_constraint.h"  // Sql_check_constraint_spec
#include "sql/sql_cmd_srs.h"
#include "sql/sql_exchange.h"
#include "sql/sql_lex.h"  // LEX
#include "sql/sql_list.h"
#include "sql/sql_load.h"  // Sql_cmd_load_table
#include "sql/sql_partition_admin.h"
#include "sql/sql_restart_server.h"  // Sql_cmd_restart_server
#include "sql/sql_tablespace.h"      // Tablespace_options
#include "sql/sql_truncate.h"        // Sql_cmd_truncate_table
#include "sql/table.h"               // Common_table_expr
#include "sql/tablesample.h"
#include "sql/window_lex.h"
#include "string_with_len.h"
#include "thr_lock.h"
 
class Item;
class Item_cache;
class Json_table_column;
class PT_column_attr_base;
class PT_field_def_base;
class PT_hint_list;
class PT_insert_values_list;
class PT_part_definition;
class PT_partition;
class PT_subquery;
class PT_type;
class PT_window_list;
class Sql_cmd;
class String;
class THD;
class Window;
class sp_head;
class sp_name;
struct CHARSET_INFO;
 
/**
  @defgroup ptn  Parse tree nodes
  @ingroup  Parser
*/
/**
  @defgroup ptn_stmt  Nodes representing SQL statements
  @ingroup  ptn
*/
/**
  @defgroup ptn_create_table  CREATE TABLE statement
  @ingroup  ptn_stmt
*/
/**
  @defgroup ptn_alter_table  ALTER TABLE statement
  @ingroup  ptn_stmt
*/
/**
  @defgroup ptn_create_table_stuff  Clauses of CREATE TABLE statement
  @ingroup  ptn_create_table
*/
/**
  @defgroup ptn_partitioning CREATE/ALTER TABLE partitioning-related stuff
  @ingroup  ptn_create_table ptn_alter_table
*/
/**
  @defgroup ptn_part_options Partition options in CREATE/ALTER TABLE
  @ingroup  ptn_partitioning
*/
/**
  @defgroup ptn_create_or_alter_table_options  Table options of CREATE/ALTER
  TABLE
  @anchor   ptn_create_or_alter_table_options
  @ingroup  ptn_create_table ptn_alter_table
*/
/**
  @defgroup ptn_col_types  Column types in CREATE/ALTER TABLE
  @ingroup  ptn_create_table ptn_alter_table
*/
/**
  @defgroup ptn_col_attrs  Column attributes in CREATE/ALTER TABLE
  @ingroup  ptn_create_table ptn_alter_table
*/
/**
  @defgroup ptn_not_gcol_attr Non-generated column attributes in CREATE/ALTER
  TABLE
  @ingroup ptn_col_attrs ptn_alter_table
*/
 
/**
  Calls contextualize() on every node in the array.
*/
template <class Node_type, class Parse_context_type>
bool contextualize_nodes(Mem_root_array_YY<Node_type *> nodes,
                         Parse_context_type *pc) {
  for (Node_type *i : nodes)
    if (i->contextualize(pc)) return true;
  return false;
}
 
/**
  Base class for all top-level nodes of SQL statements
 
  @ingroup ptn_stmt
*/
class Parse_tree_root {
  Parse_tree_root(const Parse_tree_root &) = delete;
  void operator=(const Parse_tree_root &) = delete;
 
 protected:
  Parse_tree_root() = default;
  explicit Parse_tree_root(const POS &pos) : m_pos(pos) {}
  virtual ~Parse_tree_root() = default;
 
 public:
  /// Textual location of a token just parsed.
  POS m_pos;
 
  virtual Sql_cmd *make_cmd(THD *thd) = 0;
 
  // Return Json parse tree generated by SHOW PARSE_TREE.
  virtual std::string get_printable_parse_tree(THD *thd [[maybe_unused]]) {
    my_error(ER_NOT_SUPPORTED_YET, MYF(0),
             "Parse tree display of this statement");
    return "";
  }
};
 
class PT_table_ddl_stmt_base : public Parse_tree_root {
 public:
  explicit PT_table_ddl_stmt_base(const POS &pos, MEM_ROOT *mem_root)
      : Parse_tree_root(pos), m_alter_info(mem_root) {}
 
  ~PT_table_ddl_stmt_base() override = 0;  // force abstract class
 
 protected:
  Alter_info m_alter_info;
};
 
inline PT_table_ddl_stmt_base::~PT_table_ddl_stmt_base() = default;
 
/**
  Parse context for the table DDL (ALTER TABLE and CREATE TABLE) nodes.
 
  For internal use in the contextualization code.
*/
struct Table_ddl_parse_context final : public Parse_context {
  Table_ddl_parse_context(THD *thd_arg, Query_block *select_arg,
                          Alter_info *alter_info);
  HA_CREATE_INFO *const create_info;
  Alter_info *const alter_info;
  KEY_CREATE_INFO *const key_create_info;
};
 
/**
  Base class for all table DDL (ALTER TABLE and CREATE TABLE) nodes.
*/
typedef Parse_tree_node_tmpl<Table_ddl_parse_context> Table_ddl_node;
 
class PT_order_expr : public Parse_tree_node, public ORDER {
  typedef Parse_tree_node super;
 
 public:
  PT_order_expr(const POS &pos, Item *item_arg, enum_order dir) : super(pos) {
    item_initial = item_arg;
    direction = (dir == ORDER_DESC) ? ORDER_DESC : ORDER_ASC;
  }
 
  bool do_contextualize(Parse_context *pc) override;
 
 protected:
  void add_json_info(Json_object *obj) override {
    obj->add_alias("desc",
                   create_dom_ptr<Json_boolean>(direction == ORDER_DESC));
  }
};
 
class PT_order_list : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  SQL_I_List<ORDER> value;
 
 public:
  explicit PT_order_list(const POS &pos) : super(pos) {}
 
  bool do_contextualize(Parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    for (ORDER *o = value.first; o != nullptr; o = o->next) {
      if (static_cast<PT_order_expr *>(o)->contextualize(pc)) return true;
    }
    return false;
  }
 
  void push_back(PT_order_expr *order) {
    order->used_alias = nullptr;
    order->used = 0;
    value.link_in_list(order, &order->next);
  }
};
 
class PT_gorder_list : public PT_order_list {
  typedef PT_order_list super;
 
 public:
  explicit PT_gorder_list(const POS &pos) : super(pos) {}
 
  bool do_contextualize(Parse_context *pc) override {
    return super::do_contextualize(pc);
  }
};
 
/**
  Represents an element of the WITH list:
  WITH [...], [...] SELECT ...,
         ^  or  ^
  i.e. a Common Table Expression (CTE, or Query Name in SQL99 terms).
*/
class PT_common_table_expr : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  explicit PT_common_table_expr(const POS &pos, const LEX_STRING &name,
                                const LEX_STRING &subq_text,
                                uint subq_text_offset, PT_subquery *sn,
                                const Create_col_name_list *column_names,
                                MEM_ROOT *mem_root);
 
  /// The name after AS
  const LEX_STRING &name() const { return m_name; }
  /**
    @param      thd  Thread handler
    @param[out] node PT_subquery
    @returns a PT_subquery to attach to a table reference for this CTE
  */
  bool make_subquery_node(THD *thd, PT_subquery **node);
  /**
    @param tl  Table reference to match
    @param in_self  If this is a recursive reference
    @param[out]  found Is set to true/false if matches or not
    @returns true if error
  */
  bool match_table_ref(Table_ref *tl, bool in_self, bool *found);
  /**
    @returns true if 'other' is the same instance as 'this'
  */
  bool is(const Common_table_expr *other) const {
    return other == &m_postparse;
  }
  void print(const THD *thd, String *str, enum_query_type query_type);
  bool do_contextualize(Parse_context *pc) override;
 
 protected:
  void add_json_info(Json_object *obj) override;
 
 private:
  LEX_STRING m_name;
  /// Raw text of query expression (including parentheses)
  const LEX_STRING m_subq_text;
  /**
    Offset in bytes of m_subq_text in original statement which had the WITH
    clause.
  */
  uint m_subq_text_offset;
  /// Parsed version of subq_text
  PT_subquery *const m_subq_node;
  /// List of explicitly specified column names; if empty, no list.
  const Create_col_name_list m_column_names;
  /**
    A Table_ref representing a CTE needs access to the WITH list
    element it derives from. However, in order to:
    - limit the members which Table_ref can access
    - avoid including this header file everywhere Table_ref needs to
    access these members, these members are relocated into a separate inferior
    object whose declaration is in table.h, like that of Table_ref. It's
    the "postparse" part. Table_ref accesses this inferior object only.
  */
  Common_table_expr m_postparse;
 
  friend bool Query_expression::clear_correlated_query_blocks();
};
 
/**
   Represents the WITH list.
   WITH [...], [...] SELECT ...,
        ^^^^^^^^^^^^
*/
class PT_with_list : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  /// @param pos Position of this clause in the SQL statement.
  /// @param mem_root where interior objects are allocated
  explicit PT_with_list(const POS &pos, MEM_ROOT *mem_root)
      : super(pos), m_elements(mem_root) {}
  bool push_back(PT_common_table_expr *el);
  const Mem_root_array<PT_common_table_expr *> &elements() const {
    return m_elements;
  }
 
 private:
  Mem_root_array<PT_common_table_expr *> m_elements;
};
 
/**
  Represents the WITH clause:
  WITH [...], [...] SELECT ...,
  ^^^^^^^^^^^^^^^^^
*/
class PT_with_clause : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  PT_with_clause(const POS &pos, const PT_with_list *l, bool r)
      : super(pos),
        m_list(l),
        m_recursive(r),
        m_most_inner_in_parsing(nullptr) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  /**
    Looks up a table reference into the list of CTEs.
    @param      tl    Table reference to look up
    @param[out] found Is set to true/false if found or not
    @returns true if error
  */
  bool lookup(Table_ref *tl, PT_common_table_expr **found);
  /**
    Call this to record in the WITH clause that we are contextualizing the
    CTE definition inserted in table reference 'tl'.
    @returns information which the caller must provide to
    leave_parsing_definition().
  */
  const Table_ref *enter_parsing_definition(Table_ref *tl) {
    auto old = m_most_inner_in_parsing;
    m_most_inner_in_parsing = tl;
    return old;
  }
  void leave_parsing_definition(const Table_ref *old) {
    m_most_inner_in_parsing = old;
  }
  void print(const THD *thd, String *str, enum_query_type query_type);
 
 protected:
  void add_json_info(Json_object *obj) override {
    obj->add_alias("recursive", create_dom_ptr<Json_boolean>(m_recursive));
  }
 
 private:
  /// All CTEs of this clause
  const PT_with_list *const m_list;
  /// True if the user has specified the RECURSIVE keyword.
  const bool m_recursive;
  /**
    The innermost CTE reference which we're parsing at the
    moment. Used to detect forward references, loops and recursiveness.
  */
  const Table_ref *m_most_inner_in_parsing;
 
  friend bool Query_expression::clear_correlated_query_blocks();
};
 
class PT_select_item_list : public PT_item_list {
  typedef PT_item_list super;
 
 public:
  explicit PT_select_item_list(const POS &pos) : super(pos) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_limit_clause : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  Limit_options limit_options;
 
 protected:
  void add_json_info(Json_object *obj) override {
    obj->add_alias("is_offset_first",
                   create_dom_ptr<Json_boolean>(limit_options.is_offset_first));
  }
 
 public:
  PT_limit_clause(const POS &pos, const Limit_options &limit_options_arg)
      : super(pos), limit_options(limit_options_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
  friend class PT_query_expression;
};
 
class PT_cross_join;
class PT_joined_table;
 
class PT_table_reference : public Parse_tree_node {
 public:
  explicit PT_table_reference(const POS &pos) : Parse_tree_node(pos) {}
 
  Table_ref *m_table_ref{nullptr};
 
  /**
    Lets us build a parse tree top-down, which is necessary due to the
    context-dependent nature of the join syntax. This function adds
    the @<table_ref@> cross join as the left-most leaf in this join tree
    rooted at this node.
 
    @todo: comment on non-join PT_table_reference objects
 
    @param cj This @<table ref@> will be added if it represents a cross join.
 
    @return The new top-level join.
  */
  virtual PT_joined_table *add_cross_join(PT_cross_join *cj);
};
 
class PT_table_factor_table_ident : public PT_table_reference {
  typedef PT_table_reference super;
 
  Table_ident *table_ident;
  List<String> *opt_use_partition;
  const char *const opt_table_alias;
  List<Index_hint> *opt_key_definition;
  PT_tablesample *opt_tablesample{nullptr};
 
 public:
  PT_table_factor_table_ident(const POS &pos, Table_ident *table_ident_arg,
                              List<String> *opt_use_partition_arg,
                              const LEX_CSTRING &opt_table_alias_arg,
                              List<Index_hint> *opt_key_definition_arg,
                              PT_tablesample *opt_tablesample_arg)
      : super(pos),
        table_ident(table_ident_arg),
        opt_use_partition(opt_use_partition_arg),
        opt_table_alias(opt_table_alias_arg.str),
        opt_key_definition(opt_key_definition_arg),
        opt_tablesample(opt_tablesample_arg) {}
 
 protected:
  bool do_contextualize(Parse_context *pc) override;
  void add_json_info(Json_object *obj) override;
};
 
class PT_json_table_column : public Parse_tree_node {
 protected:
  explicit PT_json_table_column(const POS &pos) : Parse_tree_node(pos) {}
 
 public:
  virtual Json_table_column *get_column() = 0;
};
 
class PT_table_factor_function : public PT_table_reference {
  typedef PT_table_reference super;
 
 public:
  PT_table_factor_function(const POS &pos, Item *expr, Item *path,
                           Mem_root_array<PT_json_table_column *> *nested_cols,
                           const LEX_STRING &table_alias)
      : super(pos),
        m_expr(expr),
        m_path(path),
        m_nested_columns(nested_cols),
        m_table_alias(table_alias) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  Item *m_expr;
  Item *m_path;
  Mem_root_array<PT_json_table_column *> *m_nested_columns;
  const LEX_STRING m_table_alias;
};
 
class PT_table_reference_list_parens : public PT_table_reference {
  typedef PT_table_reference super;
 
  Mem_root_array_YY<PT_table_reference *> table_list;
 
 public:
  explicit PT_table_reference_list_parens(
      const POS &pos, const Mem_root_array_YY<PT_table_reference *> table_list)
      : super(pos), table_list(table_list) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_derived_table : public PT_table_reference {
  typedef PT_table_reference super;
 
 public:
  PT_derived_table(const POS &pos, bool lateral, PT_subquery *subquery,
                   const LEX_CSTRING &table_alias,
                   Create_col_name_list *column_names);
 
  bool do_contextualize(Parse_context *pc) override;
 
 protected:
  void add_json_info(Json_object *obj) override;
 
 private:
  bool m_lateral;
  PT_subquery *m_subquery;
  const char *const m_table_alias;
  /// List of explicitly specified column names; if empty, no list.
  const Create_col_name_list column_names;
};
 
class PT_table_factor_joined_table : public PT_table_reference {
  typedef PT_table_reference super;
 
 public:
  PT_table_factor_joined_table(const POS &pos, PT_joined_table *joined_table)
      : super(pos), m_joined_table(joined_table) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  PT_joined_table *m_joined_table;
};
 
class PT_joined_table : public PT_table_reference {
  typedef PT_table_reference super;
 
 protected:
  PT_table_reference *m_left_pt_table;
  POS m_join_pos;
  PT_joined_table_type m_type;
  PT_table_reference *m_right_pt_table;
 
  Table_ref *m_left_table_ref{nullptr};
  Table_ref *m_right_table_ref{nullptr};
 
 public:
  PT_joined_table(const POS &pos, PT_table_reference *tab1_node_arg,
                  const POS &join_pos_arg, PT_joined_table_type type,
                  PT_table_reference *tab2_node_arg)
      : super(pos),
        m_left_pt_table(tab1_node_arg),
        m_join_pos(join_pos_arg),
        m_type(type),
        m_right_pt_table(tab2_node_arg) {
    using std::has_single_bit;
    static_assert(has_single_bit(unsigned{JTT_INNER}), "not a single bit");
    static_assert(has_single_bit(unsigned{JTT_STRAIGHT}), "not a single bit");
    static_assert(has_single_bit(unsigned{JTT_NATURAL}), "not a single bit");
    static_assert(has_single_bit(unsigned{JTT_LEFT}), "not a single bit");
    static_assert(has_single_bit(unsigned{JTT_RIGHT}), "not a single bit");
 
    assert(type == JTT_INNER || type == JTT_STRAIGHT_INNER ||
           type == JTT_NATURAL_INNER || type == JTT_NATURAL_LEFT ||
           type == JTT_NATURAL_RIGHT || type == JTT_LEFT || type == JTT_RIGHT);
  }
 
  /**
    Adds the cross join to this join operation. The cross join is nested as
    the table reference on the left-hand side.
  */
  PT_joined_table *add_cross_join(PT_cross_join *cj) override {
    m_left_pt_table = m_left_pt_table->add_cross_join(cj);
    return this;
  }
 
  /// Adds the table reference as the right-hand side of this join.
  void add_rhs(PT_table_reference *table) {
    assert(m_right_pt_table == nullptr);
    m_right_pt_table = table;
  }
 
  bool do_contextualize(Parse_context *pc) override;
 
  /// This class is being inherited, it should thus be abstract.
  ~PT_joined_table() override = 0;
 
 protected:
  bool contextualize_tabs(Parse_context *pc);
  void add_json_info(Json_object *obj) override;
};
 
inline PT_joined_table::~PT_joined_table() = default;
 
class PT_cross_join : public PT_joined_table {
  typedef PT_joined_table super;
 
 public:
  PT_cross_join(const POS &pos, PT_table_reference *tab1_node_arg,
                const POS &join_pos_arg, PT_joined_table_type Type_arg,
                PT_table_reference *tab2_node_arg)
      : PT_joined_table(pos, tab1_node_arg, join_pos_arg, Type_arg,
                        tab2_node_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_joined_table_on : public PT_joined_table {
  typedef PT_joined_table super;
  Item *on;
 
 public:
  PT_joined_table_on(const POS &pos, PT_table_reference *tab1_node_arg,
                     const POS &join_pos_arg, PT_joined_table_type type,
                     PT_table_reference *tab2_node_arg, Item *on_arg)
      : super(pos, tab1_node_arg, join_pos_arg, type, tab2_node_arg),
        on(on_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_joined_table_using : public PT_joined_table {
  typedef PT_joined_table super;
  List<String> *using_fields;
 
 public:
  PT_joined_table_using(const POS &pos, PT_table_reference *tab1_node_arg,
                        const POS &join_pos_arg, PT_joined_table_type type,
                        PT_table_reference *tab2_node_arg,
                        List<String> *using_fields_arg)
      : super(pos, tab1_node_arg, join_pos_arg, type, tab2_node_arg),
        using_fields(using_fields_arg) {}
 
  /// A PT_joined_table_using without a list of columns denotes a natural join.
  PT_joined_table_using(const POS &pos, PT_table_reference *tab1_node_arg,
                        const POS &join_pos_arg, PT_joined_table_type type,
                        PT_table_reference *tab2_node_arg)
      : PT_joined_table_using(pos, tab1_node_arg, join_pos_arg, type,
                              tab2_node_arg, nullptr) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 protected:
  void add_json_info(Json_object *obj) override;
};
 
/*
  PT_tablesample - parse tree node
 
  Information contained in TABLESAMPLE clause is here.
*/
class PT_tablesample : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  tablesample_type m_sampling_type;
  Item *m_sample_percentage{nullptr};
 
  PT_tablesample(const POS &pos, tablesample_type tablesample_type_arg,
                 Item *sample_percentage)
      : super(pos),
        m_sampling_type(tablesample_type_arg),
        m_sample_percentage(sample_percentage) {}
};
 
class PT_group : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  PT_order_list *group_list;
  olap_type olap;
 
 protected:
  void add_json_info(Json_object *obj) override {
    if (olap == ROLLUP_TYPE)
      obj->add_alias("olap_options", create_dom_ptr<Json_string>("ROLLUP"));
    // Only rollup type supported.
  }
 
 public:
  PT_group(const POS &pos, PT_order_list *group_list_arg, olap_type olap_arg)
      : super(pos), group_list(group_list_arg), olap(olap_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_order : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  PT_order_list *order_list;
  explicit PT_order(const POS &pos, PT_order_list *order_list_arg)
      : super(pos), order_list(order_list_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_locking_clause : public Parse_tree_node {
 public:
  PT_locking_clause(const POS &pos, Lock_strength strength,
                    Locked_row_action action)
      : Parse_tree_node(pos),
        m_lock_strength(strength),
        m_locked_row_action(action) {}
 
  bool do_contextualize(Parse_context *pc) final;
 
  virtual bool set_lock_for_tables(Parse_context *pc) = 0;
 
  Locked_row_action action() const { return m_locked_row_action; }
 
 protected:
  Lock_descriptor get_lock_descriptor() const {
    thr_lock_type lock_type = TL_IGNORE;
    switch (m_lock_strength) {
      case Lock_strength::UPDATE:
        lock_type = TL_WRITE;
        break;
      case Lock_strength::SHARE:
        lock_type = TL_READ_WITH_SHARED_LOCKS;
        break;
    }
 
    return {lock_type, static_cast<thr_locked_row_action>(action())};
  }
 
 private:
  Lock_strength m_lock_strength;
  Locked_row_action m_locked_row_action;
};
 
class PT_query_block_locking_clause : public PT_locking_clause {
 public:
  explicit PT_query_block_locking_clause(
      const POS &pos, Lock_strength strength,
      Locked_row_action action = Locked_row_action::WAIT)
      : PT_locking_clause(pos, strength, action) {}
 
  bool set_lock_for_tables(Parse_context *pc) override;
};
 
class PT_table_locking_clause : public PT_locking_clause {
 public:
  typedef Mem_root_array_YY<Table_ident *> Table_ident_list;
 
  PT_table_locking_clause(const POS &pos, Lock_strength strength,
                          Mem_root_array_YY<Table_ident *> tables,
                          Locked_row_action action)
      : PT_locking_clause(pos, strength, action), m_tables(tables) {}
 
  bool set_lock_for_tables(Parse_context *pc) override;
 
 private:
  bool raise_error(THD *thd, const Table_ident *name, int error);
 
  bool raise_error(int error);
 
  Table_ident_list m_tables;
};
 
class PT_locking_clause_list : public Parse_tree_node {
 public:
  PT_locking_clause_list(const POS &pos, MEM_ROOT *mem_root)
      : Parse_tree_node(pos) {
    m_locking_clauses.init(mem_root);
  }
 
  bool push_back(PT_locking_clause *locking_clause) {
    return m_locking_clauses.push_back(locking_clause);
  }
 
  bool do_contextualize(Parse_context *pc) override {
    for (auto locking_clause : m_locking_clauses)
      if (locking_clause->contextualize(pc)) return true;
    return false;
  }
 
 private:
  Mem_root_array_YY<PT_locking_clause *> m_locking_clauses{};
};
 
class PT_query_expression_body : public Parse_tree_node {
 public:
  explicit PT_query_expression_body(const POS &pos) : Parse_tree_node(pos) {}
  enum Setop_type { NONE, UNION, INTERSECT, EXCEPT };
  virtual Setop_type type() const { return NONE; }
  virtual bool is_set_operation() const = 0;
  /**
    True if this query expression can absorb an extraneous order by/limit
    clause. The `ORDER BY`/`LIMIT` syntax is mostly consistestent, i.e. a
    trailing clause may not refer to the tables in the `<query primary>`, with
    one glaring exception:
 
        (...( SELECT ... )...) ORDER BY ...
 
    If the nested query expression doesn't contain `ORDER BY`, the statement
    is interpreted as if the `ORDER BY` was absorbed by the innermost query
    expression, i.e.:
 
        (...( SELECT ... ORDER BY ... )...)
 
    There is no rewriting of the parse tree nor AST happening here, the
    transformation is done by the contextualizer (see
    PT_query_expression::contextualize_order_and_limit), which interprets the
    parse tree, and builds the AST according to this interpretation. This
    interpretation is governed by the following rule: An `ORDER BY` can be
    absorbed if none the nested query expressions contains an `ORDER BY` *or*
    `LIMIT`. The rule is complex, so here are some examples for illustration:
 
    In these cases the `ORDER BY` *is* absorbed:
 
        ( SELECT * FROM t1 ) ORDER BY t1.a;
        (( SELECT * FROM t1 )) ORDER BY t1.a;
 
    In these cases the ORDER BY is *not* absorbed:
 
        ( SELECT * FROM t1 ORDER BY 1 ) ORDER BY t1.a;
        (( SELECT * FROM t1 ) ORDER BY 1 ) ORDER BY t1.a;
        ( SELECT * FROM t1 LIMIT 1 ) ORDER BY t1.a;
        (( SELECT * FROM t1 ) LIMIT 1 ) ORDER BY t1.a;
 
    The same happens with `LIMIT`, obviously, but the optimizer is freeer to
    choose when to apply the limit, and there are name no resolution issues
    involved.
 
    @param order  True if the outer query block has the ORDER BY clause.
    @param limit  True if the outer query block has the LIMIT clause.
  */
  virtual bool can_absorb_order_and_limit(bool order, bool limit) const = 0;
  virtual bool has_into_clause() const = 0;
  virtual bool has_trailing_into_clause() const = 0;
 
  virtual bool is_table_value_constructor() const = 0;
  virtual PT_insert_values_list *get_row_value_list() const = 0;
};
 
class PT_set_scoped_system_variable : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  PT_set_scoped_system_variable(const POS &pos, const POS &var_pos,
                                const LEX_CSTRING &opt_prefix,
                                const LEX_CSTRING &name, Item *opt_expr)
      : super(pos),
        m_varpos(var_pos),
        m_opt_prefix{opt_prefix},
        m_name{name},
        m_opt_expr{opt_expr} {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  const POS m_varpos;
  const LEX_CSTRING m_opt_prefix;
  const LEX_CSTRING m_name;
  Item *m_opt_expr;
};
 
class PT_option_value_no_option_type : public Parse_tree_node {
 protected:
  explicit PT_option_value_no_option_type(const POS &pos)
      : Parse_tree_node(pos) {}
};
 
class PT_set_variable : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
 public:
  PT_set_variable(const POS &pos, const POS &varpos,
                  const LEX_CSTRING &opt_prefix, const LEX_CSTRING &name,
                  const POS &expr_pos, Item *opt_expr)
      : super{pos},
        m_varpos{varpos},
        m_opt_prefix{opt_prefix},
        m_name{name},
        m_expr_pos{expr_pos},
        m_opt_expr{opt_expr} {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  const POS m_varpos;
  const LEX_CSTRING m_opt_prefix;
  const LEX_CSTRING m_name;
  const POS m_expr_pos;
  Item *m_opt_expr;
};
 
class PT_option_value_no_option_type_user_var
    : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
  LEX_STRING name;
  Item *expr;
 
 public:
  PT_option_value_no_option_type_user_var(const POS &pos,
                                          const LEX_STRING &name_arg,
                                          Item *expr_arg)
      : super(pos), name(name_arg), expr(expr_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_set_system_variable : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
 public:
  PT_set_system_variable(const POS &pos, enum_var_type scope,
                         const POS &name_pos, const LEX_CSTRING &opt_prefix,
                         const LEX_CSTRING &name, Item *opt_expr)
      : super(pos),
        m_scope{scope},
        m_name_pos{name_pos},
        m_opt_prefix{opt_prefix},
        m_name{name},
        m_opt_expr{opt_expr} {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  const enum_var_type m_scope;
  const POS m_name_pos;
  const LEX_CSTRING m_opt_prefix;
  const LEX_CSTRING m_name;
  Item *m_opt_expr;
};
 
class PT_option_value_no_option_type_charset
    : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
  const CHARSET_INFO *opt_charset;
 
 public:
  PT_option_value_no_option_type_charset(const POS &pos,
                                         const CHARSET_INFO *opt_charset_arg)
      : super(pos), opt_charset(opt_charset_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_option_value_no_option_type_names
    : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
  POS m_error_pos;
 
 public:
  explicit PT_option_value_no_option_type_names(const POS &pos,
                                                const POS &error_pos)
      : super(pos), m_error_pos(error_pos) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_set_names : public PT_option_value_no_option_type {
  typedef PT_option_value_no_option_type super;
 
  const CHARSET_INFO *opt_charset;
  const CHARSET_INFO *opt_collation;
 
 public:
  PT_set_names(const POS &pos, const CHARSET_INFO *opt_charset_arg,
               const CHARSET_INFO *opt_collation_arg)
      : super(pos),
        opt_charset(opt_charset_arg),
        opt_collation(opt_collation_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_start_option_value_list : public Parse_tree_node {
 protected:
  explicit PT_start_option_value_list(const POS &pos) : Parse_tree_node(pos) {}
};
 
class PT_option_value_no_option_type_password
    : public PT_start_option_value_list {
  typedef PT_start_option_value_list super;
 
  const char *password;
  const char *current_password;
  bool retain_current_password;
  bool random_password_generator;
  POS expr_pos;
 
 public:
  PT_option_value_no_option_type_password(const POS &pos,
                                          const char *password_arg,
                                          const char *current_password_arg,
                                          bool retain_current,
                                          bool random_password,
                                          const POS &expr_pos_arg)
      : super(pos),
        password(password_arg),
        current_password(current_password_arg),
        retain_current_password(retain_current),
        random_password_generator(random_password),
        expr_pos(expr_pos_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_option_value_no_option_type_password_for
    : public PT_start_option_value_list {
  typedef PT_start_option_value_list super;
 
  LEX_USER *user;
  const char *password;
  const char *current_password;
  bool retain_current_password;
  bool random_password_generator;
  POS expr_pos;
 
 public:
  PT_option_value_no_option_type_password_for(
      const POS &pos, LEX_USER *user_arg, const char *password_arg,
      const char *current_password_arg, bool retain_current, bool random_pass,
      const POS &expr_pos_arg)
      : super(pos),
        user(user_arg),
        password(password_arg),
        current_password(current_password_arg),
        retain_current_password(retain_current),
        random_password_generator(random_pass),
        expr_pos(expr_pos_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_option_value_type : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  enum_var_type type;
  PT_set_scoped_system_variable *value;
 
 public:
  PT_option_value_type(const POS &pos, enum_var_type type_arg,
                       PT_set_scoped_system_variable *value_arg)
      : super(pos), type(type_arg), value(value_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_option_value_list_head : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  POS delimiter_pos;
  Parse_tree_node *value;
  POS value_pos;
 
 public:
  PT_option_value_list_head(const POS &pos, const POS &delimiter_pos_arg,
                            Parse_tree_node *value_arg,
                            const POS &value_pos_arg)
      : super(pos),
        delimiter_pos(delimiter_pos_arg),
        value(value_arg),
        value_pos(value_pos_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_option_value_list : public PT_option_value_list_head {
  typedef PT_option_value_list_head super;
 
  PT_option_value_list_head *head;
 
 public:
  PT_option_value_list(const POS &pos, PT_option_value_list_head *head_arg,
                       const POS &delimiter_pos_arg, Parse_tree_node *tail,
                       const POS &tail_pos)
      : super(pos, delimiter_pos_arg, tail, tail_pos), head(head_arg) {}
 
  bool do_contextualize(Parse_context *pc) override {
    uchar dummy;
    if (check_stack_overrun(pc->thd, STACK_MIN_SIZE, &dummy)) return true;
    return head->contextualize(pc) || super::do_contextualize(pc);
  }
};
 
class PT_start_option_value_list_no_type : public PT_start_option_value_list {
  typedef PT_start_option_value_list super;
 
  PT_option_value_no_option_type *head;
  POS head_pos;
  PT_option_value_list_head *tail;
 
 public:
  PT_start_option_value_list_no_type(const POS &pos,
                                     PT_option_value_no_option_type *head_arg,
                                     const POS &head_pos_arg,
                                     PT_option_value_list_head *tail_arg)
      : super(pos), head(head_arg), head_pos(head_pos_arg), tail(tail_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_transaction_characteristic : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  const char *name;
  int32 value;
 
 public:
  PT_transaction_characteristic(const POS &pos, const char *name_arg,
                                int32 value_arg)
      : super(pos), name(name_arg), value(value_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_transaction_access_mode : public PT_transaction_characteristic {
  typedef PT_transaction_characteristic super;
 
 public:
  explicit PT_transaction_access_mode(const POS &pos, bool is_read_only)
      : super(pos, "transaction_read_only", (int32)is_read_only) {}
};
 
class PT_isolation_level : public PT_transaction_characteristic {
  typedef PT_transaction_characteristic super;
 
 public:
  explicit PT_isolation_level(const POS &pos, enum_tx_isolation level)
      : super(pos, "transaction_isolation", (int32)level) {}
};
 
class PT_transaction_characteristics : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  PT_transaction_characteristic *head;
  PT_transaction_characteristic *opt_tail;
 
 public:
  PT_transaction_characteristics(const POS &pos,
                                 PT_transaction_characteristic *head_arg,
                                 PT_transaction_characteristic *opt_tail_arg)
      : super(pos), head(head_arg), opt_tail(opt_tail_arg) {}
 
  bool do_contextualize(Parse_context *pc) override {
    return (super::do_contextualize(pc) || head->contextualize(pc) ||
            (opt_tail != nullptr && opt_tail->contextualize(pc)));
  }
};
 
class PT_start_option_value_list_transaction
    : public PT_start_option_value_list {
  typedef PT_start_option_value_list super;
 
  PT_transaction_characteristics *characteristics;
  POS end_pos;
 
 public:
  PT_start_option_value_list_transaction(
      const POS &pos, PT_transaction_characteristics *characteristics_arg,
      const POS &end_pos_arg)
      : super(pos),
        characteristics(characteristics_arg),
        end_pos(end_pos_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_start_option_value_list_following_option_type
    : public Parse_tree_node {
 protected:
  explicit PT_start_option_value_list_following_option_type(const POS &pos)
      : Parse_tree_node(pos) {}
};
 
class PT_start_option_value_list_following_option_type_eq
    : public PT_start_option_value_list_following_option_type {
  typedef PT_start_option_value_list_following_option_type super;
 
  PT_set_scoped_system_variable *head;
  POS head_pos;
  PT_option_value_list_head *opt_tail;
 
 public:
  PT_start_option_value_list_following_option_type_eq(
      const POS &pos, PT_set_scoped_system_variable *head_arg,
      const POS &head_pos_arg, PT_option_value_list_head *opt_tail_arg)
      : super(pos),
        head(head_arg),
        head_pos(head_pos_arg),
        opt_tail(opt_tail_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_start_option_value_list_following_option_type_transaction
    : public PT_start_option_value_list_following_option_type {
  typedef PT_start_option_value_list_following_option_type super;
 
  PT_transaction_characteristics *characteristics;
  POS characteristics_pos;
 
 public:
  PT_start_option_value_list_following_option_type_transaction(
      const POS &pos, PT_transaction_characteristics *characteristics_arg,
      const POS &characteristics_pos_arg)
      : super(pos),
        characteristics(characteristics_arg),
        characteristics_pos(characteristics_pos_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_start_option_value_list_type : public PT_start_option_value_list {
  typedef PT_start_option_value_list super;
 
  enum_var_type type;
  PT_start_option_value_list_following_option_type *list;
 
 public:
  PT_start_option_value_list_type(
      const POS &pos, enum_var_type type_arg,
      PT_start_option_value_list_following_option_type *list_arg)
      : super(pos), type(type_arg), list(list_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_set : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  POS set_pos;
  PT_start_option_value_list *list;
 
 public:
  PT_set(const POS &pos, const POS &set_pos_arg,
         PT_start_option_value_list *list_arg)
      : super(pos), set_pos(set_pos_arg), list(list_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_into_destination : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 protected:
  explicit PT_into_destination(const POS &pos) : super(pos) {}
 
 public:
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_into_destination_outfile final : public PT_into_destination {
  typedef PT_into_destination super;
 
 public:
  PT_into_destination_outfile(const POS &pos, const LEX_STRING &file_name_arg,
                              File_information *file_info,
                              const Field_separators *field_term_arg,
                              const Line_separators *line_term_arg,
                              enum_destination dumpfile_flag)
      : PT_into_destination(pos),
        m_exchange(file_name_arg.str, dumpfile_flag),
        dumpfile_dest(dumpfile_flag) {
    m_exchange.file_info.merge_file_information(file_info);
    m_exchange.field.merge_field_separators(field_term_arg);
    m_exchange.line.merge_line_separators(line_term_arg);
  }
 
  PT_into_destination_outfile(const POS &pos, LEX_CSTRING attr,
                              enum_destination dumpfile_flag)
      : PT_into_destination(pos),
        m_exchange(dumpfile_flag),
        dumpfile_dest(dumpfile_flag) {
    m_exchange.outfile_json = attr;
  }
 
  PT_into_destination_outfile(const POS &pos, URI_information *outfile_uri_arg,
                              File_information *file_info,
                              const Field_separators *field_term_arg,
                              const Line_separators *line_term_arg,
                              enum_destination dumpfile_flag)
      : PT_into_destination(pos),
        m_exchange(dumpfile_flag),
        dumpfile_dest(dumpfile_flag) {
    m_exchange.file_info.merge_file_information(file_info);
    m_exchange.field.merge_field_separators(field_term_arg);
    m_exchange.line.merge_line_separators(line_term_arg);
    m_exchange.uri_info.merge_uri_info_separators(outfile_uri_arg);
  }
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  sql_exchange m_exchange;
  enum_destination dumpfile_dest;
};
 
class PT_into_destination_dumpfile final : public PT_into_destination {
  typedef PT_into_destination super;
 
 public:
  PT_into_destination_dumpfile(const POS &pos, const LEX_STRING &file_name_arg)
      : PT_into_destination(pos),
        m_exchange(file_name_arg.str, DUMPFILE_DEST) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
 private:
  sql_exchange m_exchange;
};
 
class PT_select_var : public Parse_tree_node {
 public:
  const LEX_STRING name;
 
  explicit PT_select_var(const POS &pos, const LEX_STRING &name_arg)
      : Parse_tree_node(pos), name(name_arg) {}
 
  virtual bool is_local() const { return false; }
  virtual uint get_offset() const {
    assert(0);
    return 0;
  }
};
 
class PT_select_sp_var : public PT_select_var {
  typedef PT_select_var super;
 
  uint offset = 0;
 
#ifndef NDEBUG
  /*
    Routine to which this Item_splocal belongs. Used for checking if correct
    runtime context is used for variable handling.
  */
  sp_head *sp = nullptr;
#endif
 
 public:
  PT_select_sp_var(const POS &pos, const LEX_STRING &name_arg)
      : super(pos, name_arg) {}
 
  bool is_local() const override { return true; }
  uint get_offset() const override { return offset; }
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_select_var_list : public PT_into_destination {
  typedef PT_into_destination super;
 
 public:
  explicit PT_select_var_list(const POS &pos) : PT_into_destination(pos) {}
 
  List<PT_select_var> value;
 
  bool do_contextualize(Parse_context *pc) override;
 
  bool push_back(PT_select_var *var) { return value.push_back(var); }
};
 
/**
  Parse tree node for a single of a window extent's borders,
  cf. <window frame extent> in SQL 2003.
*/
class PT_border : public Parse_tree_node {
  friend class Window;
  Item *m_value{nullptr};  ///< only relevant iff m_border_type == WBT_VALUE_*
 public:
  enum_window_border_type m_border_type;
  const bool m_date_time;
  interval_type m_int_type = INTERVAL_LAST;  // clang-tidy needs initialization.
 
  ///< For unbounded border
  PT_border(const POS &pos, enum_window_border_type type)
      : Parse_tree_node(pos), m_border_type(type), m_date_time(false) {
    assert(type != WBT_VALUE_PRECEDING && type != WBT_VALUE_FOLLOWING);
  }
 
  ///< For bounded non-temporal border, e.g. 2 PRECEDING: 'value' is 2.
  PT_border(const POS &pos, enum_window_border_type type, Item *value)
      : Parse_tree_node(pos),
        m_value(value),
        m_border_type(type),
        m_date_time(false) {}
 
  ///< For bounded INTERVAL 2 DAYS, 'value' is 2, int_type is DAYS.
  PT_border(const POS &pos, enum_window_border_type type, Item *value,
            interval_type int_type)
      : Parse_tree_node(pos),
        m_value(value),
        m_border_type(type),
        m_date_time(true),
        m_int_type(int_type) {}
 
  ///< @returns the '2' in '2 PRECEDING' or 'INTERVAL 2 DAYS PRECEDING'
  Item *border() const { return m_value; }
  /// Need such low-level access so that fix_fields updates the right pointer
  Item **border_ptr() { return &m_value; }
 
  /**
    @returns Addition operator for computation of frames, nullptr if error.
    @param  order_expr  Expression to add to/subtract from
    @param  prec    true if PRECEDING
    @param  asc     true if ASC
    @param  window  only used for error generation
  */
  Item *build_addop(Item_cache *order_expr, bool prec, bool asc,
                    const Window *window);
 
  bool do_contextualize(Parse_context *pc) override;
};
 
/**
  Parse tree node for one or both of a window extent's borders, cf.
  <window frame extent> in SQL 2003.
*/
class PT_borders : public Parse_tree_node {
  PT_border *m_borders[2]{};
  friend class PT_frame;
 
 public:
  /**
    Constructor.
 
    Frames of the form "frame_start no_frame_end" are translated during
    parsing to "BETWEEN frame_start AND CURRENT ROW". So both 'start' and
    'end' are non-nullptr.
  */
  PT_borders(const POS &pos, PT_border *start, PT_border *end)
      : Parse_tree_node(pos) {
    m_borders[0] = start;
    m_borders[1] = end;
  }
};
 
/**
  Parse tree node for a window frame's exclusions, cf. the
  <window frame exclusion> clause in SQL 2003.
*/
class PT_exclusion : public Parse_tree_node {
  enum_window_frame_exclusion m_exclusion;
 
 public:
  PT_exclusion(const POS &pos, enum_window_frame_exclusion e)
      : Parse_tree_node(pos), m_exclusion(e) {}
  // enum_window_frame_exclusion exclusion() { return m_exclusion; }
};
 
/**
  Parse tree node for a window's frame, cf. the <window frame clause>
  in SQL 2003.
*/
class PT_frame : public Parse_tree_node {
 public:
  enum_window_frame_unit m_query_expression;
 
  PT_border *m_from;
  PT_border *m_to;
 
  PT_exclusion *m_exclusion;
 
  /// If true, this is an artificial frame, not specified by the user
  bool m_originally_absent = false;
 
  PT_frame(const POS &pos, enum_window_frame_unit unit, PT_borders *from_to,
           PT_exclusion *exclusion)
      : Parse_tree_node(pos),
        m_query_expression(unit),
        m_from(from_to->m_borders[0]),
        m_to(from_to->m_borders[1]),
        m_exclusion(exclusion) {}
 
  bool do_contextualize(Parse_context *pc) override;
};
 
class PT_query_primary : public PT_query_expression_body {
 protected:
  explicit PT_query_primary(const POS &pos) : PT_query_expression_body(pos) {}
};
 
class PT_query_specification : public PT_query_primary {
  typedef PT_query_primary super;
 
  PT_hint_list *opt_hints;
  Query_options options;
  PT_item_list *item_list;
  PT_into_destination *opt_into1;
  const bool m_is_from_clause_implicit;
  Mem_root_array_YY<PT_table_reference *> from_clause;  // empty list for DUAL
  Item *opt_where_clause;
  PT_group *opt_group_clause;
  Item *opt_having_clause;
  PT_window_list *opt_window_clause;
  Item *opt_qualify_clause;
 
 public:
  PT_query_specification(
      const POS &pos, PT_hint_list *opt_hints_arg,
      const Query_options &options_arg, PT_item_list *item_list_arg,
      PT_into_destination *opt_into1_arg,
      const Mem_root_array_YY<PT_table_reference *> &from_clause_arg,
      Item *opt_where_clause_arg, PT_group *opt_group_clause_arg,
      Item *opt_having_clause_arg, PT_window_list *opt_window_clause_arg,
      Item *opt_qualify_clause_arg, bool implicit_from_clause)
      : super(pos),
        opt_hints(opt_hints_arg),
        options(options_arg),
        item_list(item_list_arg),
        opt_into1(opt_into1_arg),
        m_is_from_clause_implicit{implicit_from_clause},
        from_clause(from_clause_arg),
        opt_where_clause(opt_where_clause_arg),
        opt_group_clause(opt_group_clause_arg),
        opt_having_clause(opt_having_clause_arg),
        opt_window_clause(opt_window_clause_arg),
        opt_qualify_clause(opt_qualify_clause_arg) {
    assert(implicit_from_clause ? from_clause.empty() : true);
  }
 
  PT_query_specification(
      const POS &pos, const Query_options &options_arg,
      PT_item_list *item_list_arg,
      const Mem_root_array_YY<PT_table_reference *> &from_clause_arg,
      Item *opt_where_clause_arg)
      : super(pos),
        opt_hints(nullptr),
        options(options_arg),
        item_list(item_list_arg),
        opt_into1(nullptr),
        m_is_from_clause_implicit{true},
        from_clause(from_clause_arg),
        opt_where_clause(opt_where_clause_arg),
        opt_group_clause(nullptr),
        opt_having_clause(nullptr),
        opt_window_clause(nullptr),
        opt_qualify_clause(nullptr) {}
 
  PT_query_specification(const POS &pos, const Query_options &options_arg,
                         PT_item_list *item_list_arg)
      : super(pos),
        opt_hints(nullptr),
        options(options_arg),
        item_list(item_list_arg),
        opt_into1(nullptr),
        m_is_from_clause_implicit{false},
        from_clause{},
        opt_where_clause(nullptr),
        opt_group_clause(nullptr),
        opt_having_clause(nullptr),
        opt_window_clause(nullptr),
        opt_qualify_clause(nullptr) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  bool has_into_clause() const override { return opt_into1 != nullptr; }
  bool has_trailing_into_clause() const override {
    return (has_into_clause() && is_implicit_from_clause() &&
            opt_where_clause == nullptr && opt_group_clause == nullptr &&
            opt_having_clause == nullptr && opt_window_clause == nullptr &&
            opt_qualify_clause == nullptr);
  }
 
  bool is_set_operation() const override { return false; }
 
  bool can_absorb_order_and_limit(bool, bool) const override { return true; }
 
  bool is_table_value_constructor() const override { return false; }
  PT_insert_values_list *get_row_value_list() const override { return nullptr; }
 
 protected:
  void add_json_info(Json_object *obj) override;
 
 private:
  bool is_implicit_from_clause() const { return m_is_from_clause_implicit; }
};
 
class PT_table_value_constructor : public PT_query_primary {
  typedef PT_query_primary super;
 
  PT_insert_values_list *const row_value_list;
 
 public:
  explicit PT_table_value_constructor(const POS &pos,
                                      PT_insert_values_list *row_value_list_arg)
      : super(pos), row_value_list(row_value_list_arg) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  bool has_into_clause() const override { return false; }
  bool has_trailing_into_clause() const override { return false; }
 
  bool is_set_operation() const override { return false; }
 
  bool can_absorb_order_and_limit(bool, bool) const override { return true; }
 
  bool is_table_value_constructor() const override { return true; }
 
  PT_insert_values_list *get_row_value_list() const override {
    return row_value_list;
  }
};
 
class PT_explicit_table : public PT_query_specification {
  using super = PT_query_specification;
 
 public:
  PT_explicit_table(
      const POS &pos, const Query_options &options_arg,
      PT_item_list *item_list_arg,
      const Mem_root_array_YY<PT_table_reference *> &from_clause_arg)
      : super(pos, options_arg, item_list_arg, from_clause_arg, nullptr) {}
};
 
class PT_query_expression final : public PT_query_expression_body {
 public:
  PT_query_expression(const POS &pos, PT_with_clause *with_clause,
                      PT_query_expression_body *body, PT_order *order,
                      PT_limit_clause *limit)
      : PT_query_expression_body(pos),
        m_body(body),
        m_order(order),
        m_limit(limit),
        m_with_clause(with_clause) {}
 
  PT_query_expression(const POS &pos, PT_query_expression_body *body,
                      PT_order *order, PT_limit_clause *limit)
      : PT_query_expression(pos, nullptr, body, order, limit) {}
 
  explicit PT_query_expression(const POS &pos, PT_query_expression_body *body)
      : PT_query_expression(pos, body, nullptr, nullptr) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  bool is_set_operation() const override { return m_body->is_set_operation(); }
 
  bool has_into_clause() const override { return m_body->has_into_clause(); }
  bool has_trailing_into_clause() const override {
    return (m_body->has_trailing_into_clause() && m_order == nullptr &&
            m_limit == nullptr);
  }
 
  bool can_absorb_order_and_limit(bool order, bool limit) const override {
    if (m_body->is_set_operation()) {
      return false;
    }
    if (m_order == nullptr && m_limit == nullptr) {
      /*
        It is safe to push ORDER and/or LIMIT down in:
 
          (SELECT ...<no order or limit clauses>) ORDER BY ... LIMIT ...;
          (SELECT ...<no order or limit clauses>) ORDER BY ...;
          (SELECT ...<no order or limit clauses>)              LIMIT ...;
      */
      return true;
    }
    if (m_limit != nullptr && !order && limit) {
      /*
        In MySQL, it is ok(*) to push LIMIT down in:
 
          (SELECT ... [ORDER BY ...] LIMIT a) LIMIT b;
 
        *) MySQL doesn't follow the standard when overwriting `LIMIT a` with
           `LIMIT b` if a < b.  Moreover, the result of:
 
             (SELECT ... ORDER BY order1 LIMIT a) ORDER BY order1 LIMIT b; (1)
 
           can diverge from:
 
             (SELECT ... ORDER BY order1 LIMIT a) LIMIT b;                  (2)
 
           since the example (1) never overwrites `LIMIT a` with `LIMIT b`,
           while the example (2) does overwrite.
 
           TODO: add a warning, deprecate and replace this behavior with the
                 standard one.
      */
      return true;
    }
    if (m_order != nullptr && m_limit == nullptr && !order && limit) {
      /*
        Allow pushdown of LIMIT into body with ORDER BY, e.g
 
          (SELECT ... ORDER BY order1) LIMIT a;
      */
      return true;
    }
    return false;
  }
 
  bool is_table_value_constructor() const override {
    return m_body->is_table_value_constructor();
  }
 
  PT_insert_values_list *get_row_value_list() const override {
    return m_body->get_row_value_list();
  }
 
 private:
  /**
    Contextualizes the order and limit clauses, re-interpreting them according
    to the rules. If the `<query expression body>` can absorb the clauses,
    they are simply contextualized into the current Query_block. If not, we
    have to create the "fake" Query_block unless there is one already
    (Query_expression::new_set_operation_query() is known to do this.)
 
    @see PT_query_expression::can_absorb_order_and_limit()
  */
  bool contextualize_order_and_limit(Parse_context *pc);
 
  PT_query_expression_body *m_body;
  PT_order *m_order;
  PT_limit_clause *m_limit;
  PT_with_clause *m_with_clause;
};
 
/*
  After the removal of the `... <locking_clause> <into_clause>` syntax
  PT_locking will disappear.
*/
class PT_locking final : public PT_query_expression_body {
  using super = PT_query_expression_body;
 
 public:
  PT_locking(const POS &pos, PT_query_expression_body *qe,
             PT_locking_clause_list *locking_clauses)
      : super(pos),
        m_query_expression{qe},
        m_locking_clauses{locking_clauses} {}
 
  bool do_contextualize(Parse_context *pc) override {
    return (super::do_contextualize(pc) ||
            m_query_expression->contextualize(pc) ||
            m_locking_clauses->contextualize(pc));
  }
 
  bool is_set_operation() const override {
    return m_query_expression->is_set_operation();
  }
 
  bool has_into_clause() const override {
    return m_query_expression->has_into_clause();
  }
  bool has_trailing_into_clause() const override { return false; }
 
  bool can_absorb_order_and_limit(bool order, bool limit) const override {
    return m_query_expression->can_absorb_order_and_limit(order, limit);
  }
 
  bool is_table_value_constructor() const override {
    return m_query_expression->is_table_value_constructor();
  }
 
  PT_insert_values_list *get_row_value_list() const override {
    return m_query_expression->get_row_value_list();
  }
 
 private:
  PT_query_expression_body *const m_query_expression;
  PT_locking_clause_list *const m_locking_clauses;
};
 
class PT_subquery : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  PT_query_expression_body *qe;
  Query_block *query_block;
 
 public:
  bool m_is_derived_table;
 
  PT_subquery(const POS &pos, PT_query_expression_body *query_expression)
      : super(pos),
        qe(query_expression),
        query_block(nullptr),
        m_is_derived_table(false) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  Query_block *value() { return query_block; }
};
 
class PT_set_operation : public PT_query_expression_body {
  using super = PT_query_expression_body;
 
 public:
  PT_set_operation(const POS &pos, PT_query_expression_body *lhs,
                   bool is_distinct, PT_query_expression_body *rhs,
                   bool is_rhs_in_parentheses = false)
      : super(pos),
        m_is_distinct(is_distinct),
        m_is_rhs_in_parentheses{is_rhs_in_parentheses} {
    m_list.push_back(lhs);
    m_list.push_back(rhs);
  }
 
  void merge_descendants(Parse_context *pc, Query_term_set_op *setop,
                         QueryLevel &ql);
  bool is_set_operation() const override { return true; }
 
  bool has_into_clause() const override {
    return std::any_of(m_list.cbegin(), m_list.cend(),
                       [](const PT_query_expression_body &body) {
                         return body.has_into_clause();
                       });
  }
  bool has_trailing_into_clause() const override {
    return !m_is_rhs_in_parentheses &&
           m_list[m_list.elements - 1]->has_trailing_into_clause();
  }
 
  bool can_absorb_order_and_limit(bool, bool) const override { return false; }
 
  bool is_table_value_constructor() const override { return false; }
  PT_insert_values_list *get_row_value_list() const override { return nullptr; }
  bool is_distinct() const { return m_is_distinct; }
 
  List<PT_query_expression_body> m_list;
  void set_is_rhs_in_parentheses(bool v) { m_is_rhs_in_parentheses = v; }
 
 protected:
  bool contextualize_setop(Parse_context *pc, Query_term_type setop_type,
                           Surrounding_context context);
  void merge_children(Query_term_set_op *setop, Query_term_set_op *lower);
  bool m_is_distinct;
  PT_into_destination *m_into{nullptr};
  bool m_is_rhs_in_parentheses;
  void add_json_info(Json_object *obj) override {
    obj->add_alias("distinct", create_dom_ptr<Json_boolean>(m_is_distinct));
    obj->add_alias("rhs_in_parentheses",
                   create_dom_ptr<Json_boolean>(m_is_rhs_in_parentheses));
  }
};
 
class PT_union : public PT_set_operation {
  using super = PT_set_operation;
 
 public:
  using PT_set_operation::PT_set_operation;
  bool do_contextualize(Parse_context *pc) override;
  enum Setop_type type() const override { return UNION; }
};
 
class PT_except : public PT_set_operation {
  using super = PT_set_operation;
 
 public:
  using PT_set_operation::PT_set_operation;
  bool do_contextualize(Parse_context *pc) override;
  enum Setop_type type() const override { return EXCEPT; }
};
 
class PT_intersect : public PT_set_operation {
  using super = PT_set_operation;
 
 public:
  using PT_set_operation::PT_set_operation;
  bool do_contextualize(Parse_context *pc) override;
  enum Setop_type type() const override { return INTERSECT; }
};
 
class PT_select_stmt : public Parse_tree_root {
  typedef Parse_tree_root super;
 
 public:
  /**
    @param pos Position of this clause in the SQL statement.
    @param qe The query expression.
    @param sql_command The type of SQL command.
  */
  PT_select_stmt(const POS &pos, enum_sql_command sql_command,
                 PT_query_expression_body *qe)
      : super(pos),
        m_sql_command(sql_command),
        m_qe(qe),
        m_into(nullptr),
        m_has_trailing_locking_clauses{false} {}
 
  /**
    Creates a SELECT command. Only SELECT commands can have into.
 
    @param pos                          Position of this clause in the SQL
                                        statement.
    @param qe                           The query expression.
    @param into                         The own INTO destination.
    @param has_trailing_locking_clauses True if there are locking clauses (like
                                        `FOR UPDATE`) at the end of the
                                        statement.
  */
  explicit PT_select_stmt(const POS &pos, PT_query_expression_body *qe,
                          PT_into_destination *into = nullptr,
                          bool has_trailing_locking_clauses = false)
      : super(pos),
        m_sql_command{SQLCOM_SELECT},
        m_qe{qe},
        m_into{into},
        m_has_trailing_locking_clauses{has_trailing_locking_clauses} {}
 
  Sql_cmd *make_cmd(THD *thd) override;
  std::string get_printable_parse_tree(THD *thd) override;
 
 private:
  enum_sql_command m_sql_command;
  PT_query_expression_body *m_qe;
  PT_into_destination *m_into;
  const bool m_has_trailing_locking_clauses;
};
 
/**
  Top-level node for the DELETE statement
 
  @ingroup ptn_stmt
*/
class PT_delete final : public Parse_tree_root {
  typedef Parse_tree_root super;
 
 private:
  PT_with_clause *m_with_clause;
  PT_hint_list *opt_hints;
  const int opt_delete_options;
  Table_ident *table_ident;
  const char *const opt_table_alias;
  Mem_root_array_YY<Table_ident *> table_list{};
  List<String> *opt_use_partition;
  Mem_root_array_YY<PT_table_reference *> join_table_list{};
  Item *opt_where_clause;
  PT_order *opt_order_clause;
  Item *opt_delete_limit_clause;
  SQL_I_List<Table_ref> delete_tables;
 
 public:
  // single-table DELETE node constructor:
  PT_delete(const POS &pos, PT_with_clause *with_clause_arg,
            PT_hint_list *opt_hints_arg, int opt_delete_options_arg,
            Table_ident *table_ident_arg,
            const LEX_CSTRING &opt_table_alias_arg,
            List<String> *opt_use_partition_arg, Item *opt_where_clause_arg,
            PT_order *opt_order_clause_arg, Item *opt_delete_limit_clause_arg)
      : super(pos),
        m_with_clause(with_clause_arg),
        opt_hints(opt_hints_arg),
        opt_delete_options(opt_delete_options_arg),
        table_ident(table_ident_arg),
        opt_table_alias(opt_table_alias_arg.str),
        opt_use_partition(opt_use_partition_arg),
        opt_where_clause(opt_where_clause_arg),
        opt_order_clause(opt_order_clause_arg),
        opt_delete_limit_clause(opt_delete_limit_clause_arg) {
    table_list.init_empty_const();
    join_table_list.init_empty_const();
  }
 
  // multi-table DELETE node constructor:
  PT_delete(const POS &pos, PT_with_clause *with_clause_arg,
            PT_hint_list *opt_hints_arg, int opt_delete_options_arg,
            const Mem_root_array_YY<Table_ident *> &table_list_arg,
            const Mem_root_array_YY<PT_table_reference *> &join_table_list_arg,
            Item *opt_where_clause_arg)
      : super(pos),
        m_with_clause(with_clause_arg),
        opt_hints(opt_hints_arg),
        opt_delete_options(opt_delete_options_arg),
        table_ident(nullptr),
        opt_table_alias(nullptr),
        table_list(table_list_arg),
        opt_use_partition(nullptr),
        join_table_list(join_table_list_arg),
        opt_where_clause(opt_where_clause_arg),
        opt_order_clause(nullptr),
        opt_delete_limit_clause(nullptr) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  bool is_multitable() const {
    assert((table_ident != nullptr) ^ (table_list.size() > 0));
    return table_ident == nullptr;
  }
 
  bool add_table(Parse_context *pc, Table_ident *table);
};
 
/**
  Top-level node for the UPDATE statement
 
  @ingroup ptn_stmt
*/
class PT_update : public Parse_tree_root {
  typedef Parse_tree_root super;
 
  PT_with_clause *m_with_clause;
  PT_hint_list *opt_hints;
  thr_lock_type opt_low_priority;
  bool opt_ignore;
  Mem_root_array_YY<PT_table_reference *> join_table_list;
  PT_item_list *column_list;
  PT_item_list *value_list;
  Item *opt_where_clause;
  PT_order *opt_order_clause;
  Item *opt_limit_clause;
 
 public:
  PT_update(const POS &pos, PT_with_clause *with_clause_arg,
            PT_hint_list *opt_hints_arg, thr_lock_type opt_low_priority_arg,
            bool opt_ignore_arg,
            const Mem_root_array_YY<PT_table_reference *> &join_table_list_arg,
            PT_item_list *column_list_arg, PT_item_list *value_list_arg,
            Item *opt_where_clause_arg, PT_order *opt_order_clause_arg,
            Item *opt_limit_clause_arg)
      : super(pos),
        m_with_clause(with_clause_arg),
        opt_hints(opt_hints_arg),
        opt_low_priority(opt_low_priority_arg),
        opt_ignore(opt_ignore_arg),
        join_table_list(join_table_list_arg),
        column_list(column_list_arg),
        value_list(value_list_arg),
        opt_where_clause(opt_where_clause_arg),
        opt_order_clause(opt_order_clause_arg),
        opt_limit_clause(opt_limit_clause_arg) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_insert_values_list : public Parse_tree_node {
  typedef Parse_tree_node super;
 
  mem_root_deque<List_item *> many_values;
 
 public:
  explicit PT_insert_values_list(const POS &pos, MEM_ROOT *mem_root)
      : super(pos), many_values(mem_root) {}
 
  bool do_contextualize(Parse_context *pc) override;
 
  bool push_back(mem_root_deque<Item *> *x) {
    many_values.push_back(x);
    return false;
  }
 
  virtual mem_root_deque<List_item *> &get_many_values() {
    assert(is_contextualized());
    return many_values;
  }
};
 
/**
  Top-level node for the INSERT statement
 
  @ingroup ptn_stmt
*/
class PT_insert final : public Parse_tree_root {
  typedef Parse_tree_root super;
 
  const bool is_replace;
  PT_hint_list *opt_hints;
  const thr_lock_type lock_option;
  const bool ignore;
  Table_ident *const table_ident;
  List<String> *const opt_use_partition;
  PT_item_list *const column_list;
  PT_insert_values_list *row_value_list;
  PT_query_expression_body *insert_query_expression;
  const char *const opt_values_table_alias;
  Create_col_name_list *const opt_values_column_list;
  PT_item_list *const opt_on_duplicate_column_list;
  PT_item_list *const opt_on_duplicate_value_list;
 
 public:
  PT_insert(const POS &pos, bool is_replace_arg, PT_hint_list *opt_hints_arg,
            thr_lock_type lock_option_arg, bool ignore_arg,
            Table_ident *table_ident_arg, List<String> *opt_use_partition_arg,
            PT_item_list *column_list_arg,
            PT_insert_values_list *row_value_list_arg,
            PT_query_expression_body *insert_query_expression_arg,
            const LEX_CSTRING &opt_values_table_alias_arg,
            Create_col_name_list *opt_values_column_list_arg,
            PT_item_list *opt_on_duplicate_column_list_arg,
            PT_item_list *opt_on_duplicate_value_list_arg)
      : super(pos),
        is_replace(is_replace_arg),
        opt_hints(opt_hints_arg),
        lock_option(lock_option_arg),
        ignore(ignore_arg),
        table_ident(table_ident_arg),
        opt_use_partition(opt_use_partition_arg),
        column_list(column_list_arg),
        row_value_list(row_value_list_arg),
        insert_query_expression(insert_query_expression_arg),
        opt_values_table_alias(opt_values_table_alias_arg.str),
        opt_values_column_list(opt_values_column_list_arg),
        opt_on_duplicate_column_list(opt_on_duplicate_column_list_arg),
        opt_on_duplicate_value_list(opt_on_duplicate_value_list_arg) {
    // REPLACE statement can't have IGNORE flag:
    assert(!is_replace || !ignore);
    // REPLACE statement can't have ON DUPLICATE KEY UPDATE clause:
    assert(!is_replace || opt_on_duplicate_column_list == nullptr);
    // INSERT/REPLACE ... SELECT can't have VALUES clause:
    assert((row_value_list != nullptr) ^ (insert_query_expression != nullptr));
    // ON DUPLICATE KEY UPDATE: column and value arrays must have same sizes:
    assert((opt_on_duplicate_column_list == nullptr &&
            opt_on_duplicate_value_list == nullptr) ||
           (opt_on_duplicate_column_list->elements() ==
            opt_on_duplicate_value_list->elements()));
  }
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  bool has_query_block() const { return insert_query_expression != nullptr; }
};
 
class PT_call final : public Parse_tree_root {
  sp_name *proc_name;
  PT_item_list *opt_expr_list;
 
 public:
  PT_call(const POS &pos, sp_name *proc_name_arg,
          PT_item_list *opt_expr_list_arg)
      : Parse_tree_root(pos),
        proc_name(proc_name_arg),
        opt_expr_list(opt_expr_list_arg) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/**
  Top-level node for the SHUTDOWN statement
 
  @ingroup ptn_stmt
*/
class PT_shutdown final : public Parse_tree_root {
  Sql_cmd_shutdown sql_cmd;
 
 public:
  Sql_cmd *make_cmd(THD *) override { return &sql_cmd; }
};
 
/**
  Top-level node for the CREATE [OR REPLACE] SPATIAL REFERENCE SYSTEM statement.
 
  @ingroup ptn_stmt
*/
class PT_create_srs final : public Parse_tree_root {
  /// The SQL command object.
  Sql_cmd_create_srs sql_cmd;
  /// Whether OR REPLACE is specified.
  bool m_or_replace;
  /// Whether IF NOT EXISTS is specified.
  bool m_if_not_exists;
  /// SRID of the SRS to create.
  ///
  /// The range is larger than that of gis::srid_t, so it must be
  /// verified to be less than the uint32 maximum value.
  unsigned long long m_srid;
  /// All attributes except SRID.
  const Sql_cmd_srs_attributes m_attributes;
 
  /// Check if a UTF-8 string contains control characters.
  ///
  /// @note This function only checks single byte control characters (U+0000 to
  /// U+001F, and U+007F). There are some control characters at U+0080 to U+00A0
  /// that are not detected by this function.
  ///
  /// @param str The string.
  /// @param length Length of the string.
  ///
  /// @retval false The string contains no control characters.
  /// @retval true The string contains at least one control character.
  bool contains_control_char(char *str, size_t length) {
    for (size_t pos = 0; pos < length; pos++) {
      if (std::iscntrl(str[pos])) return true;
    }
    return false;
  }
 
 public:
  PT_create_srs(const POS &pos, unsigned long long srid,
                const Sql_cmd_srs_attributes &attributes, bool or_replace,
                bool if_not_exists)
      : Parse_tree_root(pos),
        m_or_replace(or_replace),
        m_if_not_exists(if_not_exists),
        m_srid(srid),
        m_attributes(attributes) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/**
  Top-level node for the DROP SPATIAL REFERENCE SYSTEM statement.
 
  @ingroup ptn_stmt
*/
class PT_drop_srs final : public Parse_tree_root {
  /// The SQL command object.
  Sql_cmd_drop_srs sql_cmd;
  /// SRID of the SRS to drop.
  ///
  /// The range is larger than that of gis::srid_t, so it must be
  /// verified to be less than the uint32 maximum value.
  unsigned long long m_srid;
 
 public:
  PT_drop_srs(const POS &pos, unsigned long long srid, bool if_exists)
      : Parse_tree_root(pos), sql_cmd(srid, if_exists), m_srid(srid) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/**
  Top-level node for the ALTER INSTANCE statement
 
  @ingroup ptn_stmt
*/
class PT_alter_instance final : public Parse_tree_root {
  Sql_cmd_alter_instance sql_cmd;
 
 public:
  explicit PT_alter_instance(
      const POS &pos, enum alter_instance_action_enum alter_instance_action,
      const LEX_CSTRING &channel)
      : Parse_tree_root(pos), sql_cmd(alter_instance_action, channel) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/**
  A template-free base class for index options that we can predeclare in
  sql_lex.h
*/
class PT_base_index_option : public Table_ddl_node {
 protected:
  explicit PT_base_index_option(const POS &pos) : Table_ddl_node(pos) {}
};
 
/**
  A key part specification.
 
  This can either be a "normal" key part (a key part that points to a column),
  or this can be a functional key part (a key part that points to an
  expression).
*/
class PT_key_part_specification : public Parse_tree_node {
  typedef Parse_tree_node super;
 
 public:
  /**
    Constructor for a functional key part.
 
    @param pos Position of this clause in the SQL statement.
    @param expression The expression to index.
    @param order The direction of the index.
  */
  PT_key_part_specification(const POS &pos, Item *expression, enum_order order);
 
  /**
    Constructor for a "normal" key part. That is a key part that points to a
    column and not an expression.
 
    @param pos Position of this clause in the SQL statement.
    @param column_name The column name that this key part points to.
    @param order The direction of the index.
    @param prefix_length How many bytes or characters this key part should
           index, or zero if it should index the entire column.
  */
  PT_key_part_specification(const POS &pos, const LEX_CSTRING &column_name,
                            enum_order order, int prefix_length);
 
  /**
    Contextualize this key part specification. This will also call itemize on
    the indexed expression if this is a functional key part.
 
    @param pc The parse context
 
    @retval true on error
    @retval false on success
  */
  bool do_contextualize(Parse_context *pc) override;
 
  /**
    Get the indexed expression. The caller must ensure that has_expression()
    returns true before calling this.
 
    @returns The indexed expression
  */
  Item *get_expression() const {
    assert(has_expression());
    return m_expression;
  }
 
  /**
    @returns The direction of the index: ORDER_ASC, ORDER_DESC or
             ORDER_NOT_RELEVANT in case the user didn't explicitly specify a
             direction.
  */
  enum_order get_order() const { return m_order; }
 
  /**
    @retval true if the user explicitly specified a direction (asc/desc).
    @retval false if the user didn't explicitly specify a direction.
  */
  bool is_explicit() const { return get_order() != ORDER_NOT_RELEVANT; }
 
  /**
    @retval true if the key part contains an expression (and thus is a
            functional key part).
    @retval false if the key part doesn't contain an expression.
  */
  bool has_expression() const { return m_expression != nullptr; }
 
  /**
    Get the column that this key part points to. This is only valid if this
    key part isn't a functional index. The caller must thus check the return
    value of has_expression() before calling this function.
 
    @returns The column that this key part points to.
  */
  LEX_CSTRING get_column_name() const {
    assert(!has_expression());
    return m_column_name;
  }
 
  /**
    @returns The number of bytes that this key part should index. If the column
             this key part points to is a non-binary column, this is the number
             of characters. Returns zero if the entire column should be indexed.
  */
  int get_prefix_length() const { return m_prefix_length; }
 
 private:
  /**
    The indexed expression in case this is a functional key part. Only valid if
    has_expression() returns true.
  */
  Item *m_expression;
 
  /// The direction of the index.
  enum_order m_order;
 
  /// The name of the column that this key part indexes.
  LEX_CSTRING m_column_name{};
 
  /**
    If this is greater than zero, it represents how many bytes of the column
    that is indexed. Note that for non-binary columns (VARCHAR, TEXT etc), this
    is the number of characters.
  */
  int m_prefix_length = 0;
};
 
/**
  A template for options that set a single `<alter option>` value in
  thd->lex->key_create_info.
 
  @tparam Option_type The data type of the option.
  @tparam Property Pointer-to-member for the option of KEY_CREATE_INFO.
*/
template <typename Option_type, Option_type KEY_CREATE_INFO::*Property>
class PT_index_option : public PT_base_index_option {
 public:
  /// @param pos Position of this clause in the SQL statement.
  /// @param option_value The value of the option.
  PT_index_option(const POS &pos, Option_type option_value)
      : PT_base_index_option(pos), m_option_value(option_value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    pc->key_create_info->*Property = m_option_value;
    return false;
  }
 
 private:
  Option_type m_option_value;
};
 
/**
  A template for options that set a single property in a KEY_CREATE_INFO, and
  also records if the option was explicitly set.
*/
template <typename Option_type, Option_type KEY_CREATE_INFO::*Property,
          bool KEY_CREATE_INFO::*Property_is_explicit>
class PT_traceable_index_option : public PT_base_index_option {
 public:
  PT_traceable_index_option(const POS &pos, Option_type option_value)
      : PT_base_index_option(pos), m_option_value(option_value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    pc->key_create_info->*Property = m_option_value;
    pc->key_create_info->*Property_is_explicit = true;
    return false;
  }
 
 private:
  Option_type m_option_value;
};
 
typedef Mem_root_array_YY<PT_base_index_option *> Index_options;
typedef PT_index_option<ulong, &KEY_CREATE_INFO::block_size> PT_block_size;
typedef PT_index_option<LEX_CSTRING, &KEY_CREATE_INFO::comment>
    PT_index_comment;
typedef PT_index_option<LEX_CSTRING, &KEY_CREATE_INFO::parser_name>
    PT_fulltext_index_parser_name;
typedef PT_index_option<bool, &KEY_CREATE_INFO::is_visible> PT_index_visibility;
 
/**
  The data structure (B-tree, Hash, etc) used for an index is called
  'index_type' in the manual. Internally, this is stored in
  KEY_CREATE_INFO::algorithm, while what the manual calls 'algorithm' is
  stored in partition_info::key_algorithm. In an `<create_index_stmt>`
  it's ignored. The terminology is somewhat confusing, but we stick to the
  manual in the parser.
*/
typedef PT_traceable_index_option<ha_key_alg, &KEY_CREATE_INFO::algorithm,
                                  &KEY_CREATE_INFO::is_algorithm_explicit>
    PT_index_type;
 
class PT_create_index_stmt final : public PT_table_ddl_stmt_base {
 public:
  PT_create_index_stmt(const POS &pos, MEM_ROOT *mem_root, keytype type_par,
                       const LEX_STRING &name_arg, PT_base_index_option *type,
                       Table_ident *table_ident,
                       List<PT_key_part_specification> *cols,
                       Index_options options,
                       Alter_info::enum_alter_table_algorithm algo,
                       Alter_info::enum_alter_table_lock lock)
      : PT_table_ddl_stmt_base(pos, mem_root),
        m_keytype(type_par),
        m_name(name_arg),
        m_type(type),
        m_table_ident(table_ident),
        m_columns(cols),
        m_options(options),
        m_algo(algo),
        m_lock(lock) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  keytype m_keytype;
  LEX_STRING m_name;
  PT_base_index_option *m_type;
  Table_ident *m_table_ident;
  List<PT_key_part_specification> *m_columns;
  Index_options m_options;
  const Alter_info::enum_alter_table_algorithm m_algo;
  const Alter_info::enum_alter_table_lock m_lock;
};
 
/**
  Base class for column/constraint definitions in CREATE %TABLE
 
  @ingroup ptn_create_table_stuff
*/
class PT_table_element : public Table_ddl_node {
 protected:
  explicit PT_table_element(const POS &pos) : Table_ddl_node(pos) {}
};
 
class PT_table_constraint_def : public PT_table_element {
 protected:
  explicit PT_table_constraint_def(const POS &pos) : PT_table_element(pos) {}
};
 
class PT_inline_index_definition : public PT_table_constraint_def {
  typedef PT_table_constraint_def super;
 
 public:
  PT_inline_index_definition(const POS &pos, keytype type_par,
                             const LEX_STRING &name_arg,
                             PT_base_index_option *type,
                             List<PT_key_part_specification> *cols,
                             Index_options options)
      : super(pos),
        m_keytype(type_par),
        m_name(name_arg),
        m_type(type),
        m_columns(cols),
        m_options(options) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
 
 private:
  keytype m_keytype;
  const LEX_STRING m_name;
  PT_base_index_option *m_type;
  List<PT_key_part_specification> *m_columns;
  Index_options m_options;
};
 
class PT_foreign_key_definition : public PT_table_constraint_def {
  typedef PT_table_constraint_def super;
 
 public:
  PT_foreign_key_definition(const POS &pos, const LEX_STRING &constraint_name,
                            const LEX_STRING &key_name,
                            List<PT_key_part_specification> *columns,
                            Table_ident *referenced_table,
                            List<Key_part_spec> *ref_list,
                            fk_match_opt fk_match_option,
                            fk_option fk_update_opt, fk_option fk_delete_opt)
      : super(pos),
        m_constraint_name(constraint_name),
        m_key_name(key_name),
        m_columns(columns),
        m_referenced_table(referenced_table),
        m_ref_list(ref_list),
        m_fk_match_option(fk_match_option),
        m_fk_update_opt(fk_update_opt),
        m_fk_delete_opt(fk_delete_opt) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
 
  void set_column_name(const LEX_STRING &column_name) {
    m_column_name = column_name;
  }
 
 private:
  const LEX_STRING m_constraint_name;
  const LEX_STRING m_key_name;
  List<PT_key_part_specification> *m_columns;
  Table_ident *m_referenced_table;
  List<Key_part_spec> *m_ref_list;
  fk_match_opt m_fk_match_option;
  fk_option m_fk_update_opt;
  fk_option m_fk_delete_opt;
 
  // Column name. Set when FK is specified at the column level.
  LEX_STRING m_column_name{nullptr, 0};
};
 
/**
  Common base class for CREATE TABLE and ALTER TABLE option nodes
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_ddl_table_option : public Table_ddl_node {
 protected:
  explicit PT_ddl_table_option(const POS &pos) : Table_ddl_node(pos) {}
 
 public:
  ~PT_ddl_table_option() override = 0;  // Force abstract class declaration
 
  virtual bool is_rename_table() const { return false; }
};
 
inline PT_ddl_table_option::~PT_ddl_table_option() = default;
 
/**
  Base class for CREATE TABLE option nodes
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_create_table_option : public PT_ddl_table_option {
  typedef PT_ddl_table_option super;
 
 protected:
  explicit PT_create_table_option(const POS &pos) : super(pos) {}
 
 public:
  ~PT_create_table_option() override = 0;  // Force abstract class declaration
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    pc->alter_info->flags |= Alter_info::ALTER_OPTIONS;
    return false;
  }
};
 
inline PT_create_table_option::~PT_create_table_option() = default;
 
/**
  A template for options that set a single property in HA_CREATE_INFO, and
  also records if the option was explicitly set.
*/
template <typename Option_type, Option_type HA_CREATE_INFO::*Property,
          uint64_t Property_flag>
class PT_traceable_create_table_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const Option_type value;
 
 public:
  explicit PT_traceable_create_table_option(const POS &pos, Option_type value)
      : super(pos), value(value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    pc->create_info->*Property = value;
    pc->create_info->used_fields |= Property_flag;
    return false;
  }
};
 
#define TYPE_AND_REF(x) decltype(x), &x
 
/**
  Node for the @SQL{MAX_ROWS [=] @B{@<integer@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::max_rows),
                                         HA_CREATE_USED_MAX_ROWS>
    PT_create_max_rows_option;
 
/**
  Node for the @SQL{MIN_ROWS [=] @B{@<integer@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::min_rows),
                                         HA_CREATE_USED_MIN_ROWS>
    PT_create_min_rows_option;
 
/**
  Node for the @SQL{AVG_ROW_LENGTH_ROWS [=] @B{@<integer@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::avg_row_length), HA_CREATE_USED_AVG_ROW_LENGTH>
    PT_create_avg_row_length_option;
 
/**
  Node for the @SQL{PASSWORD [=] @B{@<string@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::password),
                                         HA_CREATE_USED_PASSWORD>
    PT_create_password_option;
 
/**
  Node for the @SQL{COMMENT [=] @B{@<string@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::comment),
                                         HA_CREATE_USED_COMMENT>
    PT_create_commen_option;
 
/**
  Node for the @SQL{COMPRESSION [=] @B{@<string@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::compress),
                                         HA_CREATE_USED_COMPRESS>
    PT_create_compress_option;
 
/**
  Node for the @SQL{ENGRYPTION [=] @B{@<string@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::encrypt_type), HA_CREATE_USED_ENCRYPT>
    PT_create_encryption_option;
 
/**
  Node for the @SQL{AUTO_INCREMENT [=] @B{@<integer@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::auto_increment_value), HA_CREATE_USED_AUTO>
    PT_create_auto_increment_option;
 
typedef PT_traceable_create_table_option<TYPE_AND_REF(HA_CREATE_INFO::row_type),
                                         HA_CREATE_USED_ROW_FORMAT>
    PT_create_row_format_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::merge_insert_method),
    HA_CREATE_USED_INSERT_METHOD>
    PT_create_insert_method_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::data_file_name), HA_CREATE_USED_DATADIR>
    PT_create_data_directory_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::index_file_name), HA_CREATE_USED_INDEXDIR>
    PT_create_index_directory_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::tablespace), HA_CREATE_USED_TABLESPACE>
    PT_create_tablespace_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::connect_string), HA_CREATE_USED_CONNECTION>
    PT_create_connection_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::key_block_size), HA_CREATE_USED_KEY_BLOCK_SIZE>
    PT_create_key_block_size_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::m_transactional_ddl),
    HA_CREATE_USED_START_TRANSACTION>
    PT_create_start_transaction_option;
 
typedef PT_traceable_create_table_option<
    TYPE_AND_REF(HA_CREATE_INFO::m_implicit_tablespace_autoextend_size),
    HA_CREATE_USED_AUTOEXTEND_SIZE>
    PT_create_ts_autoextend_size_option;
 
typedef decltype(HA_CREATE_INFO::table_options) table_options_t;
 
/**
  A template for options that set HA_CREATE_INFO::table_options and
  also records if the option was explicitly set.
*/
template <ulong Property_flag, table_options_t Default, table_options_t Yes,
          table_options_t No>
class PT_ternary_create_table_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const Ternary_option value;
 
 public:
  explicit PT_ternary_create_table_option(const POS &pos, Ternary_option value)
      : super(pos), value(value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    pc->create_info->table_options &= ~(Yes | No);
    switch (value) {
      case Ternary_option::ON:
        pc->create_info->table_options |= Yes;
        break;
      case Ternary_option::OFF:
        pc->create_info->table_options |= No;
        break;
      case Ternary_option::DEFAULT:
        break;
      default:
        assert(false);
    }
    pc->create_info->used_fields |= Property_flag;
    return false;
  }
};
 
/**
  Node for the @SQL{PACK_KEYS [=] @B{1|0|DEFAULT}} table option
 
  @ingroup ptn_create_or_alter_table_options
 
  PACK_KEYS | Constructor parameter
  ----------|----------------------
  1         | Ternary_option::ON
  0         | Ternary_option::OFF
  DEFAULT   | Ternary_option::DEFAULT
*/
typedef PT_ternary_create_table_option<HA_CREATE_USED_PACK_KEYS,  // flag
                                       0,                         // DEFAULT
                                       HA_OPTION_PACK_KEYS,       // ON
                                       HA_OPTION_NO_PACK_KEYS>    // OFF
    PT_create_pack_keys_option;
 
/**
  Node for the @SQL{STATS_PERSISTENT [=] @B{1|0|DEFAULT}} table option
 
  @ingroup ptn_create_or_alter_table_options
 
  STATS_PERSISTENT | Constructor parameter
  -----------------|----------------------
  1                | Ternary_option::ON
  0                | Ternary_option::OFF
  DEFAULT          | Ternary_option::DEFAULT
*/
typedef PT_ternary_create_table_option<HA_CREATE_USED_STATS_PERSISTENT,  // flag
                                       0,                           // DEFAULT
                                       HA_OPTION_STATS_PERSISTENT,  // ON
                                       HA_OPTION_NO_STATS_PERSISTENT>  // OFF
    PT_create_stats_persistent_option;
 
/**
  A template for options that set HA_CREATE_INFO::table_options and
  also records if the option was explicitly set.
*/
template <ulong Property_flag, table_options_t Yes, table_options_t No>
class PT_bool_create_table_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const bool value;
 
 public:
  explicit PT_bool_create_table_option(const POS &pos, bool value)
      : super(pos), value(value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    pc->create_info->table_options &= ~(Yes | No);
    pc->create_info->table_options |= value ? Yes : No;
    pc->create_info->used_fields |= Property_flag;
    return false;
  }
};
 
/**
  Node for the @SQL{CHECKSUM|TABLE_CHECKSUM [=] @B{0|@<not 0@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
 
  TABLE_CHECKSUM | Constructor parameter
  ---------------|----------------------
  0              | false
  not 0          | true
*/
typedef PT_bool_create_table_option<HA_CREATE_USED_CHECKSUM,  // flag
                                    HA_OPTION_CHECKSUM,       // ON
                                    HA_OPTION_NO_CHECKSUM     // OFF
                                    >
    PT_create_checksum_option;
 
/**
  Node for the @SQL{DELAY_KEY_WRITE [=] @B{0|@<not 0@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
 
  TABLE_CHECKSUM | Constructor parameter
  ---------------|----------------------
  0              | false
  not 0          | true
*/
typedef PT_bool_create_table_option<HA_CREATE_USED_DELAY_KEY_WRITE,  // flag
                                    HA_OPTION_DELAY_KEY_WRITE,       // ON
                                    HA_OPTION_NO_DELAY_KEY_WRITE>    // OFF
    PT_create_delay_key_write_option;
 
/**
  Node for the @SQL{ENGINE [=] @B{@<identifier@>|@<string@>}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_create_table_engine_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const LEX_CSTRING engine;
 
 public:
  /**
    @param pos          Position of this clause in the SQL statement.
    @param engine       Storage engine name.
  */
  explicit PT_create_table_engine_option(const POS &pos,
                                         const LEX_CSTRING &engine)
      : super(pos), engine(engine) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
/**
  Node for the @SQL{SECONDARY_ENGINE [=] @B{@<identifier@>|@<string@>|NULL}}
  table option.
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_create_table_secondary_engine_option : public PT_create_table_option {
  using super = PT_create_table_option;
 
 public:
  explicit PT_create_table_secondary_engine_option(const POS &pos)
      : super(pos) {}
  explicit PT_create_table_secondary_engine_option(
      const POS &pos, const LEX_CSTRING &secondary_engine)
      : super(pos), m_secondary_engine(secondary_engine) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
 
 private:
  const LEX_CSTRING m_secondary_engine{nullptr, 0};
};
 
/**
  Node for the @SQL{STATS_AUTO_RECALC [=] @B{@<0|1|DEFAULT@>})} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_create_stats_auto_recalc_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const Ternary_option value;
 
 public:
  /**
    @param pos Position of this clause in the SQL statement.
    @param value
      STATS_AUTO_RECALC | value
      ------------------|----------------------
      1                 | Ternary_option::ON
      0                 | Ternary_option::OFF
      DEFAULT           | Ternary_option::DEFAULT
  */
  PT_create_stats_auto_recalc_option(const POS &pos, Ternary_option value)
      : super(pos), value(value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
/**
  Node for the @SQL{STATS_SAMPLE_PAGES [=] @B{@<integer@>|DEFAULT}} table option
 
  @ingroup ptn_create_or_alter_table_options
*/
class PT_create_stats_stable_pages : public PT_create_table_option {
  typedef PT_create_table_option super;
  typedef decltype(HA_CREATE_INFO::stats_sample_pages) value_t;
 
  const value_t value;
 
 public:
  /**
    Constructor for implicit number of pages
 
    @param pos         Position of this clause in the SQL statement.
    @param value       Number of pages, 1@<=N@<=65535.
  */
  explicit PT_create_stats_stable_pages(const POS &pos, value_t value)
      : super(pos), value(value) {
    assert(value != 0 && value <= 0xFFFF);
  }
  /**
    Constructor for the DEFAULT number of pages
  */
  explicit PT_create_stats_stable_pages(const POS &pos)
      : super(pos), value(0) {}  // DEFAULT
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
class PT_create_union_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const Mem_root_array<Table_ident *> *tables;
 
 public:
  explicit PT_create_union_option(const POS &pos,
                                  const Mem_root_array<Table_ident *> *tables)
      : super(pos), tables(tables) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
class PT_create_storage_option : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const ha_storage_media value;
 
 public:
  explicit PT_create_storage_option(const POS &pos, ha_storage_media value)
      : super(pos), value(value) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
    pc->create_info->storage_media = value;
    return false;
  }
};
 
class PT_create_table_default_charset : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const CHARSET_INFO *value;
 
 public:
  explicit PT_create_table_default_charset(const POS &pos,
                                           const CHARSET_INFO *value)
      : super(pos), value(value) {
    assert(value != nullptr);
  }
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
class PT_create_table_default_collation : public PT_create_table_option {
  typedef PT_create_table_option super;
 
  const CHARSET_INFO *value;
 
 public:
  explicit PT_create_table_default_collation(const POS &pos,
                                             const CHARSET_INFO *value)
      : super(pos), value(value) {
    assert(value != nullptr);
  }
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
class PT_check_constraint final : public PT_table_constraint_def {
  typedef PT_table_constraint_def super;
  Sql_check_constraint_spec cc_spec;
 
 public:
  explicit PT_check_constraint(const POS &pos, LEX_STRING &name, Item *expr,
                               bool is_enforced)
      : super(pos) {
    cc_spec.name = name;
    cc_spec.check_expr = expr;
    cc_spec.is_enforced = is_enforced;
  }
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
class PT_column_def : public PT_table_element {
  typedef PT_table_element super;
 
  const LEX_STRING field_ident;
  PT_field_def_base *field_def;
  PT_table_constraint_def *opt_column_constraint;
 
  const char *opt_place;
 
 public:
  PT_column_def(const POS &pos, const LEX_STRING &field_ident,
                PT_field_def_base *field_def,
                PT_table_constraint_def *opt_column_constraint,
                const char *opt_place = nullptr)
      : super(pos),
        field_ident(field_ident),
        field_def(field_def),
        opt_column_constraint(opt_column_constraint),
        opt_place(opt_place) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
};
 
/**
  Top-level node for the CREATE %TABLE statement
 
  @ingroup ptn_create_table
*/
class PT_create_table_stmt final : public PT_table_ddl_stmt_base {
  bool is_temporary;
  bool only_if_not_exists;
  Table_ident *table_name;
  const Mem_root_array<PT_table_element *> *opt_table_element_list;
  const Mem_root_array<PT_create_table_option *> *opt_create_table_options;
  PT_partition *opt_partitioning;
  On_duplicate on_duplicate;
  PT_query_expression_body *opt_query_expression;
  Table_ident *opt_like_clause;
 
  HA_CREATE_INFO m_create_info;
 
 public:
  /**
    @param pos                        Position of this clause in the SQL
                                      statement.
    @param mem_root                   MEM_ROOT to use for allocation
    @param is_temporary               True if @SQL{CREATE @B{TEMPORARY} %TABLE}
    @param only_if_not_exists  True if @SQL{CREATE %TABLE ... @B{IF NOT EXISTS}}
    @param table_name                 @SQL{CREATE %TABLE ... @B{@<table name@>}}
    @param opt_table_element_list     NULL or a list of table column and
                                      constraint definitions.
    @param opt_create_table_options   NULL or a list of
                                      @ref ptn_create_or_alter_table_options
                                      "table options".
    @param opt_partitioning           NULL or the @SQL{PARTITION BY} clause.
    @param on_duplicate               DUPLICATE, IGNORE or fail with an error
                                      on data duplication errors (relevant
                                      for @SQL{CREATE TABLE ... SELECT}
                                      statements).
    @param opt_query_expression       NULL or the @SQL{@B{SELECT}} clause.
  */
  PT_create_table_stmt(
      const POS &pos, MEM_ROOT *mem_root, bool is_temporary,
      bool only_if_not_exists, Table_ident *table_name,
      const Mem_root_array<PT_table_element *> *opt_table_element_list,
      const Mem_root_array<PT_create_table_option *> *opt_create_table_options,
      PT_partition *opt_partitioning, On_duplicate on_duplicate,
      PT_query_expression_body *opt_query_expression)
      : PT_table_ddl_stmt_base(pos, mem_root),
        is_temporary(is_temporary),
        only_if_not_exists(only_if_not_exists),
        table_name(table_name),
        opt_table_element_list(opt_table_element_list),
        opt_create_table_options(opt_create_table_options),
        opt_partitioning(opt_partitioning),
        on_duplicate(on_duplicate),
        opt_query_expression(opt_query_expression),
        opt_like_clause(nullptr) {}
  /**
    @param pos                Position of this clause in the SQL statement.
    @param mem_root           MEM_ROOT to use for allocation
    @param is_temporary       True if @SQL{CREATE @B{TEMPORARY} %TABLE}.
    @param only_if_not_exists True if @SQL{CREATE %TABLE ... @B{IF NOT EXISTS}}.
    @param table_name         @SQL{CREATE %TABLE ... @B{@<table name@>}}.
    @param opt_like_clause    NULL or the @SQL{@B{LIKE @<table name@>}} clause.
  */
  PT_create_table_stmt(const POS &pos, MEM_ROOT *mem_root, bool is_temporary,
                       bool only_if_not_exists, Table_ident *table_name,
                       Table_ident *opt_like_clause)
      : PT_table_ddl_stmt_base(pos, mem_root),
        is_temporary(is_temporary),
        only_if_not_exists(only_if_not_exists),
        table_name(table_name),
        opt_table_element_list(nullptr),
        opt_create_table_options(nullptr),
        opt_partitioning(nullptr),
        on_duplicate(On_duplicate::ERROR),
        opt_query_expression(nullptr),
        opt_like_clause(opt_like_clause) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_create_role final : public Parse_tree_root {
  Sql_cmd_create_role sql_cmd;
 
 public:
  PT_create_role(const POS &pos, bool if_not_exists,
                 const List<LEX_USER> *roles)
      : Parse_tree_root(pos), sql_cmd(if_not_exists, roles) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_drop_role final : public Parse_tree_root {
  Sql_cmd_drop_role sql_cmd;
 
 public:
  explicit PT_drop_role(const POS &pos, bool ignore_errors,
                        const List<LEX_USER> *roles)
      : Parse_tree_root(pos), sql_cmd(ignore_errors, roles) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_set_role : public Parse_tree_root {
  Sql_cmd_set_role sql_cmd;
 
 public:
  explicit PT_set_role(const POS &pos, role_enum role_type,
                       const List<LEX_USER> *opt_except_roles = nullptr)
      : Parse_tree_root(pos), sql_cmd(role_type, opt_except_roles) {
    assert(role_type == role_enum::ROLE_ALL || opt_except_roles == nullptr);
  }
  explicit PT_set_role(const POS &pos, const List<LEX_USER> *roles)
      : Parse_tree_root(pos), sql_cmd(roles) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/**
  This class is used for representing both static and dynamic privileges on
  global as well as table and column level.
*/
struct Privilege {
  enum privilege_type { STATIC, DYNAMIC };
 
  privilege_type type;
  const Mem_root_array<LEX_CSTRING> *columns;
 
  explicit Privilege(privilege_type type,
                     const Mem_root_array<LEX_CSTRING> *columns)
      : type(type), columns(columns) {}
};
 
struct Static_privilege : public Privilege {
  const uint grant;
 
  Static_privilege(uint grant, const Mem_root_array<LEX_CSTRING> *columns_arg)
      : Privilege(STATIC, columns_arg), grant(grant) {}
};
 
struct Dynamic_privilege : public Privilege {
  const LEX_STRING ident;
 
  Dynamic_privilege(const LEX_STRING &ident,
                    const Mem_root_array<LEX_CSTRING> *columns_arg)
      : Privilege(DYNAMIC, columns_arg), ident(ident) {}
};
 
class PT_role_or_privilege : public Parse_tree_node {
 private:
  POS m_errpos;
 
 public:
  explicit PT_role_or_privilege(const POS &pos, const POS &errpos)
      : Parse_tree_node(pos), m_errpos(errpos) {}
  virtual LEX_USER *get_user(THD *thd);
  virtual Privilege *get_privilege(THD *thd);
};
 
class PT_role_at_host final : public PT_role_or_privilege {
  LEX_STRING role;
  LEX_STRING host;
 
 public:
  PT_role_at_host(const POS &pos, const POS &errpos, const LEX_STRING &role,
                  const LEX_STRING &host)
      : PT_role_or_privilege(pos, errpos), role(role), host(host) {}
 
  LEX_USER *get_user(THD *thd) override;
};
 
class PT_role_or_dynamic_privilege final : public PT_role_or_privilege {
  LEX_STRING ident;
 
 public:
  PT_role_or_dynamic_privilege(const POS &pos, const POS &errpos,
                               const LEX_STRING &ident)
      : PT_role_or_privilege(pos, errpos), ident(ident) {}
 
  LEX_USER *get_user(THD *thd) override;
  Privilege *get_privilege(THD *thd) override;
};
 
class PT_static_privilege final : public PT_role_or_privilege {
  const uint grant;
  const Mem_root_array<LEX_CSTRING> *columns;
 
 public:
  PT_static_privilege(const POS &pos, const POS &errpos, uint grant,
                      const Mem_root_array<LEX_CSTRING> *columns = nullptr)
      : PT_role_or_privilege(pos, errpos), grant(grant), columns(columns) {}
 
  Privilege *get_privilege(THD *thd) override;
};
 
class PT_dynamic_privilege final : public PT_role_or_privilege {
  LEX_STRING ident;
 
 public:
  PT_dynamic_privilege(const POS &pos, const POS &errpos,
                       const LEX_STRING &ident)
      : PT_role_or_privilege(pos, errpos), ident(ident) {}
 
  Privilege *get_privilege(THD *thd) override;
};
 
class PT_grant_roles final : public Parse_tree_root {
  const Mem_root_array<PT_role_or_privilege *> *roles;
  const List<LEX_USER> *users;
  const bool with_admin_option;
 
 public:
  PT_grant_roles(const POS &pos,
                 const Mem_root_array<PT_role_or_privilege *> *roles,
                 const List<LEX_USER> *users, bool with_admin_option)
      : Parse_tree_root(pos),
        roles(roles),
        users(users),
        with_admin_option(with_admin_option) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_revoke_roles final : public Parse_tree_root {
  const Mem_root_array<PT_role_or_privilege *> *roles;
  const List<LEX_USER> *users;
 
 public:
  PT_revoke_roles(const POS &pos, Mem_root_array<PT_role_or_privilege *> *roles,
                  const List<LEX_USER> *users)
      : Parse_tree_root(pos), roles(roles), users(users) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
class PT_alter_user_default_role final : public Parse_tree_root {
  Sql_cmd_alter_user_default_role sql_cmd;
 
 public:
  PT_alter_user_default_role(const POS &pos, bool if_exists,
                             const List<LEX_USER> *users,
                             const List<LEX_USER> *roles,
                             const role_enum role_type)
      : Parse_tree_root(pos), sql_cmd(if_exists, users, roles, role_type) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
};
 
/// Base class for Parse tree nodes of SHOW statements
 
class PT_show_base : public Parse_tree_root {
 protected:
  PT_show_base(const POS &pos, enum_sql_command sql_command)
      : Parse_tree_root(pos), m_sql_command(sql_command) {}
 
  /// SQL command
  enum_sql_command m_sql_command;
};
 
/// Base class for Parse tree nodes of SHOW statements with LIKE/WHERE parameter
 
class PT_show_filter_base : public PT_show_base {
 protected:
  PT_show_filter_base(const POS &pos, enum_sql_command sql_command,
                      const LEX_STRING &wild, Item *where)
      : PT_show_base(pos, sql_command), m_wild(wild), m_where(where) {
    assert(m_wild.str == nullptr || m_where == nullptr);
  }
  /// Wild or where clause used in the statement.
  LEX_STRING m_wild;
  Item *m_where;
};
 
/// Base class for Parse tree nodes of SHOW statements with schema parameter.
 
class PT_show_schema_base : public PT_show_base {
 protected:
  PT_show_schema_base(const POS &pos, enum_sql_command sql_command,
                      char *opt_db, const LEX_STRING &wild, Item *where)
      : PT_show_base(pos, sql_command),
        m_opt_db(opt_db),
        m_wild(wild),
        m_where(where) {
    assert(m_wild.str == nullptr || m_where == nullptr);
  }
  /// Optional schema name in FROM/IN clause.
  char *m_opt_db;
  /// Wild or where clause used in the statement.
  LEX_STRING m_wild;
  Item *m_where;
};
 
/// Base class for Parse tree nodes of SHOW COLUMNS/SHOW INDEX statements.
 
class PT_show_table_base : public PT_show_filter_base {
 protected:
  PT_show_table_base(const POS &pos, enum_sql_command sql_command,
                     Table_ident *table_ident, const LEX_STRING &wild,
                     Item *where)
      : PT_show_filter_base(pos, sql_command, wild, where),
        m_table_ident(table_ident) {}
 
  bool make_table_base_cmd(THD *thd, bool *temporary);
 
  /// Table used in the statement.
  Table_ident *m_table_ident;
};
 
/// Parse tree node for SHOW FUNCTION/PROCEDURE CODE statements.
 
class PT_show_routine_code : public PT_show_base {
 protected:
  PT_show_routine_code(const POS &pos, enum_sql_command sql_command,
                       const sp_name *routine_name)
      : PT_show_base(pos, sql_command), m_sql_cmd(sql_command, routine_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_routine_code m_sql_cmd;
};
 
/// Parse tree node for SHOW BINLOG EVENTS statement
 
class PT_show_binlog_events final : public PT_show_base {
 public:
  PT_show_binlog_events(const POS &pos, const LEX_STRING opt_log_file_name = {},
                        PT_limit_clause *opt_limit_clause = nullptr)
      : PT_show_base(pos, SQLCOM_SHOW_BINLOG_EVENTS),
        m_opt_log_file_name(opt_log_file_name),
        m_opt_limit_clause(opt_limit_clause) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  const LEX_STRING m_opt_log_file_name;
  PT_limit_clause *const m_opt_limit_clause;
 
  Sql_cmd_show_binlog_events m_sql_cmd;
};
 
/// Parse tree node for SHOW BINLOGS statement
 
class PT_show_binlogs final : public PT_show_base {
 public:
  PT_show_binlogs(const POS &pos) : PT_show_base(pos, SQLCOM_SHOW_BINLOGS) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_binlogs m_sql_cmd;
};
 
/// Parse tree node for SHOW CHARACTER SET statement
 
class PT_show_charsets final : public PT_show_filter_base {
 public:
  PT_show_charsets(const POS &pos, const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_CHARSETS, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_charsets m_sql_cmd;
};
 
/// Parse tree node for SHOW COLLATIONS statement
 
class PT_show_collations final : public PT_show_filter_base {
 public:
  PT_show_collations(const POS &pos, const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_COLLATIONS, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_collations m_sql_cmd;
};
 
/// Base class for Parse tree nodes of SHOW COUNT(*) { WARNINGS | ERRORS }
/// statements.
 
class PT_show_count_base : public PT_show_base {
 public:
  explicit PT_show_count_base(const POS &pos)
      : PT_show_base{pos, SQLCOM_SELECT} {}
 
 protected:
  Sql_cmd *make_cmd_generic(THD *thd, LEX_CSTRING diagnostic_variable_name);
};
 
/// Parse tree node for SHOW COUNT(*) ERRORS
 
class PT_show_count_errors final : public PT_show_count_base {
 public:
  explicit PT_show_count_errors(const POS &pos) : PT_show_count_base(pos) {}
 
  Sql_cmd *make_cmd(THD *thd) override {
    return make_cmd_generic(thd, LEX_CSTRING{STRING_WITH_LEN("error_count")});
  }
};
 
/// Parse tree node for SHOW COUNT(*) WARNINGS
 
class PT_show_count_warnings final : public PT_show_count_base {
 public:
  explicit PT_show_count_warnings(const POS &pos) : PT_show_count_base(pos) {}
 
  Sql_cmd *make_cmd(THD *thd) override {
    return make_cmd_generic(thd, LEX_CSTRING{STRING_WITH_LEN("warning_count")});
  }
};
 
/// Parse tree node for SHOW CREATE DATABASE statement
 
class PT_show_create_database final : public PT_show_base {
 public:
  PT_show_create_database(const POS &pos, bool if_not_exists,
                          const LEX_STRING &name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_DB),
        m_if_not_exists(if_not_exists),
        m_name(name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  const bool m_if_not_exists;
  const LEX_STRING m_name;
 
  Sql_cmd_show_create_database m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE EVENT statement
 
class PT_show_create_event final : public PT_show_base {
 public:
  PT_show_create_event(const POS &pos, sp_name *event_name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_EVENT), m_spname(event_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  sp_name *const m_spname;
 
  Sql_cmd_show_create_event m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE FUNCTION statement
 
class PT_show_create_function final : public PT_show_base {
 public:
  PT_show_create_function(const POS &pos, sp_name *function_name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_FUNC), m_spname(function_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  sp_name *const m_spname;
 
  Sql_cmd_show_create_function m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE LIBRARY statement
 
class PT_show_create_library final : public PT_show_base {
 public:
  PT_show_create_library(const POS &pos, sp_name *library_name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_LIBRARY), m_spname(library_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  sp_name *const m_spname;
 
  Sql_cmd_show_create_library m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE PROCEDURE statement
 
class PT_show_create_procedure final : public PT_show_base {
 public:
  PT_show_create_procedure(const POS &pos, sp_name *procedure_name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_PROC), m_spname(procedure_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  sp_name *const m_spname;
 
  Sql_cmd_show_create_procedure m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE TABLE and VIEW statements
 
class PT_show_create_table final : public PT_show_base {
 public:
  PT_show_create_table(const POS &pos, Table_ident *table_ident)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE), m_sql_cmd(false, table_ident) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_create_table m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE TRIGGER statement
 
class PT_show_create_trigger final : public PT_show_base {
 public:
  PT_show_create_trigger(const POS &pos, sp_name *trigger_name)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_TRIGGER), m_spname(trigger_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  sp_name *const m_spname;
 
  Sql_cmd_show_create_trigger m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE USER statement
 
class PT_show_create_user final : public PT_show_base {
 public:
  PT_show_create_user(const POS &pos, LEX_USER *user)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE_USER), m_user(user) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  LEX_USER *const m_user;
 
  Sql_cmd_show_create_user m_sql_cmd;
};
 
/// Parse tree node for SHOW CREATE VIEW statement
 
class PT_show_create_view final : public PT_show_base {
 public:
  PT_show_create_view(const POS &pos, Table_ident *table_ident)
      : PT_show_base(pos, SQLCOM_SHOW_CREATE), m_sql_cmd(true, table_ident) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_create_table m_sql_cmd;
};
 
/// Parse tree node for SHOW DATABASES statement
 
class PT_show_databases final : public PT_show_filter_base {
 public:
  PT_show_databases(const POS &pos, const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_DATABASES, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_databases m_sql_cmd;
};
 
/// Parse tree node for SHOW ENGINE statements
 
class PT_show_engine_base : public PT_show_base {
 protected:
  PT_show_engine_base(const POS &pos, enum enum_sql_command sql_command,
                      const LEX_STRING opt_engine = {})
      : PT_show_base(pos, sql_command),
        m_engine(opt_engine),
        m_all(opt_engine.str == nullptr) {}
 
  LEX_STRING m_engine;
  bool m_all;
};
 
/// Parse tree node for SHOW ENGINE LOGS statement
 
class PT_show_engine_logs final : public PT_show_engine_base {
 public:
  PT_show_engine_logs(const POS &pos, LEX_STRING opt_engine = {})
      : PT_show_engine_base(pos, SQLCOM_SHOW_ENGINE_LOGS, opt_engine) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_engine_logs m_sql_cmd;
};
 
/// Parse tree node for SHOW ENGINE MUTEX statement
 
class PT_show_engine_mutex final : public PT_show_engine_base {
 public:
  PT_show_engine_mutex(const POS &pos, LEX_STRING opt_engine = {})
      : PT_show_engine_base(pos, SQLCOM_SHOW_ENGINE_MUTEX, opt_engine) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_engine_mutex m_sql_cmd;
};
 
/// Parse tree node for SHOW ENGINE STATUS statement
 
class PT_show_engine_status final : public PT_show_engine_base {
 public:
  PT_show_engine_status(const POS &pos, LEX_STRING opt_engine = {})
      : PT_show_engine_base(pos, SQLCOM_SHOW_ENGINE_STATUS, opt_engine) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_engine_status m_sql_cmd;
};
 
/// Parse tree node for SHOW ENGINES statement
 
class PT_show_engines final : public PT_show_base {
 public:
  PT_show_engines(const POS &pos)
      : PT_show_base(pos, SQLCOM_SHOW_STORAGE_ENGINES) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_engines m_sql_cmd;
};
 
/// Parse tree node for SHOW ERRORS statement
 
class PT_show_errors final : public PT_show_base {
 public:
  PT_show_errors(const POS &pos, PT_limit_clause *opt_limit_clause = nullptr)
      : PT_show_base(pos, SQLCOM_SHOW_ERRORS),
        m_opt_limit_clause(opt_limit_clause) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  PT_limit_clause *const m_opt_limit_clause;
 
  Sql_cmd_show_errors m_sql_cmd;
};
 
/// Parse tree node for SHOW EVENTS statement
 
class PT_show_events final : public PT_show_schema_base {
 public:
  PT_show_events(const POS &pos, char *opt_db, const LEX_STRING &wild,
                 Item *where)
      : PT_show_schema_base(pos, SQLCOM_SHOW_EVENTS, opt_db, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_events m_sql_cmd;
};
 
/// Parse tree node for SHOW COLUMNS statement.
 
class PT_show_fields final : public PT_show_table_base {
  typedef PT_show_table_base super;
 
 public:
  PT_show_fields(const POS &pos, Show_cmd_type show_cmd_type,
                 Table_ident *table, LEX_STRING opt_wild = {},
                 Item *opt_where = nullptr)
      : PT_show_table_base(pos, SQLCOM_SHOW_FIELDS, table, opt_wild, opt_where),
        m_show_cmd_type(show_cmd_type) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Show_cmd_type m_show_cmd_type;
  Sql_cmd_show_columns m_sql_cmd;
};
 
/// Parse tree node for SHOW FUNCTION CODE statement.
 
class PT_show_function_code final : public PT_show_routine_code {
 public:
  PT_show_function_code(const POS &pos, const sp_name *function_name)
      : PT_show_routine_code(pos, SQLCOM_SHOW_FUNC_CODE, function_name) {}
};
 
/// Parse tree node for SHOW GRANTS statement.
 
class PT_show_grants final : public PT_show_base {
 public:
  PT_show_grants(const POS &pos, const LEX_USER *opt_for_user,
                 const List<LEX_USER> *opt_using_users)
      : PT_show_base(pos, SQLCOM_SHOW_GRANTS),
        sql_cmd(opt_for_user, opt_using_users) {
    assert(opt_using_users == nullptr || opt_for_user != nullptr);
  }
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_grants sql_cmd;
};
 
/// Parse tree node for SHOW INDEX statement.
 
class PT_show_keys final : public PT_show_table_base {
 public:
  PT_show_keys(const POS &pos, bool extended_show, Table_ident *table,
               Item *where)
      : PT_show_table_base(pos, SQLCOM_SHOW_KEYS, table, NULL_STR, where),
        m_extended_show(extended_show) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  typedef PT_show_table_base super;
 
  // Flag to indicate EXTENDED keyword usage in the statement.
  bool m_extended_show;
  Sql_cmd_show_keys m_sql_cmd;
};
 
/// Parse tree node for SHOW BINARY LOG STATUS statement
 
class PT_show_binary_log_status final : public PT_show_base {
 public:
  PT_show_binary_log_status(const POS &pos)
      : PT_show_base(pos, SQLCOM_SHOW_BINLOG_STATUS) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_binary_log_status m_sql_cmd;
};
 
/// Parse tree node for SHOW OPEN TABLES statement
 
class PT_show_open_tables final : public PT_show_schema_base {
 public:
  PT_show_open_tables(const POS &pos, char *opt_db, const LEX_STRING &wild,
                      Item *where)
      : PT_show_schema_base(pos, SQLCOM_SHOW_OPEN_TABLES, opt_db, wild, where) {
  }
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_open_tables m_sql_cmd;
};
 
/// Parse tree node for SHOW PLUGINS statement
 
class PT_show_plugins final : public PT_show_base {
 public:
  PT_show_plugins(const POS &pos) : PT_show_base(pos, SQLCOM_SHOW_PLUGINS) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_plugins m_sql_cmd;
};
 
/// Parse tree node for SHOW PRIVILEGES statement
 
class PT_show_privileges final : public PT_show_base {
 public:
  PT_show_privileges(const POS &pos)
      : PT_show_base(pos, SQLCOM_SHOW_PRIVILEGES) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_privileges m_sql_cmd;
};
 
/// Parse tree node for SHOW PARSE_TREE statement
 
class PT_show_parse_tree final : public PT_show_base {
 public:
  PT_show_parse_tree(const POS &pos, Parse_tree_root *parse_tree_stmt)
      : PT_show_base(pos, SQLCOM_SHOW_PARSE_TREE),
        m_parse_tree_stmt(parse_tree_stmt) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Parse_tree_root *const m_parse_tree_stmt;
  Sql_cmd_show_parse_tree m_sql_cmd;
};
 
/// Parse tree node for SHOW FUNCTION CODE statement.
 
class PT_show_procedure_code final : public PT_show_routine_code {
 public:
  PT_show_procedure_code(const POS &pos, const sp_name *procedure_name)
      : PT_show_routine_code(pos, SQLCOM_SHOW_PROC_CODE, procedure_name) {}
};
 
/// Parse tree node for SHOW PROCESSLIST statement
 
class PT_show_processlist final : public PT_show_base {
 public:
  PT_show_processlist(const POS &pos, bool verbose)
      : PT_show_base(pos, SQLCOM_SHOW_PROCESSLIST), m_sql_cmd(verbose) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_processlist m_sql_cmd;
};
 
/// Parse tree node for SHOW PROFILE statement
 
class PT_show_profile final : public PT_show_base {
 public:
  PT_show_profile(const POS &pos, uint opt_profile_options = 0,
                  my_thread_id opt_query_id = 0,
                  PT_limit_clause *opt_limit_clause = nullptr)
      : PT_show_base(pos, SQLCOM_SHOW_PROFILE),
        m_opt_profile_options(opt_profile_options),
        m_opt_query_id(opt_query_id),
        m_opt_limit_clause(opt_limit_clause) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  uint m_opt_profile_options;
  my_thread_id m_opt_query_id;
  PT_limit_clause *const m_opt_limit_clause;
 
  Sql_cmd_show_profile m_sql_cmd;
};
 
/// Parse tree node for SHOW PROFILES statement
 
class PT_show_profiles final : public PT_show_base {
 public:
  PT_show_profiles(const POS &pos) : PT_show_base(pos, SQLCOM_SHOW_PROFILES) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_profiles m_sql_cmd;
};
 
/// Parse tree node for SHOW RELAYLOG EVENTS statement
 
class PT_show_relaylog_events final : public PT_show_base {
 public:
  PT_show_relaylog_events(const POS &pos,
                          const LEX_STRING opt_log_file_name = {},
                          PT_limit_clause *opt_limit_clause = nullptr,
                          LEX_CSTRING opt_channel_name = {})
      : PT_show_base(pos, SQLCOM_SHOW_RELAYLOG_EVENTS),
        m_opt_log_file_name(opt_log_file_name),
        m_opt_limit_clause(opt_limit_clause),
        m_opt_channel_name(opt_channel_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  const LEX_STRING m_opt_log_file_name;
  PT_limit_clause *const m_opt_limit_clause;
  const LEX_CSTRING m_opt_channel_name;
 
  Sql_cmd_show_relaylog_events m_sql_cmd;
};
 
/// Parse tree node for SHOW REPLICAS statement
 
class PT_show_replicas final : public PT_show_base {
 public:
  PT_show_replicas(const POS &pos) : PT_show_base(pos, SQLCOM_SHOW_REPLICAS) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_replicas m_sql_cmd;
};
 
/// Parse tree node for SHOW REPLICA STATUS statement
 
class PT_show_replica_status final : public PT_show_base {
 public:
  PT_show_replica_status(const POS &pos, LEX_CSTRING opt_channel_name = {})
      : PT_show_base(pos, SQLCOM_SHOW_REPLICA_STATUS),
        m_opt_channel_name(opt_channel_name) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  const LEX_CSTRING m_opt_channel_name;
 
  Sql_cmd_show_replica_status m_sql_cmd;
};
 
/// Parse tree node for SHOW STATUS statement
 
class PT_show_status final : public PT_show_filter_base {
 public:
  PT_show_status(const POS &pos, enum_var_type var_type, const LEX_STRING &wild,
                 Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_STATUS, wild, where),
        m_var_type(var_type) {
    assert(m_var_type == OPT_SESSION || m_var_type == OPT_GLOBAL);
  }
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_status m_sql_cmd;
 
  enum_var_type m_var_type;
};
 
/// Parse tree node for SHOW STATUS FUNCTION statement
 
class PT_show_status_func final : public PT_show_filter_base {
 public:
  PT_show_status_func(const POS &pos, const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_STATUS_FUNC, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_status_func m_sql_cmd;
};
 
/// Parse tree node for SHOW STATUS PROCEDURE statement
 
class PT_show_status_proc final : public PT_show_filter_base {
 public:
  PT_show_status_proc(const POS &pos, const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_STATUS_PROC, wild, where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_status_proc m_sql_cmd;
};
 
/// Parse tree node for SHOW TABLE STATUS statement
 
class PT_show_table_status final : public PT_show_schema_base {
 public:
  PT_show_table_status(const POS &pos, char *opt_db, const LEX_STRING &wild,
                       Item *where)
      : PT_show_schema_base(pos, SQLCOM_SHOW_TABLE_STATUS, opt_db, wild,
                            where) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_table_status m_sql_cmd;
};
 
/// Parse tree node for SHOW TABLES statement
 
class PT_show_tables final : public PT_show_schema_base {
 public:
  PT_show_tables(const POS &pos, Show_cmd_type show_cmd_type, char *opt_db,
                 const LEX_STRING &wild, Item *where)
      : PT_show_schema_base(pos, SQLCOM_SHOW_TABLES, opt_db, wild, where),
        m_show_cmd_type(show_cmd_type) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_tables m_sql_cmd;
 
  Show_cmd_type m_show_cmd_type;
};
 
/// Parse tree node for SHOW TRIGGERS statement
 
class PT_show_triggers final : public PT_show_schema_base {
 public:
  PT_show_triggers(const POS &pos, bool full, char *opt_db,
                   const LEX_STRING &wild, Item *where)
      : PT_show_schema_base(pos, SQLCOM_SHOW_TRIGGERS, opt_db, wild, where),
        m_full(full) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_triggers m_sql_cmd;
 
  bool m_full;
};
 
/// Parse tree node for SHOW VARIABLES statement
 
class PT_show_variables final : public PT_show_filter_base {
 public:
  PT_show_variables(const POS &pos, enum_var_type var_type,
                    const LEX_STRING &wild, Item *where)
      : PT_show_filter_base(pos, SQLCOM_SHOW_VARIABLES, wild, where),
        m_var_type(var_type) {
    assert(m_var_type == OPT_SESSION || m_var_type == OPT_GLOBAL);
  }
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  Sql_cmd_show_variables m_sql_cmd;
 
  enum_var_type m_var_type;
};
 
/// Parse tree node for SHOW WARNINGS statement
 
class PT_show_warnings final : public PT_show_base {
 public:
  PT_show_warnings(const POS &pos, PT_limit_clause *opt_limit_clause = nullptr)
      : PT_show_base(pos, SQLCOM_SHOW_WARNS),
        m_opt_limit_clause(opt_limit_clause) {}
 
  Sql_cmd *make_cmd(THD *thd) override;
 
 private:
  PT_limit_clause *const m_opt_limit_clause;
 
  Sql_cmd_show_warnings m_sql_cmd;
};
 
class PT_alter_table_action : public PT_ddl_table_option {
  typedef PT_ddl_table_option super;
 
 protected:
  explicit PT_alter_table_action(const POS &pos,
                                 Alter_info::Alter_info_flag flag)
      : super(pos), flag(flag) {}
 
 public:
  bool do_contextualize(Table_ddl_parse_context *pc) override;
 
 protected:
  /**
    A routine used by the parser to decide whether we are specifying a full
    partitioning or if only partitions to add or to reorganize.
 
    @retval  true    ALTER TABLE ADD/REORGANIZE PARTITION.
    @retval  false   Something else.
  */
  bool is_add_or_reorganize_partition() const {
    return (flag == Alter_info::ALTER_ADD_PARTITION ||
            flag == Alter_info::ALTER_REORGANIZE_PARTITION);
  }
 
 public:
  const Alter_info::Alter_info_flag flag;
};
 
class PT_alter_table_add_column final : public PT_alter_table_action {
  typedef PT_alter_table_action super;
 
 public:
  PT_alter_table_add_column(const POS &pos, const LEX_STRING &field_ident,
                            PT_field_def_base *field_def,
                            PT_table_constraint_def *opt_column_constraint,
                            const char *opt_place)
      : super(pos, Alter_info::ALTER_ADD_COLUMN),
        m_column_def(POS(), field_ident, field_def, opt_column_constraint,
                     opt_place) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    return super::do_contextualize(pc) || m_column_def.contextualize(pc);
  }
 
 private:
  PT_column_def m_column_def;  // TODO: Position is not set.
};
 
class PT_alter_table_add_columns final : public PT_alter_table_action {
  typedef PT_alter_table_action super;
 
 public:
  explicit PT_alter_table_add_columns(
      const POS &pos, const Mem_root_array<PT_table_element *> *columns)
      : super(pos, Alter_info::ALTER_ADD_COLUMN), m_columns(columns) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    if (super::do_contextualize(pc)) return true;
 
    for (auto *column : *m_columns)
      if (column->contextualize(pc)) return true;
 
    return false;
  }
 
 private:
  const Mem_root_array<PT_table_element *> *m_columns;
};
 
class PT_alter_table_add_constraint final : public PT_alter_table_action {
  typedef PT_alter_table_action super;
 
 public:
  explicit PT_alter_table_add_constraint(const POS &pos,
                                         PT_table_constraint_def *constraint)
      : super(pos, Alter_info::ALTER_ADD_INDEX), m_constraint(constraint) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override {
    return super::do_contextualize(pc) || m_constraint->contextualize(pc);
  }
 
 private:
  PT_table_constraint_def *m_constraint;
};
 
class PT_alter_table_change_column final : public PT_alter_table_action {
  typedef PT_alter_table_action super;
 
 public:
  PT_alter_table_change_column(const POS &pos, const LEX_STRING &old_name,
                               const LEX_STRING &new_name,
                               PT_field_def_base *field_def,
                               const char *opt_place)
      : super(pos, Alter_info::ALTER_CHANGE_COLUMN),
        m_old_name(old_name),
        m_new_name(new_name),
        m_field_def(field_def),
        m_opt_place(opt_place) {}
 
  PT_alter_table_change_column(const POS &pos, const LEX_STRING &name,
                               PT_field_def_base *field_def,
                               const char *opt_place)
      : PT_alter_table_change_column(pos, name, name, field_def, opt_place) {}
 
  bool do_contextualize(Table_ddl_parse_context *pc) override;
 
 private:
  const LEX_STRING m_old_name;
  const LEX_STRING m_new_name;
  PT_field_def_base *m_field_def;
  const char<