https://bugzilla.novell.com/show_bug.cgi?id=188134 mmarek@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |FIXED ------- Comment #17 from mmarek@novell.com 2007-01-03 07:58 MST ------- (In reply to comment #16)

An interesting test would be to place the database files from the attached tarball to /var/lib/mysql/ of a MySQL that contains your patch instead of the upstream one - this way we would know if my test method is valid.

Running REPAIR TABLE is definitely a valid method to test the current fix. And yes, my previous path would "fix" your table when running mysql_upgrade, because it blindly deletes all trailing zeroes / spaces (which isn't correct). The problem with your table is that it was already broken by the INSERT under 5.0, so I doubt it can be somehow recovered (eg., you won't see the original data even if you switch back to 4.x). The current patch at least fixes rows that were created with 4.x and it doesn't break anything, so I'd like to set this bug back to FIXED, ok? Let's try solve the rest in the upstream bug. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug, or are watching someone who is.