MySQL 9.0.0
Source Code Documentation
|
#include <sql_cmd_dml.h>
Public Member Functions | |
virtual bool | is_data_change_stmt () const |
bool | prepare (THD *thd) override |
Command-specific resolving (doesn't include LEX::prepare()) More... | |
bool | execute (THD *thd) override |
Execute a DML statement. More... | |
enum enum_sql_cmd_type | sql_cmd_type () const override |
virtual bool | may_use_cursor () const |
bool | is_single_table_plan () const override |
Query_result * | query_result () const |
void | set_query_result (Query_result *result) |
Set query result object for this query statement. More... | |
void | set_lazy_result () |
Signal that root result object needs preparing in next execution. More... | |
bool | are_dynamic_parameters_allowed () const final |
Signal that DML statement can have dynamic parameters. More... | |
Public Member Functions inherited from Sql_cmd | |
virtual enum_sql_command | sql_command_code () const =0 |
Return the command code for this statement. More... | |
bool | needs_explicit_preparation () const |
bool | is_regular () const |
bool | is_prepared () const |
virtual void | cleanup (THD *) |
Command-specific reinitialization before execution of prepared statement. More... | |
void | set_owner (Prepared_statement *stmt) |
Set the owning prepared statement. More... | |
Prepared_statement * | owner () const |
Get the owning prepared statement. More... | |
void | set_as_part_of_sp () |
Mark statement as part of procedure. More... | |
bool | is_part_of_sp () const |
virtual bool | accept (THD *, Select_lex_visitor *) |
virtual const MYSQL_LEX_CSTRING * | eligible_secondary_storage_engine (THD *) const |
Is this statement of a type and on a form that makes it eligible for execution in a secondary storage engine? More... | |
virtual bool | is_bulk_load () const |
void | disable_secondary_storage_engine () |
Disable use of secondary storage engines in this statement. More... | |
void | enable_secondary_storage_engine () |
bool | secondary_storage_engine_disabled () const |
Has use of secondary storage engines been disabled for this statement? More... | |
void | use_secondary_storage_engine (const handlerton *hton) |
Mark the current statement as using a secondary storage engine. More... | |
bool | using_secondary_storage_engine () const |
Is this statement using a secondary storage engine? More... | |
const handlerton * | secondary_engine () const |
Get the handlerton of the secondary engine that is used for executing this statement, or nullptr if a secondary engine is not used. More... | |
void | set_optional_transform_prepared (bool value) |
bool | is_optional_transform_prepared () |
Protected Member Functions | |
Sql_cmd_dml () | |
bool | is_empty_query () const |
void | set_empty_query () |
Set statement as returning no data. More... | |
virtual bool | precheck (THD *thd)=0 |
Perform a precheck of table privileges for the specific operation. More... | |
virtual bool | check_privileges (THD *thd)=0 |
Check privileges on a prepared statement, called at start of execution of the statement. More... | |
bool | check_all_table_privileges (THD *thd) |
Read and check privileges for all tables in a DML statement. More... | |
virtual bool | prepare_inner (THD *thd)=0 |
Perform the command-specific parts of DML command preparation, to be called from prepare() More... | |
virtual bool | execute_inner (THD *thd) |
The inner parts of query optimization and execution. More... | |
virtual bool | restore_cmd_properties (THD *thd) |
Restore command properties before execution. More... | |
virtual bool | save_cmd_properties (THD *thd) |
Save command properties, such as prepared query details and table props. More... | |
const MYSQL_LEX_CSTRING * | get_eligible_secondary_engine (THD *thd) const |
Helper function that checks if the command is eligible for secondary engine and if that's true returns the name of that eligible secondary storage engine. More... | |
Protected Member Functions inherited from Sql_cmd | |
Sql_cmd () | |
virtual | ~Sql_cmd () |
void | set_prepared () |
Set this statement as prepared. More... | |
Protected Attributes | |
LEX * | lex |
Pointer to LEX for this statement. More... | |
Query_result * | result |
Pointer to object for handling of the result. More... | |
bool | m_empty_query |
True if query will produce no rows. More... | |
bool | m_lazy_result |
True: prepare query result on next execution. More... | |
|
inlineprotected |
|
inlinefinalvirtual |
Signal that DML statement can have dynamic parameters.
Reimplemented from Sql_cmd.
|
protectedpure virtual |
Check privileges on a prepared statement, called at start of execution of the statement.
Check that user has all relevant privileges to the statement, ie. INSERT privilege for columns inserted into, UPDATE privilege for columns that are updated, DELETE privilege for tables that are deleted from, SELECT privilege for columns that are referenced, etc.
thd | thread handler |
Implemented in Sql_cmd_show, Sql_cmd_call, Sql_cmd_delete, Sql_cmd_insert_base, Sql_cmd_select, Sql_cmd_show_schema_base, Sql_cmd_show_table_base, Sql_cmd_show_routine_code, Sql_cmd_show_binlog_events, Sql_cmd_show_binlogs, Sql_cmd_show_create_database, Sql_cmd_show_create_event, Sql_cmd_show_create_function, Sql_cmd_show_create_procedure, Sql_cmd_show_create_table, Sql_cmd_show_create_trigger, Sql_cmd_show_create_user, Sql_cmd_show_databases, Sql_cmd_show_engine_logs, Sql_cmd_show_engine_mutex, Sql_cmd_show_engine_status, Sql_cmd_show_events, Sql_cmd_show_grants, Sql_cmd_show_binary_log_status, Sql_cmd_show_processlist, Sql_cmd_show_relaylog_events, Sql_cmd_show_replicas, Sql_cmd_show_replica_status, and Sql_cmd_update.
|
inlinevirtual |
Reimplemented in Sql_cmd_call, and Sql_cmd_select.
|
inlineprotected |
|
inlineoverridevirtual |
Reimplemented from Sql_cmd.
Reimplemented in Sql_cmd_delete, Sql_cmd_insert_values, and Sql_cmd_update.
|
inlinevirtual |
Reimplemented in Sql_cmd_select.
|
protectedpure virtual |
Perform a precheck of table privileges for the specific operation.
Check that user has some relevant privileges for all tables involved in the statement, e.g. SELECT privileges for tables selected from, INSERT privileges for tables inserted into, etc. This function will also populate Table_ref::grant with all privileges the user has for each table, which is later used during checking of column privileges. Note that at preparation time, views are not expanded yet. Privilege checking is thus rudimentary and must be complemented with later calls to Query_block::check_view_privileges(). The reason to call this function at such an early stage is to be able to quickly reject statements for which the user obviously has insufficient privileges. This function is called before preparing the statement. The function must also be complemented with proper privilege checks for all involved columns (e.g. check_column_grant_*).
thd | thread handler |
Implemented in Sql_cmd_call, Sql_cmd_delete, Sql_cmd_insert_base, Sql_cmd_select, Sql_cmd_show, and Sql_cmd_update.
|
protectedpure virtual |
Perform the command-specific parts of DML command preparation, to be called from prepare()
thd | the current thread |
Implemented in Sql_cmd_call, Sql_cmd_delete, Sql_cmd_insert_base, Sql_cmd_select, and Sql_cmd_update.
|
inlineprotected |
Set statement as returning no data.
|
inline |
Signal that root result object needs preparing in next execution.
|
inlineoverridevirtual |
Reimplemented from Sql_cmd.
|
protected |
Pointer to LEX for this statement.
|
protected |
True if query will produce no rows.
|
protected |
True: prepare query result on next execution.
|
protected |
Pointer to object for handling of the result.