mixed CHAR and VARCHAR columns in foreign key definition makes parallel applying fail

Bug #1100496 reported by Seppo Jaakola on 2013-01-16
This bug affects 2 people
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 foreign key column and corresponding referenced table column are of types CHAR and VARCHAR (or vice versa), then controlling of parallel applying may not work.
Problem is that CHAR columns will be fixed length with space padding in the end and the whole column will be appended as certification key value. For VARCHAR columns only 'effective' characters are append as key value.

Changed in codership-mysql:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Seppo Jaakola (seppo-jaakola)
Seppo Jaakola (seppo-jaakola) wrote :

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

The fix will run FK test for child table delete (and index update) operations, and use parent table index directly for populating certification keys for wsrep provider. Note, this is excessive FK test, not normally run.

Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
milestone: none → 5.5.29-23.7.1
Alex Yurchenko (ayurchen) wrote :

fix released in 23.7.3

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

Fix already seems to be in 5.6 tree.

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

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

Other bug subscribers