dropping a non-existing temporary table will be replicated

Bug #1084702 reported by Seppo Jaakola
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Low
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

If running in TOI mode, the DROP TEMPORARY TABLE... statement will be replicated if the table does not exists

Changed in codership-mysql:
importance: Undecided → Low
assignee: nobody → Seppo Jaakola (seppo-jaakola)
milestone: none → 5.5.28-23.8
Changed in codership-mysql:
status: New → In Progress
milestone: 5.5.29-24.8 → 5.5.29-23.7.3
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Fix pushed in revision: http://bazaar.launchpad.net/~codership/codership-mysql/5.5-23/revision/3851

This fix avoids replication of DROP TEMPORARY TABLE... However, DROP TABLE tmp, where tmp happens to be a temporary table will be replicated. So we can say that this fix is just partial solution.

Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released
Changed in percona-xtradb-cluster:
milestone: none → 5.5.30-23.7.4
status: New → Fix Released
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

The fix is already present in 5.6 tree.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1265

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.