MySQL 8.3.0
Source Code Documentation
sql_cmd_ddl_table.h
Go to the documentation of this file.
1/* Copyright (c) 2016, 2023, 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
30class Alter_info;
31class THD;
32class Table_ref;
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*/
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
60
62 public:
65 : Sql_cmd_ddl_table(alter_info),
67
70 }
71
73 THD *thd) const override;
74
75 bool execute(THD *thd) override;
76 bool prepare(THD *thd) override;
77
78 private:
80};
81
83 public:
85
86 ~Sql_cmd_create_or_drop_index_base() override = 0; // force abstract class
87
88 bool execute(THD *thd) override;
89};
90
92 default;
93
95 public:
96 using Sql_cmd_create_or_drop_index_base::Sql_cmd_create_or_drop_index_base;
97
100 }
101};
102
103class Sql_cmd_drop_table final : public Sql_cmd_ddl {
104 public:
106 return SQLCOM_DROP_TABLE;
107 }
108
109 bool execute(THD *thd [[maybe_unused]]) override { return false; }
110};
111
113 public:
114 using Sql_cmd_create_or_drop_index_base::Sql_cmd_create_or_drop_index_base;
115
117 return SQLCOM_DROP_INDEX;
118 }
119};
120
122 public:
123 Sql_cmd_cache_index(Alter_info *alter_info, const LEX_CSTRING &key_cache_name)
124 : Sql_cmd_ddl_table(alter_info), m_key_cache_name(key_cache_name) {}
125
128 }
129
130 bool execute(THD *thd) override;
131
132 private:
133 bool assign_to_keycache(THD *thd, Table_ref *tables);
134
135 private:
137};
138
140 public:
142
144 return SQLCOM_PRELOAD_KEYS;
145 }
146
147 bool execute(THD *thd) override;
148
149 private:
150 bool preload_keys(THD *thd, Table_ref *tables);
151};
152
153#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:121
bool assign_to_keycache(THD *thd, Table_ref *tables)
Definition: sql_admin.cc:1575
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:126
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:573
Sql_cmd_cache_index(Alter_info *alter_info, const LEX_CSTRING &key_cache_name)
Definition: sql_cmd_ddl_table.h:123
const LEX_CSTRING m_key_cache_name
Definition: sql_cmd_ddl_table.h:136
Definition: sql_cmd_ddl_table.h:94
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:98
Definition: sql_cmd_ddl_table.h:82
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:527
~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
Table_ref * query_expression_tables
Definition: sql_cmd_ddl_table.h:79
const MYSQL_LEX_CSTRING * eligible_secondary_storage_engine(THD *thd) 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:489
bool prepare(THD *thd) override
Validate and prepare for execution CREATE TABLE statement.
Definition: sql_prepare.cc:1117
Sql_cmd_create_table(Alter_info *alter_info, Table_ref *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:133
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.h:28
Definition: sql_cmd_ddl_table.h:112
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:116
Definition: sql_cmd_ddl_table.h:103
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.h:109
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:105
Definition: sql_cmd_ddl_table.h:139
bool preload_keys(THD *thd, Table_ref *tables)
Definition: sql_admin.cc:1612
bool execute(THD *thd) override
Execute this SQL statement.
Definition: sql_cmd_ddl_table.cc:581
enum_sql_command sql_command_code() const override
Return the command code for this statement.
Definition: sql_cmd_ddl_table.h:143
For each client connection we create a separate thread with THD serving as a thread/connection descri...
Definition: sql_lexer_thd.h:35
Definition: table.h:2853
enum_sql_command
Definition: my_sqlcommand.h:45
@ SQLCOM_DROP_TABLE
Definition: my_sqlcommand.h:55
@ 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