MySQL 8.4.0
Source Code Documentation
sql_table.h
Go to the documentation of this file.
1/* Copyright (c) 2006, 2024, 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 designed to work 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 either included with
13 the program or referenced in the documentation.
14
15 This program is distributed in the hope that it will be useful,
16 but WITHOUT ANY WARRANTY; without even the implied warranty of
17 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 GNU General Public License, version 2.0, for more details.
19
20 You should have received a copy of the GNU General Public License
21 along with this program; if not, write to the Free Software
22 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
23
24#ifndef SQL_TABLE_INCLUDED
25#define SQL_TABLE_INCLUDED
26
27#include <stddef.h>
28#include <sys/types.h>
29
30#include <map>
31#include <set>
32#include <string>
33#include <utility>
34#include <vector>
35
36#include "my_inttypes.h"
37#include "my_sharedlib.h"
39#include "mysqld_error.h"
40#include "sql/dd/string_type.h"
41#include "sql/handler.h"
42#include "sql/mdl.h"
43
44class Alter_info;
45class Alter_table_ctx;
46class Create_field;
47class FOREIGN_KEY;
48class KEY;
49class THD;
50class handler;
51struct CHARSET_INFO;
52struct MEM_ROOT;
53struct TABLE;
54class Table_ref;
55struct handlerton;
56
57namespace dd {
58class Foreign_key;
59class Schema;
60class Table;
61} // namespace dd
62
63struct HA_CHECK_OPT;
64struct HA_CREATE_INFO;
65
67template <typename T>
68class List;
69
74};
75
76/* Flags for conversion functions. */
77static const uint FN_FROM_IS_TMP = 1 << 0;
78static const uint FN_TO_IS_TMP = 1 << 1;
80/** Don't check foreign key constraints while renaming table */
81static const uint NO_FK_CHECKS = 1 << 2;
82/**
83 Don't commit transaction after updating data-dictionary while renaming
84 the table.
85*/
86static const uint NO_DD_COMMIT = 1 << 3;
87/** Don't change generated foreign key names while renaming table. */
88static const uint NO_FK_RENAME = 1 << 4;
89/** Don't change generated check constraint names while renaming table. */
90static const uint NO_CC_RENAME = 1 << 5;
91
93 const HA_CREATE_INFO &ci);
94
95size_t filename_to_tablename(const char *from, char *to, size_t to_length,
96 bool stay_quiet = false,
97 bool *has_errors = nullptr);
98size_t tablename_to_filename(const char *from, char *to, size_t to_length);
99size_t build_table_filename(char *buff, size_t bufflen, const char *db,
100 const char *table, const char *ext, uint flags,
101 bool *was_truncated);
102// For caller's who are mostly sure that path do not truncate
103size_t inline build_table_filename(char *buff, size_t bufflen, const char *db,
104 const char *table, const char *ext,
105 uint flags) {
106 bool truncated_not_used;
107 return build_table_filename(buff, bufflen, db, table, ext, flags,
108 &truncated_not_used);
109}
110size_t build_tmptable_filename(THD *thd, char *buff, size_t bufflen);
112 HA_CREATE_INFO *create_info, Alter_info *alter_info);
113bool mysql_create_table_no_lock(THD *thd, const char *db,
114 const char *table_name,
115 HA_CREATE_INFO *create_info,
116 Alter_info *alter_info, uint select_field_count,
117 bool find_parent_keys, bool *is_trans,
118 handlerton **post_ddl_ht);
120
121/**
122 Helper class for keeping track for which tables we need to invalidate
123 data-dictionary cache entries and performing such invalidation.
124*/
126 private:
127 typedef std::map<std::pair<dd::String_type, dd::String_type>, handlerton *>
130
131 public:
132 void add(const char *db_name, const char *table_name, handlerton *hton);
133 void invalidate(THD *thd);
134 const Parent_map &parents() const { return m_parent_map; }
135 bool is_empty() const { return m_parent_map.empty(); }
136 void clear() { m_parent_map.clear(); }
137};
138
139/**
140 Auxiliary class implementing RAII principle for getting permission for/
141 notification about finished DDL statements from interested storage engines.
142
143 @see handlerton::ha_notify_table_ddl for details.
144*/
146 public:
148 THD *thd, const MDL_key *key, ha_ddl_type ddl_type,
149 const char *old_db_name = nullptr, const char *old_table_name = nullptr,
150 const char *new_db_name = nullptr,
151 const char *new_table_name = nullptr) noexcept
152 : m_hton_notified(false),
153 m_thd(thd),
154 m_key(*key),
155 m_ddl_type(ddl_type),
156 m_old_db_name(old_db_name),
157 m_old_table_name(old_table_name),
158 m_new_db_name(new_db_name),
159 m_new_table_name(new_table_name) {}
160
161 [[nodiscard]] bool notify() noexcept {
165 m_hton_notified = true;
166 return false;
167 }
168 my_error(ER_LOCK_REFUSED_BY_ENGINE, MYF(0));
169 return true;
170 }
171
173 if (m_hton_notified)
177 }
178
179 private:
184 const char *m_old_db_name;
185 const char *m_old_table_name;
186 const char *m_new_db_name;
187 const char *m_new_table_name;
188};
189
190/*
191 Reload the foreign key parent information of the referenced
192 tables and for the table itself.
193
194 @param thd Thread handle.
195 @param db Table schema name.
196 @param name Table name.
197 @param reload_self Reload FK parent info also for the
198 table itself.
199 @param fk_invalidator Object keeping track of which dd::Table
200 objects to invalidate. If submitted, use this
201 to restrict which FK parents should have their
202 FK parent information reloaded.
203
204 @retval operation outcome, false if no error.
205*/
206bool adjust_fk_parents(THD *thd, const char *db, const char *name,
207 bool reload_self,
208 const Foreign_key_parents_invalidator *fk_invalidator);
209
210/**
211 Check if new definition of parent table is compatible with foreign keys
212 which reference it. Update the unique constraint names and referenced
213 column names for the foreign keys accordingly.
214
215 @param thd Thread handle.
216 @param check_charsets Indicates whether we need to check charsets of
217 columns participating in foreign keys.
218 @param parent_table_db Parent table schema name.
219 @param parent_table_name Parent table name.
220 @param hton Handlerton for table's storage engine.
221 @param parent_table_def Table object representing the referenced table.
222 @param parent_alter_info Alter_info containing information about renames
223 of parent columns. Can be nullptr if there are
224 no such renames.
225 @param invalidate_tdc Indicates whether we need to invalidate TDC for
226 referencing tables after updating their
227 definitions.
228
229 @retval operation outcome, false if no error.
230*/
232 THD *thd, bool check_charsets, const char *parent_table_db,
233 const char *parent_table_name, handlerton *hton,
234 const dd::Table *parent_table_def, Alter_info *parent_alter_info,
235 bool invalidate_tdc);
236
237/**
238 Check if new definition of parent table is compatible with foreign keys
239 which reference it. Update the unique constraint names and referenced
240 column names for the foreign keys accordingly. Do mandatory character
241 set checks and TDC invalidation.
242*/
244 THD *thd, const char *parent_table_db, const char *parent_table_name,
245 handlerton *hton, const dd::Table *parent_table_def,
246 Alter_info *parent_alter_info) {
248 thd, true, parent_table_db, parent_table_name, hton, parent_table_def,
249 parent_alter_info, true);
250}
251
252/**
253 Add MDL requests for specified lock type on all tables referencing the given
254 schema qualified table name to the list.
255
256 @param thd Thread handle.
257 @param schema Schema name.
258 @param table_name Table name.
259 @param hton Handlerton for table's storage engine.
260 @param lock_type Type of MDL requests to add.
261 @param[in,out] mdl_requests List to which MDL requests are to be added.
262
263 @retval operation outcome, false if no error.
264*/
265[[nodiscard]] bool collect_fk_children(THD *thd, const char *schema,
266 const char *table_name, handlerton *hton,
267 enum_mdl_type lock_type,
268 MDL_request_list *mdl_requests);
269
270/**
271 Add MDL requests for lock of specified type on tables referenced by the
272 foreign keys to be added by the CREATE TABLE or ALTER TABLE operation.
273 Also add the referenced table names to the foreign key invalidator,
274 to be used at a later stage to invalidate the dd::Table objects.
275
276 @param thd Thread handle.
277 @param db_name Table's database name.
278 @param table_name Table name.
279 @param alter_info Alter_info object with the list of FKs
280 to be added.
281 @param lock_type Type of metadata lock to be requested.
282 @param hton Handlerton for table's storage engine.
283 @param[in,out] mdl_requests List to which MDL requests are to be added.
284 @param[in,out] fk_invalidator Object keeping track of which dd::Table
285 objects to invalidate.
286
287 @retval operation outcome, false if no error.
288*/
289[[nodiscard]] bool collect_fk_parents_for_new_fks(
290 THD *thd, const char *db_name, const char *table_name,
291 const Alter_info *alter_info, enum_mdl_type lock_type, handlerton *hton,
292 MDL_request_list *mdl_requests,
293 Foreign_key_parents_invalidator *fk_invalidator);
294
295/**
296 Add MDL requests for exclusive metadata locks on names of foreign keys
297 to be added by the CREATE TABLE or ALTER TABLE operation.
298
299 @param thd Thread context.
300 @param db_name Table's database name.
301 @param table_name Table name.
302 @param alter_info Alter_info object with the
303 list of FKs to be added.
304 @param hton Table's storage engine.
305 @param fk_max_generated_name_number Max value of number component
306 among existing generated foreign
307 key names.
308 @param[in,out] mdl_requests List to which MDL requests
309 are to be added.
310
311 @retval operation outcome, false if no error.
312*/
313bool collect_fk_names_for_new_fks(THD *thd, const char *db_name,
314 const char *table_name,
315 const Alter_info *alter_info,
316 handlerton *hton,
317 uint fk_max_generated_name_number,
318 MDL_request_list *mdl_requests);
319
320/**
321 Acquire exclusive metadata locks on tables which definitions need to
322 be updated or invalidated since they are related through foreign keys
323 to the table to be renamed,
324 Also add the referenced table names for the FKs on this table to the
325 foreign key invalidator, to be used at a later stage to invalidate the
326 dd::Table objects.
327
328 @param thd Thread handle.
329 @param db Table's old schema.
330 @param table_name Table's old name.
331 @param table_def Table definition of table being RENAMEd.
332 @param new_db Table's new schema.
333 @param new_table_name Table's new name.
334 @param hton Table's SE.
335 @param[in,out] fk_invalidator Object keeping track of which dd::Table
336 objects to invalidate.
337
338 @retval operation outcome, false if no error.
339*/
341 THD *thd, const char *db, const char *table_name,
342 const dd::Table *table_def, const char *new_db, const char *new_table_name,
343 handlerton *hton, Foreign_key_parents_invalidator *fk_invalidator);
344
345/**
346 As a result of simple rename table operation, orphan non-self-referencing
347 foreign keys may become non-orphan/adopted self-referencing foreign keys.
348 For such transformed foreign key, check that table has compatible referenced
349 column and parent key. Also, update DD.UNIQUE_CONSTRAINT_NAME.
350
351 @param thd Thread handle.
352 @param db Table's old schema.
353 @param table_name Table's old name.
354 @param new_db Table's new schema.
355 @param new_table_name Table's new name.
356 @param hton Table's SE.
357
358 @retval operation outcome, false if no error.
359*/
361 THD *thd, const char *db, const char *table_name, const char *new_db,
362 const char *new_table_name, handlerton *hton);
363
364/**
365 Update referenced table names and the unique constraint name for FKs
366 affected by RENAME TABLE operation.
367
368 @param thd Thread handle.
369 @param db Table's old schema.
370 @param table_name Table's old name.
371 @param new_db Table's new schema.
372 @param new_table_name Table's new name.
373 @param hton Table's SE.
374
375 @retval operation outcome, false if no error.
376*/
377[[nodiscard]] bool adjust_fks_for_rename_table(THD *thd, const char *db,
378 const char *table_name,
379 const char *new_db,
380 const char *new_table_name,
381 handlerton *hton);
382
383/*
384 Check if parent key for the foreign key exists, set foreign key's unique
385 constraint name accordingly. Emit error if no parent key found.
386
387 @note Prefer unique key if possible. If parent key is non-unique
388 unique constraint name is set to NULL.
389
390 @note DDL code use this function for non-self-referencing foreign keys.
391
392 @sa prepare_fk_parent_key(THD, handlerton, FOREIGN_KEY)
393
394 @param thd Thread handle.
395 @param hton Handlerton for tables' storage engine.
396 @param parent_table_def Object describing new version of parent table.
397 @param old_child_table_def Object describing old version of child table.
398 Can be nullptr if old_parent_table_def is
399 nullptr. Used for error reporting.
400 @param old_parent_table_def Object describing old version of parent table.
401 nullptr indicates that this is not ALTER TABLE
402 operation. Used for error reporting.
403 @param is_self_referencing_fk If the parent and child is the same table.
404 @param fk[in,out] Object describing the foreign key,
405 its unique_constraint_name member
406 will be updated if matching parent
407 unique constraint is found.
408
409 @retval Operation result. False if success.
410*/
411[[nodiscard]] bool prepare_fk_parent_key(THD *thd, handlerton *hton,
412 const dd::Table *parent_table_def,
413 const dd::Table *old_parent_table_def,
414 const dd::Table *old_child_table_def,
415 bool is_self_referencing_fk,
416 dd::Foreign_key *fk);
417
418/**
419 Prepare Create_field and Key_spec objects for ALTER and upgrade.
420 @param[in,out] thd thread handle. Used as a memory pool
421 and source of environment information.
422 @param[in] src_table DD table object. Will be nullptr for temporary
423 tables and during upgrade.
424 @param[in] table the source table, open and locked
425 Used as an interface to the storage engine
426 to acquire additional information about
427 the original table.
428 @param[in,out] create_info A blob with CREATE/ALTER TABLE
429 parameters
430 @param[in,out] alter_info Another blob with ALTER/CREATE parameters.
431 Originally create_info was used only in
432 CREATE TABLE and alter_info only in ALTER TABLE.
433 But since ALTER might end-up doing CREATE,
434 this distinction is gone and we just carry
435 around two structures.
436 @param[in,out] alter_ctx Runtime context for ALTER TABLE.
437 @param[in] used_fields used_fields from HA_CREATE_INFO.
438
439 @retval true error, out of memory or a semantical error in ALTER
440 TABLE instructions
441 @retval false success
442
443*/
444bool prepare_fields_and_keys(THD *thd, const dd::Table *src_table, TABLE *table,
445 HA_CREATE_INFO *create_info,
446 Alter_info *alter_info, Alter_table_ctx *alter_ctx,
447 const uint &used_fields);
448
449bool mysql_prepare_alter_table(THD *thd, const dd::Table *src_table,
450 TABLE *table, HA_CREATE_INFO *create_info,
451 Alter_info *alter_info,
452 Alter_table_ctx *alter_ctx);
455bool mysql_alter_table(THD *thd, const char *new_db, const char *new_name,
456 HA_CREATE_INFO *create_info, Table_ref *table_list,
457 Alter_info *alter_info);
458bool mysql_compare_tables(THD *thd, TABLE *table, Alter_info *alter_info,
459 HA_CREATE_INFO *create_info, bool *metadata_equal);
460bool mysql_recreate_table(THD *thd, Table_ref *table_list, bool table_copy);
461bool mysql_create_like_table(THD *thd, Table_ref *table, Table_ref *src_table,
462 HA_CREATE_INFO *create_info);
463bool mysql_rename_table(THD *thd, handlerton *base, const char *old_db,
464 const char *old_name, const char *old_fk_db,
465 const char *old_fk_name, const dd::Schema &new_schema,
466 const char *new_db, const char *new_name, uint flags);
467
468bool mysql_checksum_table(THD *thd, Table_ref *table_list,
469 HA_CHECK_OPT *check_opt);
470bool mysql_rm_table(THD *thd, Table_ref *tables, bool if_exists,
471 bool drop_temporary);
472bool mysql_rm_table_no_locks(THD *thd, Table_ref *tables, bool if_exists,
473 bool drop_temporary, bool drop_database,
474 bool *dropped_non_atomic_flag,
475 std::set<handlerton *> *post_ddl_htons,
476 Foreign_key_parents_invalidator *fk_invalidator,
477 std::vector<MDL_ticket *> *safe_to_release_mdl);
478
479/**
480 Discover missing tables in SE and acquire locks on tables which participate
481 in FKs on tables to be dropped by DROP TABLES/DATABASE and which definitions
482 will have to be updated or invalidated during this operation.
483
484 @param thd Thread context.
485 @param tables Tables to be dropped by DROP TABLES/DATABASE.
486
487 @retval False - Success.
488 @retval True - Failure.
489*/
490[[nodiscard]] bool rm_table_do_discovery_and_lock_fk_tables(THD *thd,
491 Table_ref *tables);
492
493bool quick_rm_table(THD *thd, handlerton *base, const char *db,
494 const char *table_name, uint flags);
495bool prepare_sp_create_field(THD *thd, Create_field *field_def);
496bool prepare_pack_create_field(THD *thd, Create_field *sql_field,
497 longlong table_flags);
498
499const CHARSET_INFO *get_sql_field_charset(const Create_field *sql_field,
500 const HA_CREATE_INFO *create_info);
501bool validate_comment_length(THD *thd, const char *comment_str,
502 size_t *comment_len, uint max_len, uint err_code,
503 const char *comment_name);
504int write_bin_log(THD *thd, bool clear_error, const char *query,
505 size_t query_length, bool is_trans = false);
506void promote_first_timestamp_column(List<Create_field> *column_definitions);
507
508/**
509 Prepares the column definitions for table creation.
510
511 @param thd Thread object.
512 @param error_schema_name Schema name of the table used for error
513 reporting.
514 @param error_table_name Table name used for error reporting.
515 @param create_info Create information.
516 @param[in,out] create_list List of columns to create.
517 @param[in,out] select_field_pos Position where the SELECT columns start
518 for CREATE TABLE ... SELECT.
519 @param file The handler for the new table.
520 @param[in,out] sql_field Create_field to populate.
521 @param field_no Column number.
522
523 @retval false OK
524 @retval true error
525*/
526
527bool prepare_create_field(THD *thd, const char *error_schema_name,
528 const char *error_table_name,
529 HA_CREATE_INFO *create_info,
530 List<Create_field> *create_list,
531 int *select_field_pos, handler *file,
532 Create_field *sql_field, int field_no);
533
534/**
535 Prepares the table and key structures for table creation.
536
537 @param thd Thread object.
538 @param error_schema_name Schema name of the table to create/alter,
539 only error reporting.
540 @param error_table_name Name of table to create/alter, only used for
541 error reporting.
542 @param create_info Create information (like MAX_ROWS).
543 @param alter_info List of columns and indexes to create
544 @param file The handler for the new table.
545 @param is_partitioned Indicates whether table is partitioned.
546 @param[out] key_info_buffer An array of KEY structs for the indexes.
547 @param[out] key_count The number of elements in the array.
548 @param[out] fk_key_info_buffer An array of FOREIGN_KEY structs for the
549 foreign keys.
550 @param[out] fk_key_count The number of elements in the array.
551 @param[in] existing_fks An array of pre-existing FOREIGN KEYS
552 (in case of ALTER).
553 @param[in] existing_fks_count The number of pre-existing foreign keys.
554 @param[in] existing_fks_table dd::Table object for table version from
555 which pre-existing foreign keys come from.
556 Needed for error reporting.
557 @param[in] fk_max_generated_name_number Max value of number component among
558 existing generated foreign key names.
559 @param select_field_count The number of fields coming from a select
560 table.
561 @param find_parent_keys Indicates whether we need to lookup name of
562 unique constraint in parent table for foreign
563 keys.
564
565 @retval false OK
566 @retval true error
567*/
568
570 THD *thd, const char *error_schema_name, const char *error_table_name,
571 HA_CREATE_INFO *create_info, Alter_info *alter_info, handler *file,
572 bool is_partitioned, KEY **key_info_buffer, uint *key_count,
573 FOREIGN_KEY **fk_key_info_buffer, uint *fk_key_count,
574 FOREIGN_KEY *existing_fks, uint existing_fks_count,
575 const dd::Table *existing_fks_table, uint fk_max_generated_name_number,
576 int select_field_count, bool find_parent_keys);
577
578size_t explain_filename(THD *thd, const char *from, char *to, size_t to_length,
579 enum_explain_filename_mode explain_mode);
580
581extern MYSQL_PLUGIN_IMPORT const char *primary_key_name;
582
583/**
584 Acquire metadata lock on triggers associated with a list of tables.
585
586 @param[in] thd Current thread context
587 @param[in] tables Tables for that associated triggers have to locked.
588
589 @return Operation status.
590 @retval false Success
591 @retval true Failure
592*/
593
594bool lock_trigger_names(THD *thd, Table_ref *tables);
595struct TYPELIB;
597
598/**
599 Method to collect check constraint names for the all the tables and acquire
600 MDL lock on them.
601
602 @param[in] thd Thread handle.
603 @param[in] tables Check constraints of tables to be locked.
604
605 @retval false Success.
606 @retval true Failure.
607*/
608bool lock_check_constraint_names(THD *thd, Table_ref *tables);
609
610/**
611 Method to lock check constraint names for rename table operation.
612 Method acquire locks on the constraint names of source table and
613 also on the name of check constraint in the target table.
614
615 @param[in] thd Thread handle.
616 @param[in] db Database name.
617 @param[in] table_name Table name.
618 @param[in] table_def DD table object of source table.
619 @param[in] target_db Target database name.
620 @param[in] target_table_name Target table name.
621
622 @retval false Success.
623 @retval true Failure.
624*/
625bool lock_check_constraint_names_for_rename(THD *thd, const char *db,
626 const char *table_name,
627 const dd::Table *table_def,
628 const char *target_db,
629 const char *target_table_name);
630
631/**
632 Method to prepare check constraints for the CREATE operation. If name of the
633 check constraint is not specified then name is generated, check constraint
634 is pre-validated and MDL on check constraint is acquired.
635
636 @param thd Thread handle.
637 @param db_name Database name.
638 @param table_name Table name.
639 @param alter_info Alter_info object with list of
640 check constraints to be created.
641
642 @retval false Success.
643 @retval true Failure.
644*/
646 const char *table_name,
647 Alter_info *alter_info);
648
649extern std::atomic_ulong deprecated_use_fk_on_non_standard_key_count;
651
652#endif /* SQL_TABLE_INCLUDED */
Data describing the table being created by CREATE TABLE or altered by ALTER TABLE.
Definition: sql_alter.h:205
Runtime context for ALTER TABLE.
Definition: sql_alter.h:509
Create_field is a description a field/column that may or may not exists in a table.
Definition: create_field.h:51
Definition: key.h:43
Helper class for keeping track for which tables we need to invalidate data-dictionary cache entries a...
Definition: sql_table.h:125
void invalidate(THD *thd)
Definition: sql_table.cc:1521
const Parent_map & parents() const
Definition: sql_table.h:134
std::map< std::pair< dd::String_type, dd::String_type >, handlerton * > Parent_map
Definition: sql_table.h:128
void clear()
Definition: sql_table.h:136
Parent_map m_parent_map
Definition: sql_table.h:129
void add(const char *db_name, const char *table_name, handlerton *hton)
Definition: sql_table.cc:1514
bool is_empty() const
Definition: sql_table.h:135
Intrusive parameterized list.
Definition: sql_plist.h:75
Definition: key.h:113
Definition: sql_list.h:467
For each client connection we create a separate thread with THD serving as a thread/connection descri...
Definition: sql_lexer_thd.h:36
Auxiliary class implementing RAII principle for getting permission for/ notification about finished D...
Definition: sql_table.h:145
bool m_hton_notified
Definition: sql_table.h:180
const MDL_key m_key
Definition: sql_table.h:182
THD * m_thd
Definition: sql_table.h:181
bool notify() noexcept
Definition: sql_table.h:161
const char * m_old_db_name
Definition: sql_table.h:184
const char * m_new_table_name
Definition: sql_table.h:187
const ha_ddl_type m_ddl_type
Definition: sql_table.h:183
const char * m_old_table_name
Definition: sql_table.h:185
const char * m_new_db_name
Definition: sql_table.h:186
Table_ddl_hton_notification_guard(THD *thd, const MDL_key *key, ha_ddl_type ddl_type, const char *old_db_name=nullptr, const char *old_table_name=nullptr, const char *new_db_name=nullptr, const char *new_table_name=nullptr) noexcept
Definition: sql_table.h:147
~Table_ddl_hton_notification_guard()
Definition: sql_table.h:172
Definition: table.h:2863
Definition: foreign_key.h:47
Definition: schema.h:63
Definition: table.h:47
The handler class is the interface for dynamically loadable storage engines.
Definition: handler.h:4572
A table definition from the master.
Definition: rpl_utility.h:248
static MEM_ROOT mem_root
Definition: client_plugin.cc:114
void my_error(int nr, myf MyFlags,...)
Fill in and print a previously registered error message.
Definition: my_error.cc:216
PFS_table * create_table(PFS_table_share *share, PFS_thread *opening_thread, const void *identity)
Create instrumentation for a table instance.
Definition: pfs_instr.cc:1308
static int flags[50]
Definition: hp_test1.cc:40
Some integer typedefs for easier portability.
long long int longlong
Definition: my_inttypes.h:55
#define MYF(v)
Definition: my_inttypes.h:97
Functions related to handling of plugins and other dynamically loaded libraries.
#define MYSQL_PLUGIN_IMPORT
Definition: my_sharedlib.h:71
static char * query
Definition: myisam_ftdump.cc:47
ABI for instrumented mutexes.
static PFS_engine_table_share_proxy table
Definition: pfs.cc:61
borrowable::session_track::Schema< true > Schema
Definition: classic_protocol_session_track.h:288
The version of the current data dictionary table definitions.
Definition: dictionary_client.h:43
Definition: os0file.h:89
Json_data_extension ext
Definition: backend.cc:52
const char * table_name
Definition: rules_table_service.cc:56
const char * db_name
Definition: rules_table_service.cc:55
required string key
Definition: replication_asynchronous_connection_failover.proto:60
bool ha_notify_table_ddl(THD *thd, const MDL_key *mdl_key, ha_notification_type notification_type, ha_ddl_type ddl_type, const char *old_db_name, const char *old_table_name, const char *new_db_name, const char *new_table_name)
Notify/get permission from all interested storage engines before or after executed DDL (ALTER TABLE,...
Definition: handler.cc:8764
ha_ddl_type
Definition: handler.h:940
@ HA_NOTIFY_POST_EVENT
Definition: handler.h:939
@ HA_NOTIFY_PRE_EVENT
Definition: handler.h:939
enum_mdl_type
Type of metadata lock request.
Definition: sql_lexer_yacc_state.h:106
static const uint NO_DD_COMMIT
Don't commit transaction after updating data-dictionary while renaming the table.
Definition: sql_table.h:86
bool collect_fk_parents_for_new_fks(THD *thd, const char *db_name, const char *table_name, const Alter_info *alter_info, enum_mdl_type lock_type, handlerton *hton, MDL_request_list *mdl_requests, Foreign_key_parents_invalidator *fk_invalidator)
Add MDL requests for lock of specified type on tables referenced by the foreign keys to be added by t...
Definition: sql_table.cc:10099
bool lock_check_constraint_names_for_rename(THD *thd, const char *db, const char *table_name, const dd::Table *table_def, const char *target_db, const char *target_table_name)
Method to lock check constraint names for rename table operation.
Definition: sql_table.cc:19923
static const uint FN_TO_IS_TMP
Definition: sql_table.h:78
int write_bin_log(THD *thd, bool clear_error, const char *query, size_t query_length, bool is_trans=false)
Definition: sql_table.cc:1257
size_t tablename_to_filename(const char *from, char *to, size_t to_length)
Definition: sql_table.cc:837
void promote_first_timestamp_column(List< Create_field > *column_definitions)
Modifies the first column definition whose SQL type is TIMESTAMP by adding the features DEFAULT CURRE...
Definition: sql_table.cc:4253
bool adjust_fk_parents(THD *thd, const char *db, const char *name, bool reload_self, const Foreign_key_parents_invalidator *fk_invalidator)
Definition: sql_table.cc:9552
bool lock_trigger_names(THD *thd, Table_ref *tables)
Acquire metadata lock on triggers associated with a list of tables.
Definition: sql_table.cc:1272
bool lock_check_constraint_names(THD *thd, Table_ref *tables)
Method to collect check constraint names for the all the tables and acquire MDL lock on them.
Definition: sql_table.cc:19983
bool quick_rm_table(THD *thd, handlerton *base, const char *db, const char *table_name, uint flags)
Quickly remove a table.
Definition: sql_table.cc:3899
bool rm_table_do_discovery_and_lock_fk_tables(THD *thd, Table_ref *tables)
Discover missing tables in SE and acquire locks on tables which participate in FKs on tables to be dr...
Definition: sql_table.cc:1442
bool mysql_prepare_create_table(THD *thd, const char *error_schema_name, const char *error_table_name, HA_CREATE_INFO *create_info, Alter_info *alter_info, handler *file, bool is_partitioned, KEY **key_info_buffer, uint *key_count, FOREIGN_KEY **fk_key_info_buffer, uint *fk_key_count, FOREIGN_KEY *existing_fks, uint existing_fks_count, const dd::Table *existing_fks_table, uint fk_max_generated_name_number, int select_field_count, bool find_parent_keys)
Prepares the table and key structures for table creation.
Definition: sql_table.cc:8135
bool collect_fk_names_for_new_fks(THD *thd, const char *db_name, const char *table_name, const Alter_info *alter_info, handlerton *hton, uint fk_max_generated_name_number, MDL_request_list *mdl_requests)
Add MDL requests for exclusive metadata locks on names of foreign keys to be added by the CREATE TABL...
Definition: sql_table.cc:10136
bool adjust_adopted_self_ref_fk_for_simple_rename_table(THD *thd, const char *db, const char *table_name, const char *new_db, const char *new_table_name, handlerton *hton)
As a result of simple rename table operation, orphan non-self-referencing foreign keys may become non...
Definition: sql_table.cc:15829
std::atomic_ullong deprecated_use_fk_on_non_standard_key_last_timestamp
Last time fk is created on non standard index key, as usec since epoch.
Definition: sql_table.cc:216
handlerton * get_viable_handlerton_for_create(THD *thd, const char *table_name, const HA_CREATE_INFO &ci)
Checks if the handlerton for the specified ENGINE is enabled AND NOT explicitly disabled (listed in t...
Definition: sql_table.cc:430
const CHARSET_INFO * get_sql_field_charset(const Create_field *sql_field, const HA_CREATE_INFO *create_info)
Get the character set from field object generated by the parser, using default values when not set.
Definition: sql_table.cc:4220
mysql_mutex_t mysql_mutex_t
Definition: sql_table.h:64
bool mysql_compare_tables(THD *thd, TABLE *table, Alter_info *alter_info, HA_CREATE_INFO *create_info, bool *metadata_equal)
Compare two tables to see if their metadata are compatible.
Definition: sql_table.cc:12803
bool mysql_prepare_alter_table(THD *thd, const dd::Table *src_table, TABLE *table, HA_CREATE_INFO *create_info, Alter_info *alter_info, Alter_table_ctx *alter_ctx)
Prepare column and key definitions for CREATE TABLE in ALTER TABLE.
Definition: sql_table.cc:15439
bool prepare_sp_create_field(THD *thd, Create_field *field_def)
Prepare an instance of Create_field for field creation (fill all necessary attributes).
Definition: sql_table.cc:4199
bool mysql_rename_table(THD *thd, handlerton *base, const char *old_db, const char *old_name, const char *old_fk_db, const char *old_fk_name, const dd::Schema &new_schema, const char *new_db, const char *new_name, uint flags)
Rename a table.
Definition: sql_table.cc:10772
bool collect_fk_children(THD *thd, const char *schema, const char *table_name, handlerton *hton, enum_mdl_type lock_type, MDL_request_list *mdl_requests)
Add MDL requests for specified lock type on all tables referencing the given schema qualified table n...
Definition: sql_table.cc:9484
bool prepare_fk_parent_key(THD *thd, handlerton *hton, const dd::Table *parent_table_def, const dd::Table *old_parent_table_def, const dd::Table *old_child_table_def, bool is_self_referencing_fk, dd::Foreign_key *fk)
Definition: sql_table.cc:6574
bool prepare_fields_and_keys(THD *thd, const dd::Table *src_table, TABLE *table, HA_CREATE_INFO *create_info, Alter_info *alter_info, Alter_table_ctx *alter_ctx, const uint &used_fields)
Prepare Create_field and Key_spec objects for ALTER and upgrade.
Definition: sql_table.cc:14772
MYSQL_PLUGIN_IMPORT const char * primary_key_name
Definition: sql_table.cc:226
size_t filename_to_tablename(const char *from, char *to, size_t to_length, bool stay_quiet=false, bool *has_errors=nullptr)
Definition: sql_table.cc:792
bool prepare_pack_create_field(THD *thd, Create_field *sql_field, longlong table_flags)
Prepare a create_table instance for packing.
Definition: sql_table.cc:4048
static const uint NO_CC_RENAME
Don't change generated check constraint names while renaming table.
Definition: sql_table.h:90
static const uint FN_FROM_IS_TMP
Definition: sql_table.h:77
bool mysql_rm_table(THD *thd, Table_ref *tables, bool if_exists, bool drop_temporary)
Definition: sql_table.cc:1585
size_t build_tmptable_filename(THD *thd, char *buff, size_t bufflen)
Create path to a temporary table, like mysql_tmpdir/#sql1234_12_1 (i.e.
Definition: sql_table.cc:944
static const uint FN_IS_TMP
Definition: sql_table.h:79
static const uint NO_FK_RENAME
Don't change generated foreign key names while renaming table.
Definition: sql_table.h:88
size_t explain_filename(THD *thd, const char *from, char *to, size_t to_length, enum_explain_filename_mode explain_mode)
Explain a path name by split it to database, table etc.
Definition: sql_table.cc:637
bool mysql_create_table_no_lock(THD *thd, const char *db, const char *table_name, HA_CREATE_INFO *create_info, Alter_info *alter_info, uint select_field_count, bool find_parent_keys, bool *is_trans, handlerton **post_ddl_ht)
Simple wrapper around create_table_impl() to be used in various version of CREATE TABLE statement.
Definition: sql_table.cc:9309
bool mysql_create_table(THD *thd, Table_ref *create_table, HA_CREATE_INFO *create_info, Alter_info *alter_info)
Implementation of SQLCOM_CREATE_TABLE.
Definition: sql_table.cc:10214
bool collect_and_lock_fk_tables_for_rename_table(THD *thd, const char *db, const char *table_name, const dd::Table *table_def, const char *new_db, const char *new_table_name, handlerton *hton, Foreign_key_parents_invalidator *fk_invalidator)
Acquire exclusive metadata locks on tables which definitions need to be updated or invalidated since ...
Definition: sql_table.cc:15805
std::atomic_ulong deprecated_use_fk_on_non_standard_key_count
Count number of times foreign key is created on non standard index keys.
Definition: sql_table.cc:213
bool mysql_alter_table(THD *thd, const char *new_db, const char *new_name, HA_CREATE_INFO *create_info, Table_ref *table_list, Alter_info *alter_info)
Alter table.
Definition: sql_table.cc:16424
size_t build_table_filename(char *buff, size_t bufflen, const char *db, const char *table, const char *ext, uint flags, bool *was_truncated)
Definition: sql_table.cc:886
bool mysql_recreate_table(THD *thd, Table_ref *table_list, bool table_copy)
Definition: sql_table.cc:18894
bool mysql_create_like_table(THD *thd, Table_ref *table, Table_ref *src_table, HA_CREATE_INFO *create_info)
Definition: sql_table.cc:11015
bool prepare_create_field(THD *thd, const char *error_schema_name, const char *error_table_name, HA_CREATE_INFO *create_info, List< Create_field > *create_list, int *select_field_pos, handler *file, Create_field *sql_field, int field_no)
Prepares the column definitions for table creation.
Definition: sql_table.cc:4575
bool mysql_trans_prepare_alter_copy_data(THD *thd)
Prepare the transaction for the alter table's copy phase.
Definition: sql_table.cc:18536
static const uint NO_FK_CHECKS
Don't check foreign key constraints while renaming table.
Definition: sql_table.h:81
bool adjust_fks_for_rename_table(THD *thd, const char *db, const char *table_name, const char *new_db, const char *new_table_name, handlerton *hton)
Update referenced table names and the unique constraint name for FKs affected by RENAME TABLE operati...
Definition: sql_table.cc:15868
enum_explain_filename_mode
Definition: sql_table.h:70
@ EXPLAIN_PARTITIONS_VERBOSE
Definition: sql_table.h:72
@ EXPLAIN_ALL_VERBOSE
Definition: sql_table.h:71
@ EXPLAIN_PARTITIONS_AS_COMMENT
Definition: sql_table.h:73
TYPELIB * create_typelib(MEM_ROOT *mem_root, Create_field *field_def)
Definition: sql_table.cc:4138
bool adjust_fk_children_after_parent_def_change(THD *thd, bool check_charsets, const char *parent_table_db, const char *parent_table_name, handlerton *hton, const dd::Table *parent_table_def, Alter_info *parent_alter_info, bool invalidate_tdc)
Check if new definition of parent table is compatible with foreign keys which reference it.
Definition: sql_table.cc:9852
bool validate_comment_length(THD *thd, const char *comment_str, size_t *comment_len, uint max_len, uint err_code, const char *comment_name)
check comment length of table, column, index and partition
Definition: sql_table.cc:8581
bool prepare_check_constraints_for_create(THD *thd, const char *db_name, const char *table_name, Alter_info *alter_info)
Method to prepare check constraints for the CREATE operation.
Definition: sql_table.cc:19207
bool mysql_trans_commit_alter_copy_data(THD *thd)
Commit the copy phase of the alter table.
Definition: sql_table.cc:18556
bool mysql_checksum_table(THD *thd, Table_ref *table_list, HA_CHECK_OPT *check_opt)
Definition: sql_table.cc:18920
bool mysql_rm_table_no_locks(THD *thd, Table_ref *tables, bool if_exists, bool drop_temporary, bool drop_database, bool *dropped_non_atomic_flag, std::set< handlerton * > *post_ddl_htons, Foreign_key_parents_invalidator *fk_invalidator, std::vector< MDL_ticket * > *safe_to_release_mdl)
Execute the drop of a normal or temporary table.
Definition: sql_table.cc:3173
bool mysql_discard_or_import_tablespace(THD *thd, Table_ref *table_list)
case opt name
Definition: sslopt-case.h:29
Definition: m_ctype.h:423
Definition: handler.h:3790
Struct to hold information about the table that should be created.
Definition: handler.h:3201
Metadata lock object key.
Definition: mdl.h:365
The MEM_ROOT is a simple arena, where allocations are carved out of larger blocks.
Definition: my_alloc.h:83
Definition: table.h:1405
Definition: typelib.h:35
handlerton is a singleton structure - one instance per storage engine - to provide access to storage ...
Definition: handler.h:2733
An instrumented mutex structure.
Definition: mysql_mutex_bits.h:50