REPLACE..SELECT /!*99997*/ queries don't replicate

Bug #1023911 reported by Daniel Nichter on 2012-07-12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Seppo Jaakola
Percona Toolkit moved to
Fix Released
Daniel Nichter

Bug Description

The /*!99997*/ featured from prevents REPLACE..SELECT queries from replicating. Without the special comment, REPLACE..SELECT queries replicate normally, and INSERT..SELECT queries replicate normally with and without the special comment.

To reproduce:

1) Setup some nodes.
2) Create a simple test table.
3) REPLACE INTO table SELECT constant1, constant2; -- this replicates
4) INSERT INTO table SELECT constant3, constant4; -- this replicates too
5) REPLACE INTO table SELECT /!*99997*/ constant5, constant6; -- this does not replicate; it only appears on the node on which it was ran

Changed in percona-toolkit:
status: New → Confirmed
importance: Undecided → High
assignee: nobody → Daniel Nichter (daniel-nichter)
tags: added: percona-xtradb-cluster pt-table-checksum
Changed in codership-mysql:
assignee: nobody → Seppo Jaakola (seppo-jaakola)
status: New → In Progress
Seppo Jaakola (seppo-jaakola) wrote :

as a matter of fact no other SQL statement but INSERT...SELECT will replicate if /*!99997 */ comment is present

Changed in codership-mysql:
status: In Progress → Confirmed
importance: Undecided → Low
Seppo Jaakola (seppo-jaakola) wrote :
Changed in codership-mysql:
status: Confirmed → In Progress
milestone: none → 5.5.25-23.7
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Confirmed → Fix Released
Changed in codership-mysql:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers