summaryrefslogtreecommitdiff
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.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/show_profile.test b/mysql-test/main/show_profile.test
new file mode 100644
index 00000000000..c20b29c40bf
--- /dev/null
+++ b/mysql-test/main/show_profile.test
@@ -0,0 +1,18 @@
+#
+# 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
+
+--source include/have_profiling.inc
+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;
+