Bug #37444 SHOW PROFILE should be enabled.... no, overridden by community-features disabled

• Submitted: 17 Jun 2008 9:54
• Modified: 19 Jun 2008 12:30
• Reporter: Susanne Ebrecht
• Status: Not a Bug
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 5.1-bzr, 5.0-bzr
• OS: FreeBSD
• CPU Architecture: Any
• Tags: community

[17 Jun 2008 9:54] Susanne Ebrecht

Description:
mysql> SHOW PROFILE;
ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

configure output:
checking if SHOW PROFILE should be enabled.... no, overridden by community-features disabled

How to repeat:
Get a fresh bzr tree for MySQL 5.1

$ BUILD/compile_amd64_debug_max -c
$ ./configure --with-named-thread-libs=-pthread --with-plugins=max-no-ndb --enable-profiling --prefix=/home/myhome/mysql51bzr
$ gmake
$ gmake install

Now get MySQL working by using mysql_install_db and ./libexec/mysqld

./bin/mysql test
mysql> SHOW PROFILE;
ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

Suggested fix:
...

[17 Jun 2008 12:01] Susanne Ebrecht

In MySQL 5.0 bzr tree there is no option for configure --enable-profiling

and when you try it anyway you will get:

mysql> show profile;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'profile' at line 1

[19 Jun 2008 12:30] Susanne Ebrecht

I will close this bug because I made lots of thinking errors here.
Also the bug is different for different version.

Will start with a fresh bug report and a more detailed analysis.