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 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| status: | In Progress → Confirmed |
| importance: | Undecided → Low |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #2 |
| 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 |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
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