sp.cc File Reference

#include "sql/sp.h"
#include <string.h>
#include <algorithm>
#include <atomic>
#include <memory>
#include <new>
#include <utility>
#include <vector>
#include "lex_string.h"
#include "m_ctype.h"
#include "m_string.h"
#include "my_alloc.h"
#include "my_base.h"
#include "my_dbug.h"
#include "my_loglevel.h"
#include "my_psi_config.h"
#include "my_sqlcommand.h"
#include "my_sys.h"
#include "mysql/components/services/bits/psi_bits.h"
#include "mysql/components/services/bits/psi_statement_bits.h"
#include "mysql/components/services/log_builtins.h"
#include "mysql/components/services/log_shared.h"
#include "mysql/psi/mysql_sp.h"
#include "mysql_com.h"
#include "mysqld_error.h"
#include "sql/auth/auth_acls.h"
#include "sql/auth/auth_common.h"
#include "sql/auth/sql_security_ctx.h"
#include "sql/binlog.h"
#include "sql/dd/cache/dictionary_client.h"
#include "sql/dd/dd_routine.h"
#include "sql/dd/dd_utility.h"
#include "sql/dd/string_type.h"
#include "sql/dd/types/function.h"
#include "sql/dd/types/procedure.h"
#include "sql/dd/types/routine.h"
#include "sql/dd/types/schema.h"
#include "sql/dd/types/trigger.h"
#include "sql/dd_sp.h"
#include "sql/dd_sql_view.h"
#include "sql/dd_table_share.h"
#include "sql/debug_sync.h"
#include "sql/error_handler.h"
#include "sql/field.h"
#include "sql/handler.h"
#include "sql/lock.h"
#include "sql/log_event.h"
#include "sql/mdl.h"
#include "sql/mysqld.h"
#include "sql/protocol.h"
#include "sql/psi_memory_key.h"
#include "sql/set_var.h"
#include "sql/sp_cache.h"
#include "sql/sp_head.h"
#include "sql/sp_pcontext.h"
#include "sql/sql_class.h"
#include "sql/sql_const.h"
#include "sql/sql_db.h"
#include "sql/sql_digest_stream.h"
#include "sql/sql_error.h"
#include "sql/sql_list.h"
#include "sql/sql_parse.h"
#include "sql/sql_show.h"
#include "sql/sql_table.h"
#include "sql/strfunc.h"
#include "sql/system_variables.h"
#include "sql/table.h"
#include "sql/thd_raii.h"
#include "sql/thr_malloc.h"
#include "sql/transaction.h"
#include "sql/transaction_info.h"
#include "sql_string.h"
#include "template_utils.h"

Classes
class	anonymous_namespace{sp.cc}::Silence_deprecated_warning
	Silence DEPRECATED SYNTAX warnings when loading a stored procedure into the cache. More...
class	Bad_db_error_handler

Namespaces
namespace	anonymous_namespace{sp.cc}

Macros
#define	SP_TYPE_STRING(type)    (type == enum_sp_type::FUNCTION ? "FUNCTION" : "PROCEDURE")

Functions
static bool	create_string (THD *thd, String *buf, enum_sp_type type, const char *db, size_t dblen, const char *name, size_t namelen, const char *params, size_t paramslen, const char *returns, size_t returnslen, const char *body, size_t bodylen, st_sp_chistics *chistics, const LEX_CSTRING &definer_user, const LEX_CSTRING &definer_host, sql_mode_t sql_mode, bool if_not_exists)
	Generates the CREATE... string from the table information. More...
bool	load_charset (MEM_ROOT *mem_root, Field *field, const CHARSET_INFO *dflt_cs, const CHARSET_INFO **cs)
bool	load_collation (MEM_ROOT *mem_root, Field *field, const CHARSET_INFO *dflt_cl, const CHARSET_INFO **cl)
static bool	lock_routine_name (THD *thd, enum_sp_type type, const sp_name *name, enum_mdl_type mdl_lock_type)
	Acquire Shared MDL lock on the routine object. More...
static void	recursion_level_error (THD *thd, sp_head *sp)
	Return appropriate error about recursion limit reaching. More...
static enum_sp_return_code	db_find_routine (THD *thd, enum_sp_type type, const sp_name *name, sp_head **sphp)
	Find routine definition in data dictionary table and create corresponding sp_head object for it. More...
static sp_head *	sp_compile (THD *thd, String *defstr, sql_mode_t sql_mode, Stored_program_creation_ctx *creation_ctx)
	The function parses input strings and returns SP structure. More...
enum_sp_return_code	db_load_routine (THD *thd, enum_sp_type type, const char *sp_db, size_t sp_db_len, const char *sp_name, size_t sp_name_len, sp_head **sphp, sql_mode_t sql_mode, const char *params, const char *returns, const char *body, st_sp_chistics *sp_chistics, const char *definer_user, const char *definer_host, longlong created, longlong modified, Stored_program_creation_ctx *creation_ctx)
static bool	check_routine_already_exists (THD *thd, sp_head *sp, bool if_not_exists, bool &already_exists)
	Method to check if routine with same name already exists. More...
static bool	create_routine_precheck (THD *thd, sp_head *sp)
	Precheck for create routine statement. More...
static bool	sp_binlog_create_routine_stmt (THD *thd, sp_head *sp, const LEX_USER *definer, bool if_not_exists, bool already_exists)
	Method to log create routine event to binlog. More...
bool	sp_create_routine (THD *thd, sp_head *sp, const LEX_USER *definer, bool if_not_exists, bool &sp_already_exists)
	Creates a stored routine. More...
enum_sp_return_code	sp_drop_routine (THD *thd, enum_sp_type type, sp_name *name)
	Drops a stored routine. More...
bool	sp_update_routine (THD *thd, enum_sp_type type, sp_name *name, st_sp_chistics *chistics)
	Updates(Alter) a stored routine. More...
bool	lock_db_routines (THD *thd, const dd::Schema &schema)
	Acquires exclusive metadata lock on all stored routines in the given database. More...
bool	sp_drop_db_routines (THD *thd, const dd::Schema &schema)
	Drop all routines in database 'db'. More...
static bool	show_create_routine_from_dd_routine (THD *thd, enum_sp_type type, sp_name *sp, const dd::Routine *routine)
	Prepare show create routine output from the DD routine object. More...
bool	sp_show_create_routine (THD *thd, enum_sp_type type, sp_name *name)
	Implement SHOW CREATE statement for stored routines. More...
sp_head *	sp_find_routine (THD *thd, enum_sp_type type, sp_name *name, sp_cache **cp, bool cache_only)
	Obtain object representing stored procedure/function by its name from stored procedures cache and looking into data dictionary if needed. More...
sp_head *	sp_setup_routine (THD *thd, enum_sp_type type, sp_name *name, sp_cache **cp)
	Setup a cached routine for execution. More...
bool	sp_exist_routines (THD *thd, Table_ref *routines, bool is_proc)
	This is used by sql_acl.cc:mysql_routine_grant() and is used to find the routines in 'routines'. More...
static bool	sp_add_used_routine (Query_tables_list *prelocking_ctx, Query_arena *arena, const uchar *key, size_t key_length, size_t db_length, const char *name, size_t name_length, Table_ref *belong_to_view)
	Auxiliary function that adds new element to the set of stored routines used by statement. More...
bool	sp_add_used_routine (Query_tables_list *prelocking_ctx, Query_arena *arena, Sroutine_hash_entry::entry_type type, const char *db, size_t db_length, const char *name, size_t name_length, bool lowercase_db, Sp_name_normalize_type name_normalize_type, bool own_routine, Table_ref *belong_to_view)
	Add routine or trigger which is used by statement to the set of stored routines used by this statement. More...
void	sp_remove_not_own_routines (Query_tables_list *prelocking_ctx)
	Remove routines which are only indirectly used by statement from the set of routines used by this statement. More...
void	sp_update_stmt_used_routines (THD *thd, Query_tables_list *prelocking_ctx, malloc_unordered_map< std::string, Sroutine_hash_entry * > *src, Table_ref *belong_to_view)
	Add contents of hash representing set of routines to the set of routines used by statement. More...
void	sp_update_stmt_used_routines (THD *thd, Query_tables_list *prelocking_ctx, SQL_I_List< Sroutine_hash_entry > *src, Table_ref *belong_to_view)
	Add contents of list representing set of routines to the set of routines used by statement. More...
enum_sp_return_code	sp_cache_routine (THD *thd, Sroutine_hash_entry *rt, bool lookup_only, sp_head **sp)
	A helper wrapper around sp_cache_routine() to use from prelocking until 'sp_name' is eradicated as a class. More...
enum_sp_return_code	sp_cache_routine (THD *thd, enum_sp_type type, const sp_name *name, bool lookup_only, sp_head **sp)
	Ensure that routine is present in cache by loading it from the data dictionary if needed. More...
sp_head *	sp_start_parsing (THD *thd, enum_sp_type sp_type, sp_name *sp_name)
	Start parsing of a stored program. More...
void	sp_finish_parsing (THD *thd)
	Finish parsing of a stored program. More...
Item_result	sp_map_result_type (enum enum_field_types type)
Item::Type	sp_map_item_type (enum enum_field_types type)
uint	sp_get_flags_for_command (LEX *lex)
bool	sp_check_name (LEX_STRING *ident)
	Check that the name 'ident' is ok. More...
Item *	sp_prepare_func_item (THD *thd, bool standalone, Item **it_addr)
	Prepare an Item for evaluation (call of fix_fields). More...
bool	sp_eval_expr (THD *thd, bool standalone, Field *result_field, Item **expr_item_ptr)
	Evaluate an expression and store the result in the field. More...
String *	sp_get_item_value (THD *thd, Item *item, String *str)
	Return a string representation of the Item value. More...

Macro Definition Documentation

SP_TYPE_STRING

#define SP_TYPE_STRING

(

type

)

(type == enum_sp_type::FUNCTION ? "FUNCTION" : "PROCEDURE")

Function Documentation

check_routine_already_exists()

static bool check_routine_already_exists ( THD *  thd, sp_head *  sp, bool  if_not_exists, bool &  already_exists  )

static

Method to check if routine with same name already exists.

Parameters

	thd	Thread context.
	sp	Stored routine object to store.
	if_not_exists	True if 'IF NOT EXISTS' clause was specified.
[out]	already_exists	Set to true if routine already exists.

Return values

false	Success.
true	Error.

create_routine_precheck()

static bool create_routine_precheck ( THD *  thd, sp_head *  sp  )

static

Precheck for create routine statement.

Parameters

thd	Thread context.
sp	Stored routine object to store.

Return values

false	Success.
true	Error.

create_string()

static bool create_string ( THD *  thd, String *  buf, enum_sp_type  type, const char *  db, size_t  dblen, const char *  name, size_t  namelen, const char *  params, size_t  paramslen, const char *  returns, size_t  returnslen, const char *  body, size_t  bodylen, st_sp_chistics *  chistics, const LEX_CSTRING &  definer_user, const LEX_CSTRING &  definer_host, sql_mode_t  sql_mode, bool  if_not_exists  )

static

Generates the CREATE... string from the table information.

Returns

Returns true on success, false on (alloc) failure.

db_find_routine()

static enum_sp_return_code db_find_routine ( THD *  thd, enum_sp_type  type, const sp_name *  name, sp_head **  sphp  )

static

Find routine definition in data dictionary table and create corresponding sp_head object for it.

Parameters

thd	Thread context
type	Type of routine (PROCEDURE/...)
name	Name of routine
sphp	Out parameter in which pointer to created sp_head object is returned (0 in case of error).

Note

This function may damage current LEX during execution, so it is good idea to create temporary LEX and make it active before calling it.

Return values

SP_OK	Success
non-SP_OK	Error (one of special codes like SP_DOES_NOT_EXISTS)

db_load_routine()

enum_sp_return_code db_load_routine	(	THD *	thd,
		enum_sp_type	type,
		const char *	sp_db,
		size_t	sp_db_len,
		const char *	sp_name,
		size_t	sp_name_len,
		sp_head **	sphp,
		sql_mode_t	sql_mode,
		const char *	params,
		const char *	returns,
		const char *	body,
		st_sp_chistics *	sp_chistics,
		const char *	definer_user,
		const char *	definer_host,
		longlong	created,
		longlong	modified,
		Stored_program_creation_ctx *	creation_ctx
	)

load_charset()

bool load_charset	(	MEM_ROOT *	mem_root,
		Field *	field,
		const CHARSET_INFO *	dflt_cs,
		const CHARSET_INFO **	cs
	)

load_collation()

bool load_collation	(	MEM_ROOT *	mem_root,
		Field *	field,
		const CHARSET_INFO *	dflt_cl,
		const CHARSET_INFO **	cl
	)

lock_db_routines()

bool lock_db_routines	(	THD *	thd,
		const dd::Schema &	schema
	)

Acquires exclusive metadata lock on all stored routines in the given database.

Parameters

thd	Thread handler
schema	Schema object

Return values

false	Success
true	Failure

lock_routine_name()

static bool lock_routine_name ( THD *  thd, enum_sp_type  type, const sp_name *  name, enum_mdl_type  mdl_lock_type  )

static

Acquire Shared MDL lock on the routine object.

Parameters

thd	Thread context
type	Type of the routine (enum_sp_type::PROCEDURE/...)
name	Name of the routine
mdl_lock_type	Type of MDL lock be acquired on the routine.

Return values

false	Success
true	Error

recursion_level_error()

static void recursion_level_error ( THD *  thd, sp_head *  sp  )

static

Return appropriate error about recursion limit reaching.

Parameters

thd	Thread handle
sp	The stored procedure executed

Remarks

For functions and triggers we return error about prohibited recursion. For stored procedures we return about reaching recursion limit.

show_create_routine_from_dd_routine()

static bool show_create_routine_from_dd_routine ( THD *  thd, enum_sp_type  type, sp_name *  sp, const dd::Routine *  routine  )

static

Prepare show create routine output from the DD routine object.

Parameters

[in]	thd	Thread handle.
[in]	type	Stored routine type.
[in]	sp	Stored routine name.
[in]	routine	Routine object read for the routine.

Return values

false	on success
true	on error

sp_add_used_routine() [1/2]

static bool sp_add_used_routine ( Query_tables_list *  prelocking_ctx, Query_arena *  arena, const uchar *  key, size_t  key_length, size_t  db_length, const char *  name, size_t  name_length, Table_ref *  belong_to_view  )

static

Auxiliary function that adds new element to the set of stored routines used by statement.

The elements of Query_tables_list::sroutines set are accessed on prepared statement re-execution. Because of this we have to allocate memory for both hash element and copy of its key in persistent arena.

Parameters

prelocking_ctx	Prelocking context of the statement
arena	Arena in which memory for new element will be allocated
key	Key for the hash representing set
key_length	Key length.
db_length	Length of db name component in the key.
name	Name of the routine.
name_length	Length of the routine name.
belong_to_view	Uppermost view which uses this routine (0 if routine is not used by view)

Note

Will also add element to end of 'Query_tables_list::sroutines_list' list.

Return values

true	new element was added.
false	element was not added (because it is already present in the set).

sp_add_used_routine() [2/2]

bool sp_add_used_routine	(	Query_tables_list *	prelocking_ctx,
		Query_arena *	arena,
		Sroutine_hash_entry::entry_type	type,
		const char *	db,
		size_t	db_length,
		const char *	name,
		size_t	name_length,
		bool	lowercase_db,
		Sp_name_normalize_type	name_normalize_type,
		bool	own_routine,
		Table_ref *	belong_to_view
	)

Add routine or trigger which is used by statement to the set of stored routines used by this statement.

To be friendly towards prepared statements one should pass persistent arena as second argument.

Parameters

prelocking_ctx	Prelocking context of the statement
arena	Arena in which memory for new element of the set will be allocated
type	Routine type (one of FUNCTION/PROCEDURE/ TRIGGER ...)
db	Database name
db_length	Database name length
name	Routine name
name_length	Routine name length
lowercase_db	Indicates whether db needs to be lowercased when constructing key.
name_normalize_type	Indicates if names needs to be normalized (lowercased / accent needs to be removed).
own_routine	Indicates whether routine is explicitly or implicitly used.
belong_to_view	Uppermost view which uses this routine (nullptr if routine is not used by view)

Note

Will also add element to end of 'Query_tables_list::sroutines_list' list (and will take into account if this is an explicitly used routine).

Return values

True	- new element was added.
False	- element was not added (because it is already present in the set).

sp_binlog_create_routine_stmt()

static bool sp_binlog_create_routine_stmt ( THD *  thd, sp_head *  sp, const LEX_USER *  definer, bool  if_not_exists, bool  already_exists  )

static

Method to log create routine event to binlog.

Parameters

thd	Thread context.
sp	Stored routine object to store.
definer	Definer of the routine.
if_not_exists	True if 'IF NOT EXISTS' clause was specified.
already_exists	True if routine already exists.

Return values

false	success
true	error

sp_cache_routine() [1/2]

enum_sp_return_code sp_cache_routine	(	THD *	thd,
		enum_sp_type	type,
		const sp_name *	name,
		bool	lookup_only,
		sp_head **	sp
	)

Ensure that routine is present in cache by loading it from the data dictionary if needed.

If the routine is present but old, reload it. Emit an appropriate error if there was a problem during loading.

Parameters

[in]	thd	Thread context.
[in]	type	Type of object (FUNCTION or PROCEDURE).
[in]	name	Name of routine.
[in]	lookup_only	Only check that the routine is in the cache. If it's not, don't try to load. If it is present, but old, don't try to reload.
[out]	sp	Pointer to sp_head object for routine, NULL if routine was not found.

Return values

SP_OK	Either routine is found and was successfully loaded into cache or it does not exist.
non-SP_OK	Error while loading routine from DD table.

sp_cache_routine() [2/2]

enum_sp_return_code sp_cache_routine	(	THD *	thd,
		Sroutine_hash_entry *	rt,
		bool	lookup_only,
		sp_head **	sp
	)

A helper wrapper around sp_cache_routine() to use from prelocking until 'sp_name' is eradicated as a class.

sp_check_name()

bool sp_check_name

(

LEX_STRING *

ident

)

Check that the name 'ident' is ok.

It's assumed to be an 'ident' from the parser, so we only have to check length and trailing spaces. The former is a standard requirement (and 'show status' assumes a non-empty name), the latter is a mysql:ism as trailing spaces are removed by get_field().

Return values

true	bad name
false	name is ok

sp_compile()

static sp_head * sp_compile ( THD *  thd, String *  defstr, sql_mode_t  sql_mode, Stored_program_creation_ctx *  creation_ctx  )

static

The function parses input strings and returns SP structure.

Parameters

[in]	thd	Thread handler
[in]	defstr	CREATE... string
[in]	sql_mode	SQL mode
[in]	creation_ctx	Creation context of stored routines

Return values

Pointer	on sp_head struct Success
NULL	error

sp_create_routine()

bool sp_create_routine	(	THD *	thd,
		sp_head *	sp,
		const LEX_USER *	definer,
		bool	if_not_exists,
		bool &	sp_already_exists
	)

Creates a stored routine.

Atomicity: The operation to create a stored routine is atomic/crash-safe. Changes to the Data-dictionary and writing event to binlog are part of the same transaction. All the changes are done as part of the same transaction or do not have any side effects on the operation failure. Data-dictionary, stored routines and table definition caches are in sync with operation state. Cache do not contain any stale/incorrect data in case of failure. In case of crash, there won't be any discrepancy between the data-dictionary table and the binary log.

Parameters

	thd	Thread context.
	sp	Stored routine object to store.
	definer	Definer of the SP.
	if_not_exists	True if 'IF NOT EXISTS' clause was specified.
[out]	sp_already_exists	Set to true if routine already exists.

Return values

false	Success.
true	Error.

sp_drop_db_routines()

bool sp_drop_db_routines	(	THD *	thd,
		const dd::Schema &	schema
	)

Drop all routines in database 'db'.

Parameters

thd	Thread context.
schema	Schema object.

Return values

false	Success
true	Error

sp_drop_routine()

enum_sp_return_code sp_drop_routine	(	THD *	thd,
		enum_sp_type	type,
		sp_name *	name
	)

Drops a stored routine.

Atomicity: The operation to drop a stored routine is atomic/crash-safe. Changes to the Data-dictionary and writing event to binlog are part of the same transaction. All the changes are done as part of the same transaction or do not have any side effects on the operation failure. Data-dictionary, stored routines and table definition caches are in sync with operation state. Cache do not contain any stale/incorrect data in case of failure. In case of crash, there won't be any discrepancy between the data-dictionary table and the binary log.

Parameters

thd	Thread context.
type	Stored routine type (PROCEDURE or FUNCTION)
name	Stored routine name.

Returns

Error code. SP_OK is returned on success. Other SP_ constants are used to indicate about errors.

sp_eval_expr()

bool sp_eval_expr	(	THD *	thd,
		bool	standalone,
		Field *	result_field,
		Item **	expr_item_ptr
	)

Evaluate an expression and store the result in the field.

Parameters

thd	current thread object
standalone	if true, thd->lex contains preparation and execution state of item, otherwise item is part of a query expression that is already in executing state.
result_field	the field to store the result
expr_item_ptr	the root item of the expression

Returns

false on success, true on error

sp_exist_routines()

bool sp_exist_routines	(	THD *	thd,
		Table_ref *	routines,
		bool	is_proc
	)

This is used by sql_acl.cc:mysql_routine_grant() and is used to find the routines in 'routines'.

Parameters

thd	Thread handler
routines	List of needles in the hay stack
is_proc	Indicates whether routines in the list are procedures or functions.

Return values

false	Found.
true	Not found

sp_find_routine()

sp_head * sp_find_routine	(	THD *	thd,
		enum_sp_type	type,
		sp_name *	name,
		sp_cache **	cp,
		bool	cache_only
	)

Obtain object representing stored procedure/function by its name from stored procedures cache and looking into data dictionary if needed.

Parameters

thd	thread context
type	type of object (FUNCTION or PROCEDURE)
name	name of procedure
cp	hash to look routine in
cache_only	if true perform cache-only lookup (Don't look in data dictionary)

Return values

NonNULL	pointer to sp_head object for the procedure
NULL	in case of error.

sp_finish_parsing()

void sp_finish_parsing

(

THD *

thd

)

Finish parsing of a stored program.

This is a counterpart of sp_start_parsing().

Parameters

thd	Thread context.

sp_get_flags_for_command()

uint sp_get_flags_for_command

(

LEX *

lex

)

Parameters

lex	LEX-object, representing an SQL-statement inside SP.

Returns

a combination of:

• sp_head::MULTI_RESULTS: added if the 'cmd' is a command that might result in multiple result sets being sent back.
• sp_head::CONTAINS_DYNAMIC_SQL: added if 'cmd' is one of PREPARE, EXECUTE, DEALLOCATE.

sp_get_item_value()

String * sp_get_item_value	(	THD *	thd,
		Item *	item,
		String *	str
	)

Return a string representation of the Item value.

Parameters

thd	Thread context.
item	The item to evaluate
str	String buffer for representation of the value.

Note

If the item has a string result type, the string is escaped according to its character set.

Return values

NULL	on error
non-NULL	a pointer to valid a valid string on success

sp_map_item_type()

Item::Type sp_map_item_type

(

enum enum_field_types

type

)

Returns

Item::Type code corresponding to the RETURN-field type code.

sp_map_result_type()

Item_result sp_map_result_type

(

enum enum_field_types

type

)

Returns

Item_result code corresponding to the RETURN-field type code.

sp_prepare_func_item()

Item * sp_prepare_func_item	(	THD *	thd,
		bool	standalone,
		Item **	it_addr
	)

Prepare an Item for evaluation (call of fix_fields).

Parameters

thd	thread handler
standalone	if true, thd->lex is directly associated with item. Preparation and execution state will be changed and preparation data will be saved for later executions. If false, item is part of a larger query expression and no such state transitions should take place. It also means that such items cannot save preparation data.
it_addr	pointer to item reference

Returns

pointer to prepared Item on success, NULL on error.

sp_remove_not_own_routines()

void sp_remove_not_own_routines

(

Query_tables_list *

prelocking_ctx

)

Remove routines which are only indirectly used by statement from the set of routines used by this statement.

Parameters

prelocking_ctx

Prelocking context of the statement

sp_setup_routine()

sp_head * sp_setup_routine	(	THD *	thd,
		enum_sp_type	type,
		sp_name *	name,
		sp_cache **	cp
	)

Setup a cached routine for execution.

Parameters

thd	thread context
type	type of object (FUNCTION or PROCEDURE)
name	name of procedure
cp	hash to look routine in

Return values

NonNULL	pointer to sp_head object for the procedure
NULL	in case of error.

sp_show_create_routine()

bool sp_show_create_routine	(	THD *	thd,
		enum_sp_type	type,
		sp_name *	name
	)

Implement SHOW CREATE statement for stored routines.

The operation finds the stored routine object specified by name and then calls show_create_routine_from_dd_routine().

Parameters

thd	Thread context.
type	Stored routine type (PROCEDURE or FUNCTION)
name	Stored routine name.

Return values

false	on success
true	on error

sp_start_parsing()

sp_head * sp_start_parsing	(	THD *	thd,
		enum_sp_type	sp_type,
		sp_name *	sp_name
	)

Start parsing of a stored program.

This function encapsulates all the steps necessary to initialize sp_head to start parsing SP.

Every successful call of sp_start_parsing() must finish with sp_finish_parsing().

Parameters

thd	Thread context.
sp_type	The stored program type
sp_name	The stored program name

Returns

properly initialized sp_head-instance in case of success, or NULL is case of out-of-memory error.

sp_update_routine()

bool sp_update_routine	(	THD *	thd,
		enum_sp_type	type,
		sp_name *	name,
		st_sp_chistics *	chistics
	)

Updates(Alter) a stored routine.

Atomicity: The operation to Update(Alter) a stored routine is atomic/crash-safe. Changes to the Data-dictionary and writing event to binlog are part of the same transaction. All the changes are done as part of the same transaction or do not have any side effects on the operation failure. Data-dictionary and stored routines caches caches are in sync with operation state. Cache do not contain any stale/incorrect data in case of failure. In case of crash, there won't be any discrepancy between the data-dictionary table and the binary log.

Parameters

thd	Thread context.
type	Stored routine type (PROCEDURE or FUNCTION)
name	Stored routine name.
chistics	New values of stored routine attributes to write.

Return values

false	Success.
true	Error.

sp_update_stmt_used_routines() [1/2]

void sp_update_stmt_used_routines	(	THD *	thd,
		Query_tables_list *	prelocking_ctx,
		malloc_unordered_map< std::string, Sroutine_hash_entry * > *	src,
		Table_ref *	belong_to_view
	)

Add contents of hash representing set of routines to the set of routines used by statement.

Parameters

thd	Thread context
prelocking_ctx	Prelocking context of the statement
src	Hash representing set from which routines will be added
belong_to_view	Uppermost view which uses these routines, 0 if none

Note

It will also add elements to end of 'Query_tables_list::sroutines_list' list.

sp_update_stmt_used_routines() [2/2]

void sp_update_stmt_used_routines	(	THD *	thd,
		Query_tables_list *	prelocking_ctx,
		SQL_I_List< Sroutine_hash_entry > *	src,
		Table_ref *	belong_to_view
	)

Add contents of list representing set of routines to the set of routines used by statement.

Parameters

thd	Thread context
prelocking_ctx	Prelocking context of the statement
src	List representing set from which routines will be added
belong_to_view	Uppermost view which uses these routines, 0 if none

Note

It will also add elements to end of 'Query_tables_list::sroutines_list' list.