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:

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_info *	get_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_pcontext *	get_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_field *	m_trigger_field
	Item corresponding to the NEW/OLD trigger field. More...

Item *	m_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
LEX *	m_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_pcontext *	m_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

thd	Thread 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

	thd	Thread context.
[out]	nextp	next 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

false	if the object (i.e. LEX-object) is valid and exec_core() can be just called.
true	if 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

thd	Thread 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"}

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

sql/sp_instr.h
sql/sp_instr.cc

Public Member Functions

Static Public Attributes

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ sp_instr_set_trigger_field()

Member Function Documentation

◆ cleanup_before_parsing()

◆ exec_core()

◆ get_expr_query()

◆ get_psi_info()

◆ invalidate()

◆ is_invalid()

◆ on_after_expr_parsing()

◆ print()

Member Data Documentation

◆ m_trigger_field

◆ m_trigger_field_name

◆ m_value_item

◆ m_value_query

◆ psi_info