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:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:4.1 and 5.0 OS:
Assigned to: CPU Architecture:Any

[2 Oct 2006 7:38] Oli Sennhauser
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.
[2 Oct 2006 8:24] Valeriy Kravchuk
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.
[5 Oct 2006 12:18] Mirko Friedenhagen
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.
[5 Oct 2006 14:05] Mirko Friedenhagen
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.
[12 Oct 2006 17:56] Sergei Golubchik
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.
[12 Oct 2006 18:01] Sergei Golubchik