MySQL 8.3.0
Source Code Documentation
sp_instr_set_trigger_field Class Reference

sp_instr_set_trigger_field represents SET-statements, which deal with NEW/OLD trigger pseudo-rows. More...

#include <sp_instr.h>

Inheritance diagram for sp_instr_set_trigger_field:
[legend]

Public Member Functions

 sp_instr_set_trigger_field (uint ip, LEX *lex, LEX_CSTRING trigger_field_name, Item_trigger_field *trigger_field, Item *value_item, LEX_CSTRING value_query)
 
void print (const THD *thd, String *str) override
 
bool exec_core (THD *thd, uint *nextp) override
 Execute core function of instruction after all preparations (e.g. More...
 
bool is_invalid () const override
 
void invalidate () override
 Invalidate the object. More...
 
bool on_after_expr_parsing (THD *thd) override
 Callback function which is called after the statement query string is successfully parsed, and the thread context has not been switched to the outer context. More...
 
void cleanup_before_parsing (THD *thd) override
 Destroy items in the free list before re-parsing the statement query string (and thus, creating new items). More...
 
LEX_CSTRING get_expr_query () const override
 
PSI_statement_infoget_psi_info () override
 
- Public Member Functions inherited from sp_lex_instr
 sp_lex_instr (uint ip, sp_pcontext *ctx, LEX *lex, bool is_lex_owner)
 
 ~sp_lex_instr () override
 
bool validate_lex_and_execute_core (THD *thd, uint *nextp, bool open_tables)
 Make a few attempts to execute the instruction. More...
 
SQL_I_List< Item_trigger_field > * get_instr_trig_field_list () override
 
bool execute (THD *thd, uint *nextp) override
 Execute this instruction. More...
 
- Public Member Functions inherited from sp_instr
 sp_instr (uint ip, sp_pcontext *ctx)
 
 ~sp_instr () override
 
uint get_ip () const
 
virtual uint get_cont_dest () const
 Get the continuation destination (instruction pointer for the CONTINUE HANDLER) of this instruction. More...
 
sp_pcontextget_parsing_ctx () const
 
virtual uint opt_mark (sp_head *, List< sp_instr > *leads)
 Mark this instruction as reachable during optimization and return the index to the next instruction. More...
 
virtual uint opt_shortcut_jump (sp_head *, sp_instr *start)
 Short-cut jumps to jumps during optimization. More...
 
virtual void opt_move (uint dst, List< sp_branch_instr > *ibp)
 Inform the instruction that it has been moved during optimization. More...
 
bool opt_is_marked () const
 
- Public Member Functions inherited from sp_printable
virtual ~sp_printable ()=default
 

Static Public Attributes

static PSI_statement_info psi_info
 

Private Attributes

LEX_CSTRING m_trigger_field_name
 Trigger field name ("field_name" of the "NEW.field_name"). More...
 
Item_trigger_fieldm_trigger_field
 Item corresponding to the NEW/OLD trigger field. More...
 
Itemm_value_item
 Value expression item of the SET-statement. More...
 
LEX_CSTRING m_value_query
 SQL-query corresponding to the value expression. More...
 

Additional Inherited Members

- Public Attributes inherited from sp_instr
Query_arena m_arena
 
- Protected Member Functions inherited from sp_lex_instr
virtual void get_query (String *sql_query) const
 Return the query string, which can be passed to the parser. More...
 
virtual void adjust_sql_command (LEX *)
 Some expressions may be re-parsed as SELECT statements, but need to be adjusted to another SQL command. More...
 
- Protected Member Functions inherited from sp_instr
void clear_da (THD *thd) const
 Clear diagnostics area. More...
 
- Protected Attributes inherited from sp_lex_instr
LEXm_lex
 LEX-object. More...
 
- Protected Attributes inherited from sp_instr
bool m_marked
 Show if this instruction is reachable within the SP (used by SP-optimizer). More...
 
uint m_ip
 Instruction pointer. More...
 
sp_pcontextm_parsing_ctx
 Instruction parsing context. More...
 

Detailed Description

sp_instr_set_trigger_field represents SET-statements, which deal with NEW/OLD trigger pseudo-rows.

Constructor & Destructor Documentation

◆ sp_instr_set_trigger_field()

sp_instr_set_trigger_field::sp_instr_set_trigger_field ( uint  ip,
LEX lex,
LEX_CSTRING  trigger_field_name,
Item_trigger_field trigger_field,
Item value_item,
LEX_CSTRING  value_query 
)
inline

Member Function Documentation

◆ cleanup_before_parsing()

void sp_instr_set_trigger_field::cleanup_before_parsing ( THD thd)
overridevirtual

Destroy items in the free list before re-parsing the statement query string (and thus, creating new items).

Parameters
thdThread context.

Reimplemented from sp_lex_instr.

◆ exec_core()

bool sp_instr_set_trigger_field::exec_core ( THD thd,
uint *  nextp 
)
overridevirtual

Execute core function of instruction after all preparations (e.g.

setting of proper LEX, saving part of the thread context).

Parameters
thdThread context.
[out]nextpnext instruction pointer
Returns
Error flag.

Implements sp_lex_instr.

◆ get_expr_query()

LEX_CSTRING sp_instr_set_trigger_field::get_expr_query ( ) const
inlineoverridevirtual
Returns
the expression query string. This string can not be passed directly to the parser as it is most likely not a valid SQL-statement.
Note
as it can be seen in the get_query() implementation, get_expr_query() might return EMPTY_CSTR. EMPTY_CSTR means that no query-expression is available. That happens when class provides different implementation of get_query(). Strictly speaking, this is a drawback of the current class hierarchy.

Reimplemented from sp_lex_instr.

◆ get_psi_info()

PSI_statement_info * sp_instr_set_trigger_field::get_psi_info ( )
inlineoverridevirtual

Implements sp_instr.

◆ invalidate()

void sp_instr_set_trigger_field::invalidate ( )
inlineoverridevirtual

Invalidate the object.

Implements sp_lex_instr.

◆ is_invalid()

bool sp_instr_set_trigger_field::is_invalid ( ) const
inlineoverridevirtual
Return values
falseif the object (i.e. LEX-object) is valid and exec_core() can be just called.
trueif the object is not valid any longer, exec_core() can not be called. The original query string should be re-parsed and a new LEX-object should be used.

Implements sp_lex_instr.

◆ on_after_expr_parsing()

bool sp_instr_set_trigger_field::on_after_expr_parsing ( THD thd)
overridevirtual

Callback function which is called after the statement query string is successfully parsed, and the thread context has not been switched to the outer context.

The thread context contains new LEX-object corresponding to the parsed query string.

Parameters
thdThread context.
Returns
Error flag.

Reimplemented from sp_lex_instr.

◆ print()

void sp_instr_set_trigger_field::print ( const THD thd,
String str 
)
overridevirtual

Implements sp_printable.

Member Data Documentation

◆ m_trigger_field

Item_trigger_field* sp_instr_set_trigger_field::m_trigger_field
private

Item corresponding to the NEW/OLD trigger field.

◆ m_trigger_field_name

LEX_CSTRING sp_instr_set_trigger_field::m_trigger_field_name
private

Trigger field name ("field_name" of the "NEW.field_name").

◆ m_value_item

Item* sp_instr_set_trigger_field::m_value_item
private

Value expression item of the SET-statement.

◆ m_value_query

LEX_CSTRING sp_instr_set_trigger_field::m_value_query
private

SQL-query corresponding to the value expression.

◆ psi_info

PSI_statement_info sp_instr_set_trigger_field::psi_info
static
Initial value:
= {
0, "set_trigger_field", PSI_FLAG_DISABLED | PSI_FLAG_UNTIMED,
"Stored Program: SET NEW.<field> in TRIGGER"}
#define PSI_FLAG_DISABLED
Instrument is disabled by default.
Definition: psi_bits.h:145
#define PSI_FLAG_UNTIMED
Instrument is not timed by default.
Definition: psi_bits.h:150

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