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