summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/show_profile.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/show_profile.test')
-rw-r--r--mysql-test/main/show_profile.test23
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/main/show_profile.test b/mysql-test/main/show_profile.test
new file mode 100644
index 00000000..969fb49a
--- /dev/null
+++ b/mysql-test/main/show_profile.test
@@ -0,0 +1,23 @@
+#
+# Test for show profiles
+# No meaningful check is possible.
+# So it only checks that SET profiling is possible and
+# that SHOW PROFILES, SHOW PROFILE FOR QUERY and SHOW PROFILE CPU FOR QUERY
+# do not cause syntax errors. It also increases code coverage for sql_profile.cc
+
+# Tests will be skipped for the view protocol because the view protocol creates
+# an additional util connection and other statistics data
+-- source include/no_view_protocol.inc
+
+--source include/have_profiling.inc
+--disable_ps2_protocol
+SET profiling = 1;
+SELECT 1;
+--replace_column 2 #
+SHOW PROFILES;
+--disable_result_log
+SHOW PROFILE FOR QUERY 1;
+SHOW PROFILE CPU FOR QUERY 1;
+--enable_result_log
+SET profiling = 0;
+--enable_ps2_protocol