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)
• Status: Closed
• 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:[e-mail]-20101113155825-czmva9kg4n31anmu) (version source revid:[e-mail]-20101113155825-czmva9kg4n31anmu) (merge vers: 5.6.99-m5) (pib:21)

[13 Nov 2010 16:38] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20101113160336-atmtmfb3mzm4pz4i) (version source revid:[e-mail]-20101113152540-gxro4g0v29l27f5x) (pib:21)

[14 Dec 2010 23:24] Paul DuBois

Bug is not present in any released 5.6.x version.