#include "sql/sql_show_status.h"
#include "lex_string.h"
#include "my_alloc.h"
#include "my_sqlcommand.h"
#include "sql/item_cmpfunc.h"
#include "sql/mem_root_array.h"
#include "sql/parse_tree_items.h"
#include "sql/parse_tree_node_base.h"
#include "sql/parse_tree_nodes.h"
#include "sql/parser_yystype.h"
#include "sql/sql_class.h"
#include "sql/sql_lex.h"
#include "sql/strfunc.h"
#include "sql_string.h"
#include "string_with_len.h"

Functions
static Query_block *	build_query (const POS &pos, THD thd, enum_sql_command command, const LEX_CSTRING &table_name, const String wild, Item *where_cond)
	Build a replacement query for SHOW STATUS. More...

Query_block *	build_show_session_status (const POS &pos, THD thd, const String wild, Item *where_cond)

Query_block *	build_show_global_status (const POS &pos, THD thd, const String wild, Item *where_cond)

Query_block *	build_show_session_variables (const POS &pos, THD thd, const String wild, Item *where_cond)

Query_block *	build_show_global_variables (const POS &pos, THD thd, const String wild, Item *where_cond)

Function Documentation

◆ build_query()

static Query_block * build_query	(	const POS &	pos,
		THD *	thd,
		enum_sql_command	command,
		const LEX_CSTRING &	table_name,
		const String *	wild,
		Item *	where_cond
	)

static

Build a replacement query for SHOW STATUS.

When the parser accepts the following syntax:

SHOW GLOBAL STATUS

the parsed tree built for this query is in fact:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status

Likewise, the query:

SHOW GLOBAL STATUS LIKE "<value>"

is built as:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status WHERE Variable_name LIKE "<value>"

Likewise, the query:

SHOW GLOBAL STATUS where <where_clause>

is built as:

SELECT * FROM (SELECT VARIABLE_NAME as Variable_name, VARIABLE_VALUE as Value FROM performance_schema.global_status) global_status WHERE <where_clause>

◆ build_show_global_status()

Query_block * build_show_global_status	(	const POS &	pos,
		THD *	thd,
		const String *	wild,
		Item *	where_cond
	)

◆ build_show_global_variables()

Query_block * build_show_global_variables	(	const POS &	pos,
		THD *	thd,
		const String *	wild,
		Item *	where_cond
	)

◆ build_show_session_status()

Query_block * build_show_session_status	(	const POS &	pos,
		THD *	thd,
		const String *	wild,
		Item *	where_cond
	)

◆ build_show_session_variables()