MySQL Bugs: #22878: Query tagging does not work anymore in 4.1 and 5.0

Bug #22878	Query tagging does not work anymore in 4.1 and 5.0
Submitted:	2 Oct 2006 7:38	Modified:	11 Oct 2006 17:54
Reporter:	Oli Sennhauser	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	4.1 and 5.0	OS:
Assigned to:		CPU Architecture:	Any

Description:
In MySQL 4.0 it was possible to tag queries so they are recognized in the slow query log, in the general log and in the processlist.
With MySQL 4.1 and 5.0 comments seems to be cutted away which is very ugly.
Customers are relying on this undocumented feature.

How to repeat:
SELECT /* my tag */ * from test;

can (not) be seen in the slow query log, the general log and the processlist

Suggested fix:
Do not cut comments or at least make this configurable. OR: Implement a mechanism to tag queries properly.

Thank you for a problem report. Verified just as described. with 5.0.26-BK on Linux. 

For me it looks more like a feature request, but let the developers decide.

I'd like to have the tags back as well. We use Oracle mostly in our company (WEB.DE) and query tagging has helped hunting down the source applications of slow queries enormously.

With `hibernate.use_sql_comments=1` e.g. comments from automatically created DB-statements from hibernate (www.hibernate.org) will show up in the log.

MySQL server never strips comments. MySQL command-line client does. If you use php or perl or just any connector besides mysql command line client to communicate with the sever from your application - comments will be preserved.

Bug#11230