mirror of
https://github.com/MariaDB/server.git
synced 2025-02-06 13:52:19 +01:00
82174dae06
In particular: * @@debug deprecated since 5.5.37 * sr_YU locale deprecated since 10.0.11 * "engine_condition_pushdown" in the @@optimizer_switch deprecated since 10.1.1 * @@date_format, @@datetime_format, @@time_format, @@max_tmp_tables deprecated since 10.1.2 * @@wsrep_causal_reads deprecated since 10.1.3 * "parser" in mroonga table comment deprecated since 10.2.11
35 lines
1.3 KiB
Text
35 lines
1.3 KiB
Text
########### suite/sysschema/t/pr_diagnostics.test #############
|
|
# #
|
|
# Testing of of the sys.diagnostics()) procedure #
|
|
# #
|
|
# Creation: #
|
|
# 2015-07-28 jkrogh Implement this test as part of #
|
|
# WL#7804 REPORT FOR SUPPORT #
|
|
# #
|
|
###############################################################
|
|
|
|
-- source include/not_embedded.inc
|
|
|
|
# Sanity check that the procedure completes two iterations with full debug,
|
|
# raw output, and Information Schema table outputs without generating
|
|
# any warnings.
|
|
|
|
--disable_result_log
|
|
SET @sys.debug_dbug = 'ON',
|
|
@sys.diagnostics.allow_i_s_tables = 'ON',
|
|
@sys.diagnostics.include_raw = 'ON';
|
|
|
|
CALL sys.diagnostics(4, 2, 'full');
|
|
|
|
SET @sys.debug_dbug = 'OFF',
|
|
@sys.diagnostics.allow_i_s_tables = 'OFF',
|
|
@sys.diagnostics.include_raw = 'OFF';
|
|
--enable_result_log
|
|
|
|
# Check input variable validation
|
|
-- error S45000
|
|
CALL sys.diagnostics(0, 0, 'full');
|
|
-- error S45000
|
|
CALL sys.diagnostics(2, 0, 'full');
|
|
-- error S45000
|
|
CALL sys.diagnostics(1, 2, 'full');
|