mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
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 = 'ON',
|
|
@sys.diagnostics.allow_i_s_tables = 'ON',
|
|
@sys.diagnostics.include_raw = 'ON';
|
|
|
|
CALL sys.diagnostics(4, 2, 'full');
|
|
|
|
SET @sys.debug = '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');
|