4 messages in com.mysql.lists.bugsRE: PATCH: myisamchk -R1 doesn't work...
FromSent OnAttachments
Rick Moore17 Feb 2001 12:21 
Michael Widenius17 Feb 2001 15:35 
Rick Moore17 Feb 2001 18:01 
Michael Widenius17 Feb 2001 23:55 
Subject:RE: PATCH: myisamchk -R1 doesn't work on multi-column keys
From:Michael Widenius (mon@mysql.com)
Date:02/17/2001 11:55:28 PM
List:com.mysql.lists.bugs

Hi!

"Rick" == Rick Moore <ri@geckobot.com> writes:

Rick> Hi Monty! Rick> Wow- I'm very impressed with your response time on this.

Rick> Unfortunately, after deleting:

Rick> #define ISAM_LIBRARY

Rick> from myisamdef.h, recompiling, and reinstalling I still get the same
error. Rick> I also tried upgrading to 3.23.33 and applying the same patch with no
luck. Rick> (Applying the patch with "patch -p1" never seems to work for me.)

I did test the patch at my side before sending it:

Here is a test run of this:

(/my/data/test) myisamchk -R1 test - Sorting records for MyISAM-table 'test.MYI' Data records: 2 Deleted: 0 - recovering (with sort) MyISAM-table 'test.MYI' Data records: 2 - Fixing index 1

I did optimize another small thing while doing the patch, but I can't understand how this could affect this.

We plan to release 3.23.34 shortly with this fix. Hope you can wait until this is released.

Did you know that you can do the same thing a -R1 in MySQL with:

ALTER TABLE test ORDER BY col1,col2 ?

Regards, Monty