1#
2# Test for show profiles
3# No meaningful check is possible.
4# So it only checks that SET profiling is possible and
5# that SHOW PROFILES, SHOW PROFILE FOR QUERY and SHOW PROFILE CPU FOR QUERY
6# do not cause syntax errors. It also increases code coverage for sql_profile.cc
7
8--source include/have_profiling.inc
9SET profiling = 1;
10SELECT 1;
11--replace_column 2 #
12SHOW PROFILES;
13--disable_result_log
14SHOW PROFILE FOR QUERY 1;
15SHOW PROFILE CPU FOR QUERY 1;
16--enable_result_log
17SET profiling = 0;
18
19