Hi!

Tobias> Hello! Tobias> I managed to make a testcase to repeat the problem described below, so
now Tobias> I'm sending this to the bugs-mailinglist instead...

Tobias> I've uploaded a small test table to your ftp-site where the problem show
up. Tobias> The file is called "sorting-records-bug.gz".

Tobias> To repeat the bug: Tobias> Unpack "sorting-records-bug.gz" (it contains a test table
"msgTable2.sql") Tobias> Run "msgTable2.sql" in a MySQL 3.23.28 database. Tobias> Shut down MySQL

Tobias> Run "myisamchk -R 1 msgTable2.MYI"

Tobias> You'll get: Tobias> Data records: 1414 Deleted: 0 Tobias> myisamchk: error: 126 when updating key-pointers Tobias> MyISAM-table 'msgTable2.MYI' is not fixed because of errors

Tobias> Running "myisamchk -R 2 msgTable2.MYI" works fine on this table...

Tobias> Hope this can be fixed real soon (i.e. in the 3.23.29-release!)

Tobias> Regards, Tobias> Tobias Lind

Thanks for the test case; I am just doing the last testing for the binary build of 3.23.29, so I can't get a fix for this into this anymore :(

You can however in 3.23.29 use the following workaround to get the rows sorted:

ALTER TABLE msgTable2 ORDER BY columns-on-key-1

Regards, Monty