![]() |
MySQL 8.0.43
Source Code Documentation
|
This class has common code for CREATE/DROP TRIGGER statements. More...
#include <sql_trigger.h>
Public Member Functions | |
| void | set_table (Table_ref *trigger_table) |
| Set a table associated with a trigger. 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 bool | prepare (THD *) |
| Prepare this SQL statement. More... | |
| virtual bool | execute (THD *thd)=0 |
| Execute this SQL statement. More... | |
| virtual bool | reprepare_on_execute_required () const |
| Some SQL commands currently require re-preparation on re-execution of a prepared statement or stored procedure. More... | |
| 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 | is_dml () const |
| virtual bool | is_single_table_plan () const |
| virtual bool | accept (THD *, Select_lex_visitor *) |
| virtual const MYSQL_LEX_CSTRING * | eligible_secondary_storage_engine () const |
| Is this statement of a type and on a form that makes it eligible for execution in a secondary storage engine? More... | |
| void | disable_secondary_storage_engine () |
| Disable use of secondary storage engines in this statement. More... | |
| 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_ddl_trigger_common () | |
| bool | check_trg_priv_on_subj_table (THD *thd, Table_ref *table) const |
| Check that the user has TRIGGER privilege on the subject table. More... | |
| TABLE * | open_and_lock_subj_table (THD *thd, Table_ref *tables, MDL_ticket **mdl_ticket) const |
| Open and lock a table associated with a trigger. More... | |
| void | restore_original_mdl_state (THD *thd, MDL_ticket *mdl_ticket) const |
| Restore original state of meta-data locks. More... | |
Protected Member Functions inherited from Sql_cmd | |
| Sql_cmd () | |
| virtual | ~Sql_cmd () |
| void | set_prepared () |
| Set this statement as prepared. More... | |
Protected Attributes | |
| Table_ref * | m_trigger_table {nullptr} |
This class has common code for CREATE/DROP TRIGGER statements.
|
inlineprotected |
|
protected |
Check that the user has TRIGGER privilege on the subject table.
| thd | current thread context |
| table | table to check |
| false | Success |
| true | Failure |
|
protected |
Open and lock a table associated with a trigger.
| [in] | thd | current thread context |
| [in] | tables | trigger's table |
| [out] | mdl_ticket | granted metadata lock |
|
protected |
Restore original state of meta-data locks.
| thd | current thread context |
| mdl_ticket | granted metadata lock |
|
inline |
Set a table associated with a trigger.
| trigger_table | a table associated with a trigger. |