dropping a non-existing temporary table will be replicated

Bug #1084702 reported by Seppo Jaakola on 2012-11-29
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
Fix Released
Fix Released

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
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

The fix is already present in 5.6 tree.

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  Edit
Everyone can see this information.

Other bug subscribers