Alter_info Class Reference

Data describing the table being created by CREATE TABLE or altered by ALTER TABLE. More...

#include <sql_alter.h>

Public Types
enum	Alter_info_flag : ulonglong {   ALTER_ADD_COLUMN = 1ULL << 0 , ALTER_DROP_COLUMN = 1ULL << 1 , ALTER_CHANGE_COLUMN = 1ULL << 2 , ALTER_ADD_INDEX = 1ULL << 3 ,   ALTER_DROP_INDEX = 1ULL << 4 , ALTER_RENAME = 1ULL << 5 , ALTER_ORDER = 1ULL << 6 , ALTER_OPTIONS = 1ULL << 7 ,   ALTER_CHANGE_COLUMN_DEFAULT = 1ULL << 8 , ALTER_KEYS_ONOFF = 1ULL << 9 , ALTER_RECREATE = 1ULL << 10 , ALTER_ADD_PARTITION = 1ULL << 11 ,   ALTER_DROP_PARTITION = 1ULL << 12 , ALTER_COALESCE_PARTITION = 1ULL << 13 , ALTER_REORGANIZE_PARTITION = 1ULL << 14 , ALTER_PARTITION = 1ULL << 15 ,   ALTER_ADMIN_PARTITION = 1ULL << 16 , ALTER_TABLE_REORG = 1ULL << 17 , ALTER_REBUILD_PARTITION = 1ULL << 18 , ALTER_ALL_PARTITION = 1ULL << 19 ,   ALTER_REMOVE_PARTITIONING = 1ULL << 20 , ADD_FOREIGN_KEY = 1ULL << 21 , DROP_FOREIGN_KEY = 1ULL << 22 , ALTER_EXCHANGE_PARTITION = 1ULL << 23 ,   ALTER_TRUNCATE_PARTITION = 1ULL << 24 , ALTER_COLUMN_ORDER = 1ULL << 25 , ALTER_RENAME_INDEX = 1ULL << 26 , ALTER_DISCARD_TABLESPACE = 1ULL << 27 ,   ALTER_IMPORT_TABLESPACE = 1ULL << 28 , ALTER_INDEX_VISIBILITY = 1ULL << 29 , ALTER_SECONDARY_LOAD = 1ULL << 30 , ALTER_SECONDARY_UNLOAD = 1ULL << 31 ,   ADD_CHECK_CONSTRAINT = 1ULL << 32 , DROP_CHECK_CONSTRAINT = 1ULL << 33 , ENFORCE_CHECK_CONSTRAINT = 1ULL << 34 , SUSPEND_CHECK_CONSTRAINT = 1ULL << 35 ,   DROP_ANY_CONSTRAINT = 1ULL << 36 , ENFORCE_ANY_CONSTRAINT = 1ULL << 37 , SUSPEND_ANY_CONSTRAINT = 1ULL << 38 , ANY_ENGINE_ATTRIBUTE = 1ULL << 39 ,   ALTER_COLUMN_VISIBILITY = 1ULL << 40 }
enum	enum_enable_or_disable { LEAVE_AS_IS , ENABLE , DISABLE }
enum	enum_alter_table_algorithm { ALTER_TABLE_ALGORITHM_DEFAULT , ALTER_TABLE_ALGORITHM_INPLACE , ALTER_TABLE_ALGORITHM_INSTANT , ALTER_TABLE_ALGORITHM_COPY }
	The different values of the ALGORITHM clause. More...
enum	enum_alter_table_lock { ALTER_TABLE_LOCK_DEFAULT , ALTER_TABLE_LOCK_NONE , ALTER_TABLE_LOCK_SHARED , ALTER_TABLE_LOCK_EXCLUSIVE }
	The different values of the LOCK clause. More...
enum	enum_with_validation { ALTER_VALIDATION_DEFAULT , ALTER_WITH_VALIDATION , ALTER_WITHOUT_VALIDATION }
	Status of validation clause in ALTER TABLE statement. More...

Public Member Functions
	Alter_info (MEM_ROOT *mem_root)
	Alter_info (const Alter_info &rhs, MEM_ROOT *mem_root)
	Construct a copy of this object to be used for mysql_alter_table and mysql_create_table. More...
bool	add_field (THD *thd, const LEX_STRING *field_name, enum enum_field_types type, const char *length, const char *decimal, uint type_modifier, Item *default_value, Item *on_update_value, LEX_CSTRING *comment, const char *change, List< String > *interval_list, const CHARSET_INFO *cs, bool has_explicit_collation, uint uint_geom_type, Value_generator *gcol_info, Value_generator *default_val_expr, const char *opt_after, std::optional< gis::srid_t > srid, Sql_check_constraint_spec_list *check_cons_list, dd::Column::enum_hidden_type hidden, bool is_array=false)
	Store field definition for create. More...

Public Attributes
Mem_root_array< const Alter_drop * >	drop_list
	Columns, keys and constraints to be dropped. More...
Mem_root_array< const Alter_column * >	alter_list
Mem_root_array< Key_spec * >	key_list
Mem_root_array< const Alter_rename_key * >	alter_rename_key_list
Mem_root_array< const Alter_index_visibility * >	alter_index_visibility_list
	Indexes whose visibilities are to be changed. More...
Mem_root_array< const Alter_constraint_enforcement * >	alter_constraint_enforcement_list
	List of check constraints whose enforcement state is changed. More...
Sql_check_constraint_spec_list	check_constraint_spec_list
	Check constraints specification for CREATE and ALTER TABLE operations. More...
List< Create_field >	create_list
std::vector< CreateFieldApplier >	cf_appliers
ulonglong	flags
enum_enable_or_disable	keys_onoff
List< String >	partition_names
uint	num_parts
enum_alter_table_algorithm	requested_algorithm
enum_alter_table_lock	requested_lock
enum_with_validation	with_validation
LEX_CSTRING	new_db_name
	"new_db" (if any) or "db" (if any) or default database from ALTER TABLE [db. More...
LEX_CSTRING	new_table_name
	New table name in the. More...

Private Member Functions
Alter_info &	operator= (const Alter_info &rhs)
	Alter_info (const Alter_info &rhs)

Detailed Description

Data describing the table being created by CREATE TABLE or altered by ALTER TABLE.

Member Enumeration Documentation

Alter_info_flag

enum Alter_info::Alter_info_flag : ulonglong

Enumerator
ALTER_ADD_COLUMN	Set for ADD [COLUMN].
ALTER_DROP_COLUMN	Set for DROP [COLUMN].
ALTER_CHANGE_COLUMN	Set for CHANGE [COLUMN] | MODIFY [CHANGE] Set by mysql_recreate_table()
ALTER_ADD_INDEX	Set for ADD INDEX | ADD KEY | ADD PRIMARY KEY | ADD UNIQUE KEY | ADD UNIQUE INDEX | ALTER ADD [COLUMN].
ALTER_DROP_INDEX	Set for DROP PRIMARY KEY | DROP FOREIGN KEY | DROP KEY | DROP INDEX.
ALTER_RENAME	Set for RENAME [TO].
ALTER_ORDER	Set for ORDER BY.
ALTER_OPTIONS	Set for table_options.
ALTER_CHANGE_COLUMN_DEFAULT	Set for ALTER [COLUMN] ... SET DEFAULT ... | DROP DEFAULT.
ALTER_KEYS_ONOFF	Set for DISABLE KEYS | ENABLE KEYS.
ALTER_RECREATE	Set for FORCE Set for ENGINE(same engine) Set by mysql_recreate_table()
ALTER_ADD_PARTITION	Set for ADD PARTITION.
ALTER_DROP_PARTITION	Set for DROP PARTITION.
ALTER_COALESCE_PARTITION	Set for COALESCE PARTITION.
ALTER_REORGANIZE_PARTITION	Set for REORGANIZE PARTITION ... INTO.
ALTER_PARTITION	Set for partition_options.
ALTER_ADMIN_PARTITION	Set for LOAD INDEX INTO CACHE ... PARTITION Set for CACHE INDEX ... PARTITION.
ALTER_TABLE_REORG	Set for REORGANIZE PARTITION.
ALTER_REBUILD_PARTITION	Set for REBUILD PARTITION.
ALTER_ALL_PARTITION	Set for partitioning operations specifying ALL keyword.
ALTER_REMOVE_PARTITIONING	Set for REMOVE PARTITIONING.
ADD_FOREIGN_KEY	Set for ADD FOREIGN KEY.
DROP_FOREIGN_KEY	Set for DROP FOREIGN KEY.
ALTER_EXCHANGE_PARTITION	Set for EXCHANGE PARTITION.
ALTER_TRUNCATE_PARTITION	Set by Sql_cmd_alter_table_truncate_partition::execute()
ALTER_COLUMN_ORDER	Set for ADD [COLUMN] FIRST | AFTER.
ALTER_RENAME_INDEX	Set for RENAME INDEX.
ALTER_DISCARD_TABLESPACE	Set for discarding the tablespace.
ALTER_IMPORT_TABLESPACE	Set for importing the tablespace.
ALTER_INDEX_VISIBILITY	Means that the visibility of an index is changed.
ALTER_SECONDARY_LOAD	Set for SECONDARY LOAD.
ALTER_SECONDARY_UNLOAD	Set for SECONDARY UNLOAD.
ADD_CHECK_CONSTRAINT	Set for add check constraint.
DROP_CHECK_CONSTRAINT	Set for drop check constraint.
ENFORCE_CHECK_CONSTRAINT	Set for check constraint enforce.
SUSPEND_CHECK_CONSTRAINT	Set for check constraint suspend.
DROP_ANY_CONSTRAINT	Set for DROP CONSTRAINT.
ENFORCE_ANY_CONSTRAINT	Set for ALTER CONSTRAINT symbol ENFORCED.
SUSPEND_ANY_CONSTRAINT	Set for ALTER CONSTRAINT symbol NOT ENFORCED.
ANY_ENGINE_ATTRIBUTE	Set if ANY engine attribute is used (also in CREATE) Note that this is NOT to be set for SECONDARY_ENGINE_ATTRIBUTE as this flag controls if execution should check if SE supports engine attributes.
ALTER_COLUMN_VISIBILITY	Set for column visibility attribute alter.

enum_alter_table_algorithm

enum Alter_info::enum_alter_table_algorithm

The different values of the ALGORITHM clause.

Describes which algorithm to use when altering the table.

Enumerator
ALTER_TABLE_ALGORITHM_DEFAULT
ALTER_TABLE_ALGORITHM_INPLACE
ALTER_TABLE_ALGORITHM_INSTANT
ALTER_TABLE_ALGORITHM_COPY

enum_alter_table_lock

enum Alter_info::enum_alter_table_lock

The different values of the LOCK clause.

Describes the level of concurrency during ALTER TABLE.

Enumerator
ALTER_TABLE_LOCK_DEFAULT
ALTER_TABLE_LOCK_NONE
ALTER_TABLE_LOCK_SHARED
ALTER_TABLE_LOCK_EXCLUSIVE

enum_enable_or_disable

enum Alter_info::enum_enable_or_disable

Enumerator
LEAVE_AS_IS
ENABLE
DISABLE

enum_with_validation

enum Alter_info::enum_with_validation

Status of validation clause in ALTER TABLE statement.

Used during partitions and GC alterations.

Enumerator
ALTER_VALIDATION_DEFAULT	Default value, used when it's not specified in the statement. Means WITH VALIDATION for partitions alterations and WITHOUT VALIDATION for altering virtual GC.
ALTER_WITH_VALIDATION
ALTER_WITHOUT_VALIDATION

Constructor & Destructor Documentation

Alter_info() [1/3]

Alter_info::Alter_info ( MEM_ROOT *  mem_root )

inlineexplicit

Alter_info() [2/3]

Alter_info::Alter_info	(	const Alter_info &	rhs,
		MEM_ROOT *	mem_root
	)

Construct a copy of this object to be used for mysql_alter_table and mysql_create_table.

Historically, these two functions modify their Alter_info arguments. This behaviour breaks re-execution of prepared statements and stored procedures and is compensated by always supplying a copy of Alter_info to these functions.

Parameters

rhs	Alter_info to make copy of
mem_root	Mem_root for new Alter_info

Note

You need to use check the error in THD for out of memory condition after calling this function.

Alter_info() [3/3]

Alter_info::Alter_info ( const Alter_info &  rhs )

private

Member Function Documentation

operator=()

Alter_info & Alter_info::operator= ( const Alter_info &  rhs )

private

Member Data Documentation

alter_constraint_enforcement_list

Mem_root_array<const Alter_constraint_enforcement *> Alter_info::alter_constraint_enforcement_list

List of check constraints whose enforcement state is changed.

alter_index_visibility_list

Mem_root_array<const Alter_index_visibility *> Alter_info::alter_index_visibility_list

Indexes whose visibilities are to be changed.

alter_list

Mem_root_array<const Alter_column *> Alter_info::alter_list

alter_rename_key_list

Mem_root_array<const Alter_rename_key *> Alter_info::alter_rename_key_list

cf_appliers

std::vector<CreateFieldApplier> Alter_info::cf_appliers

check_constraint_spec_list

Sql_check_constraint_spec_list Alter_info::check_constraint_spec_list

Check constraints specification for CREATE and ALTER TABLE operations.

create_list

List<Create_field> Alter_info::create_list

drop_list

Mem_root_array<const Alter_drop *> Alter_info::drop_list

Columns, keys and constraints to be dropped.

flags

ulonglong Alter_info::flags

key_list

Mem_root_array<Key_spec *> Alter_info::key_list

keys_onoff

enum_enable_or_disable Alter_info::keys_onoff

new_db_name

LEX_CSTRING Alter_info::new_db_name

"new_db" (if any) or "db" (if any) or default database from ALTER TABLE [db.

]table [ RENAME [TO|AS|=] [new_db.]new_table ]

new_table_name

LEX_CSTRING Alter_info::new_table_name

New table name in the.

RENAME [TO] <table_name>

clause or NULL_STR

num_parts

uint Alter_info::num_parts

partition_names

List<String> Alter_info::partition_names

requested_algorithm

enum_alter_table_algorithm Alter_info::requested_algorithm

requested_lock

enum_alter_table_lock Alter_info::requested_lock

with_validation

enum_with_validation Alter_info::with_validation

---

The documentation for this class was generated from the following files:

• sql/sql_alter.h
• sql/sql_alter.cc
• sql/sql_parse.cc