1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/t/pr_diagnostics.test b/mysql-test/suite/sysschema/t/pr_diagnostics.test
new file mode 100644
index 00000000..40ea9000
--- /dev/null
+++ b/mysql-test/suite/sysschema/t/pr_diagnostics.test
@@ -0,0 +1,35 @@
+########### 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');