sp_instr_cpush Class Reference

#include <sp_instr.h>

Inheritance diagram for sp_instr_cpush:

Collaboration diagram for sp_instr_cpush:

Public Member Functions
	sp_instr_cpush (uint ip, sp_pcontext *ctx, LEX *cursor_lex, LEX_STRING cursor_query, int cursor_idx)
virtual void	print (String *str)
virtual void	cleanup_stmt ()
virtual bool	execute (THD *thd, uint *nextp)
virtual bool	exec_core (THD *thd, uint *nextp)
virtual bool	is_invalid () const
virtual void	invalidate ()
virtual void	get_query (String *sql_query) const
virtual bool	on_after_expr_parsing (THD *thd)
Public Member Functions inherited from sp_lex_instr
	sp_lex_instr (uint ip, sp_pcontext *ctx, LEX *lex, bool is_lex_owner)
bool	validate_lex_and_execute_core (THD *thd, uint *nextp, bool open_tables)
Public Member Functions inherited from sp_instr
	sp_instr (uint ip, sp_pcontext *ctx)
uint	get_ip () const
virtual uint	get_cont_dest () const
sp_pcontext *	get_parsing_ctx () const
virtual uint	opt_mark (sp_head *sp, List< sp_instr > *leads)
virtual uint	opt_shortcut_jump (sp_head *sp, sp_instr *start)
virtual void	opt_move (uint dst, List< sp_branch_instr > *ibp)
bool	opt_is_marked () const

Additional Inherited Members
Static Public Member Functions inherited from Sql_alloc
static void *	operator new (size_t size) throw ()
static void *	operator new[] (size_t size) throw ()
static void *	operator new[] (size_t size, MEM_ROOT *mem_root) throw ()
static void *	operator new (size_t size, MEM_ROOT *mem_root) throw ()
static void	operator delete (void *ptr, size_t size)
static void	operator delete (void *ptr, MEM_ROOT *mem_root)
static void	operator delete[] (void *ptr, MEM_ROOT *mem_root)
static void	operator delete[] (void *ptr, size_t size)
Protected Member Functions inherited from sp_lex_instr
virtual LEX_STRING	get_expr_query () const
virtual void	cleanup_before_parsing (THD *thd)
Protected Attributes inherited from sp_instr
bool	m_marked
uint	m_ip
	Instruction pointer.
sp_pcontext *	m_parsing_ctx
	Instruction parsing context.

Detailed Description

sp_instr_cpush corresponds to DECLARE CURSOR, implements DECLARE CURSOR and OPEN.

This is the most important instruction in cursor implementation. It is created and added to sp_head when DECLARE CURSOR is being parsed. The arena of this instruction contains LEX-object for the cursor's SELECT-statement.

This instruction is actually used to open the cursor.

execute() operation "implements" DECLARE CURSOR statement – it merely pushes a new cursor object into the stack in sp_rcontext object.

exec_core() operation implements OPEN statement. It is important to implement OPEN statement in this instruction, because OPEN may lead to re-parsing of the SELECT-statement. So, the original Arena and parsing context must be used.

Definition at line 1183 of file sp_instr.h.

Member Function Documentation

virtual void sp_instr_cpush::cleanup_stmt ( )

inlinevirtual

This call is used to cleanup the instruction when a sensitive cursor is closed. For now stored procedures always use materialized cursors and the call is not used.

Definition at line 1217 of file sp_instr.h.

bool sp_instr_cpush::exec_core ( THD *  thd, uint *  nextp  )

virtual

Execute core function of instruction after all preparations (e.g. setting of proper LEX, saving part of the thread context).

Parameters

thd	Thread context.
nextp[out]	next instruction pointer

Returns

Error flag.

Implements sp_lex_instr.

Definition at line 1452 of file sp_instr.cc.

Here is the call graph for this function:

bool sp_instr_cpush::execute ( THD *  thd, uint *  nextp  )

virtual

Execute this instruction

Parameters

	thd	Thread context
[out]	nextp	index of the next instruction to execute. (For most instructions this will be the instruction following this one). Note that this parameter is undefined in case of errors, use get_cont_dest() to find the continuation instruction for CONTINUE error handlers.

Returns

Error status.

Reimplemented from sp_lex_instr.

Definition at line 1442 of file sp_instr.cc.

virtual void sp_instr_cpush::get_query ( String *  sql_query ) const

inlinevirtual

Return the query string, which can be passed to the parser. I.e. the operation should return a valid SQL-statement query string.

Parameters

[out]

sql_query

SQL-statement query string.

Reimplemented from sp_lex_instr.

Definition at line 1238 of file sp_instr.h.

virtual void sp_instr_cpush::invalidate ( )

inlinevirtual

Invalidate the object.

Implements sp_lex_instr.

Definition at line 1235 of file sp_instr.h.

virtual bool sp_instr_cpush::is_invalid ( ) const

inlinevirtual

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.

Definition at line 1232 of file sp_instr.h.

virtual bool sp_instr_cpush::on_after_expr_parsing ( THD *  thd )

inlinevirtual

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.

Definition at line 1241 of file sp_instr.h.

---

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

• sql/sp_instr.h
• sql/sp_instr.cc