Bug #53373 Comments are not properly removed from the pre-processed query buffer.
Submitted: 3 May 2010 13:10 Modified: 14 Dec 2010 23:23
Reporter: Davi Arnaut (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Magne Mæhre CPU Architecture:Any
Tags: regression

[3 May 2010 13:10] Davi Arnaut
Description:
Using the pre-processed query buffer to construct queries for replication might yield invalid queries if the original query contained embedded comments.

Split from Bug#50755

How to repeat:
source include/master-slave.inc;
CREATE/*!*/EVENT e1 ON SCHEDULE EVERY 10 DAY DO/*!*/SELECT 'abc';
source include/show_binlog_events.inc;
source include/master-slave-end.inc;
[9 Jun 2010 17:57] Davi Arnaut
Regression introduced by Bug#44331
[10 Nov 2010 11:37] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/123394
[10 Nov 2010 13:37] Marc ALFF
Patch approved as is.

Thanks for the fix.
[10 Nov 2010 13:41] Magne Mæhre
Pushed to mysql-next-mr-bugfixing (rev. 3378)
[13 Nov 2010 16:19] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (merge vers: 5.6.99-m5) (pib:21)
[13 Nov 2010 16:38] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:alexander.nozdrin@oracle.com-20101113152540-gxro4g0v29l27f5x) (pib:21)
[14 Dec 2010 23:24] Paul DuBois
Bug is not present in any released 5.6.x version.