MySQL  8.0.27
Source Code Documentation
sql_cmd_ddl_table.h
Go to the documentation of this file.
1 /* Copyright (c) 2016, 2021, Oracle and/or its affiliates.
2 
3  This program is free software; you can redistribute it and/or modify
4  it under the terms of the GNU General Public License, version 2.0,
5  as published by the Free Software Foundation.
6 
7  This program is also distributed with certain software (including
8  but not limited to OpenSSL) that is licensed under separate terms,
9  as designated in a particular file or component or in included license
10  documentation. The authors of MySQL hereby grant you an additional
11  permission to link the program and your derivative works with the
12  separately licensed software that they have included with MySQL.
13 
14  This program is distributed in the hope that it will be useful,
15  but WITHOUT ANY WARRANTY; without even the implied warranty of
16  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17  GNU General Public License, version 2.0, for more details.
18 
19  You should have received a copy of the GNU General Public License
20  along with this program; if not, write to the Free Software
21  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22 
23 #ifndef SQL_CMD_CREATE_TABLE_INCLUDED
24 #define SQL_CMD_CREATE_TABLE_INCLUDED
25 
26 #include "lex_string.h"
27 #include "my_sqlcommand.h"
28 #include "sql/sql_cmd_ddl.h"
29 
30 class Alter_info;
31 class THD;
32 struct TABLE_LIST;
33 
34 /**
35  A base class for CREATE/ALTER TABLE commands and friends.
36 
37  Child classes deal with SQL statements:
38  * ALTER TABLE
39  * ANALYZE TABLE
40  * CACHE INDEX
41  * CHECK TABLE
42  * CREATE INDEX
43  * CREATE TABLE
44  * DROP INDEX
45  * LOAD INDEX
46  * OPTIMIZE TABLE
47  * REPAIR TABLE
48 */
49 class Sql_cmd_ddl_table : public Sql_cmd {
50  public:
51  explicit Sql_cmd_ddl_table(Alter_info *alter_info);
52 
53  ~Sql_cmd_ddl_table() override = 0; // force abstract class
54 
55  protected:
57 };
58 
59 inline Sql_cmd_ddl_table::~Sql_cmd_ddl_table() = default;
60 
62  public:
65  : Sql_cmd_ddl_table(alter_info),
67 
69  return SQLCOM_CREATE_TABLE;
70  }
71 
73 
74  bool execute(THD *thd) override;
75  bool prepare(THD *thd) override;
76 
77  private:
79 };
80 
82  public:
84 
85  ~Sql_cmd_create_or_drop_index_base() override = 0; // force abstract class
86 
87  bool execute(THD *thd) override;
88 };
89 
91  default;
92 
94  public:
95  using Sql_cmd_create_or_drop_index_base::Sql_cmd_create_or_drop_index_base;
96 
98  return SQLCOM_CREATE_INDEX;
99  }
100 };
101 
103  public:
104  using Sql_cmd_create_or_drop_index_base::Sql_cmd_create_or_drop_index_base;
105 
107  return SQLCOM_DROP_INDEX;
108  }
109 };
110 
112  public:
113  Sql_cmd_cache_index(Alter_info *alter_info, const LEX_CSTRING &key_cache_name)
114  : Sql_cmd_ddl_table(alter_info), m_key_cache_name(key_cache_name) {}
115 
118  }
119 
120  bool execute(THD *thd) override;
121 
122  private:
123  bool assign_to_keycache(THD *thd, TABLE_LIST *tables);
124 
125  private:
127 };
128 
129 class Sql_cmd_load_index final : public Sql_cmd_ddl_table {
130  public:
132 
134  return SQLCOM_PRELOAD_KEYS;
135  }
136 
137  bool execute(THD *thd) override;
138 
139  private:
140  bool preload_keys(THD *thd, TABLE_LIST *tables);
141 };
142 
143 #endif /* SQL_CMD_CREATE_TABLE_INCLUDED */
Data describing the table being created by CREATE TABLE or altered by ALTER TABLE.
Definition: sql_alter.h:204
Definition: sql_cmd_ddl_table.h:111
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:116
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:543
Sql_cmd_cache_index(Alter_info *alter_info, const LEX_CSTRING &key_cache_name)
Definition: sql_cmd_ddl_table.h:113
const LEX_CSTRING m_key_cache_name
Definition: sql_cmd_ddl_table.h:126
bool assign_to_keycache(THD *thd, TABLE_LIST *tables)
Definition: sql_admin.cc:1398
Definition: sql_cmd_ddl_table.h:93
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:97
Definition: sql_cmd_ddl_table.h:81
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:497
~Sql_cmd_create_or_drop_index_base() override=0
Definition: sql_cmd_ddl_table.h:61
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:68
const MYSQL_LEX_CSTRING * eligible_secondary_storage_engine() const override
Is this statement of a type and on a form that makes it eligible for execution in a secondary storage...
Definition: sql_cmd_ddl_table.cc:459
bool prepare(THD *thd) override
Validate and prepare for execution CREATE TABLE statement.
Definition: sql_prepare.cc:1123
TABLE_LIST * query_expression_tables
Definition: sql_cmd_ddl_table.h:78
Sql_cmd_create_table(Alter_info *alter_info, TABLE_LIST *query_expression_tables)
Definition: sql_cmd_ddl_table.h:63
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:128
A base class for CREATE/ALTER TABLE commands and friends.
Definition: sql_cmd_ddl_table.h:49
~Sql_cmd_ddl_table() override=0
Alter_info *const m_alter_info
Definition: sql_cmd_ddl_table.h:56
Sql_cmd_ddl_table(Alter_info *alter_info)
Definition: sql_cmd_ddl_table.cc:67
Definition: sql_cmd_ddl_table.h:102
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:106
Definition: sql_cmd_ddl_table.h:129
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:551
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:133
bool preload_keys(THD *thd, TABLE_LIST *tables)
Definition: sql_admin.cc:1435
Representation of an SQL command.
Definition: sql_cmd.h:64
For each client connection we create a separate thread with THD serving as a thread/connection descri...
Definition: sql_class.h:821
enum_sql_command
Definition: my_sqlcommand.h:45
@ SQLCOM_ASSIGN_TO_KEYCACHE
Definition: my_sqlcommand.h:93
@ SQLCOM_CREATE_INDEX
Definition: my_sqlcommand.h:48
@ SQLCOM_PRELOAD_KEYS
Definition: my_sqlcommand.h:94
@ SQLCOM_CREATE_TABLE
Definition: my_sqlcommand.h:47
@ SQLCOM_DROP_INDEX
Definition: my_sqlcommand.h:56
Definition: mysql_lex_string.h:39
Definition: table.h:2694