sp_instr_set_case_expr is used in the "simple CASE" implementation to evaluate and store the CASE-expression in the runtime context. More...

#include <sp_instr.h>

Inheritance diagram for sp_instr_set_case_expr:

[legend]

Public Member Functions
	sp_instr_set_case_expr (uint ip, LEX lex, uint case_expr_id, Item case_expr_item, LEX_CSTRING case_expr_query)

void	print (const THD thd, String str) override

uint	opt_mark (sp_head sp, List< sp_instr > leads) override
	Mark this instruction as reachable during optimization and return the index to the next instruction. More...

void	opt_move (uint dst, List< sp_branch_instr > *ibp) override
	Inform the instruction that it has been moved during optimization. More...

void	set_destination (uint old_dest, uint new_dest) override
	Update the destination; used by the SP-instruction-optimizer. More...

void	backpatch (uint) override
	Update all instruction with the given label in the backpatch list to the specified instruction pointer. More...

bool	exec_core (THD thd, uint nextp) override
	Execute core function of instruction after all preparations (e.g. 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...

PSI_statement_info *	get_psi_info () override

Public Member Functions inherited from sp_lex_branch_instr
void	set_cont_dest (uint cont_dest)

uint	get_cont_dest () const override
	Get the continuation destination (instruction pointer for the CONTINUE HANDLER) of this instruction. More...

bool	is_invalid () const override

void	invalidate () override
	Invalidate the object. More...

LEX_CSTRING	get_expr_query () const override

void	adjust_sql_command (LEX *lex) override
	Some expressions may be re-parsed as SELECT statements, but need to be adjusted to another SQL command. More...

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

sp_pcontext *	get_parsing_ctx () const

virtual uint	opt_shortcut_jump (sp_head , sp_instr start)
	Short-cut jumps to jumps during optimization. More...

bool	opt_is_marked () const

Public Member Functions inherited from sp_printable
virtual	~sp_printable ()=default

Public Member Functions inherited from sp_branch_instr
virtual	~sp_branch_instr ()=default

Static Public Attributes
static PSI_statement_info	psi_info

Private Attributes
uint	m_case_expr_id
	Identifier (index) of the CASE-expression in the runtime context. More...

Additional Inherited Members
Public Attributes inherited from sp_instr
Query_arena	m_arena

Protected Member Functions inherited from sp_lex_branch_instr
	sp_lex_branch_instr (uint ip, sp_pcontext ctx, LEX lex, Item *expr_item, LEX_CSTRING expr_query)

	sp_lex_branch_instr (uint ip, sp_pcontext ctx, LEX lex, Item *expr_item, LEX_CSTRING expr_query, uint dest)

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	cleanup_before_parsing (THD *thd)
	Destroy items in the free list before re-parsing the statement query string (and thus, creating new items). More...

Protected Member Functions inherited from sp_instr
void	clear_da (THD *thd) const
	Clear diagnostics area. More...

Protected Attributes inherited from sp_lex_branch_instr
uint	m_dest
	Where we will go. More...

uint	m_cont_dest
	Where continue handlers will go. More...

sp_instr *	m_optdest

sp_instr *	m_cont_optdest

Item *	m_expr_item
	Expression item. More...

LEX_CSTRING	m_expr_query
	SQL-query corresponding to the expression. 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_case_expr is used in the "simple CASE" implementation to evaluate and store the CASE-expression in the runtime context.

Constructor & Destructor Documentation

◆ sp_instr_set_case_expr()

sp_instr_set_case_expr::sp_instr_set_case_expr	(	uint	ip,
		LEX *	lex,
		uint	case_expr_id,
		Item *	case_expr_item,
		LEX_CSTRING	case_expr_query
	)

inline

Member Function Documentation

◆ backpatch()

void sp_instr_set_case_expr::backpatch ( uint dest )

inlineoverridevirtual

Update all instruction with the given label in the backpatch list to the specified instruction pointer.

Parameters

dest	destination instruction pointer.

Reimplemented from sp_lex_branch_instr.

◆ exec_core()

bool sp_instr_set_case_expr::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_psi_info()

PSI_statement_info * sp_instr_set_case_expr::get_psi_info ( )

inlineoverridevirtual

Implements sp_instr.

◆ on_after_expr_parsing()

bool sp_instr_set_case_expr::on_after_expr_parsing ( THD * thd )

inlineoverridevirtual

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.

◆ opt_mark()

uint sp_instr_set_case_expr::opt_mark	(	sp_head *	,
		List< sp_instr > *	leads
	)

overridevirtual

Mark this instruction as reachable during optimization and return the index to the next instruction.

Jump instruction will add their destination to the leads list.

Reimplemented from sp_lex_branch_instr.

◆ opt_move()

void sp_instr_set_case_expr::opt_move	(	uint	dst,
		List< sp_branch_instr > *	ibp
	)

overridevirtual

Inform the instruction that it has been moved during optimization.

Most instructions will simply update its index, but jump instructions must also take care of their destination pointers. Forward jumps get pushed to the backpatch list 'ibp'.

Reimplemented from sp_lex_branch_instr.

◆ print()

void sp_instr_set_case_expr::print	(	const THD *	thd,
		String *	str
	)

overridevirtual

Implements sp_printable.

◆ set_destination()

void sp_instr_set_case_expr::set_destination	(	uint	old_dest,
		uint	new_dest
	)

inlineoverridevirtual

Update the destination; used by the SP-instruction-optimizer.

Parameters

old_dest	current (old) destination (instruction pointer).
new_dest	new destination (instruction pointer).

Reimplemented from sp_lex_branch_instr.

Member Data Documentation

◆ m_case_expr_id

uint sp_instr_set_case_expr::m_case_expr_id

private

Identifier (index) of the CASE-expression in the runtime context.

◆ psi_info

PSI_statement_info sp_instr_set_case_expr::psi_info

static

Initial value:

= {
    0, "set_case_expr", PSI_FLAG_DISABLED | PSI_FLAG_UNTIMED,
    "Stored Program: CASE microcode instruction"}

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_case_expr()

Member Function Documentation

◆ backpatch()

◆ exec_core()

◆ get_psi_info()

◆ on_after_expr_parsing()

◆ opt_mark()

◆ opt_move()

◆ print()

◆ set_destination()

Member Data Documentation

◆ m_case_expr_id

◆ psi_info