REPLACE..SELECT /!*99997*/ queries don't replicate
Bug #1023911 reported by
Daniel Nichter
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Low
|
Seppo Jaakola | ||
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Daniel Nichter |
Bug Description
The /*!99997*/ featured from http://
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 |
Changed in percona-toolkit: | |
status: | Confirmed → Fix Released |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
as a matter of fact no other SQL statement but INSERT...SELECT will replicate if /*!99997 */ comment is present