Percona XtraDB Cluster - HA scalable solution for MySQL

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

Reported by Seppo Jaakola on 2013-01-16
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
High
Seppo Jaakola
Percona XtraDB Cluster
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
Undecided
Unassigned

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.

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

Other bug subscribers