Hi,

just for the archive:

It took me a while until I could revisit the ERROR 1037 problem. I installed 4.1.10 to make sure I've got the latest bugfixes. The error would still show up, but then I fiddled with my my.ini until it worked. Please do not expect me to understand why this works, but increasing

sort_buffer_size=512K

from 212K fixes the problem. The description of this variable reads:

# This buffer is allocated when MySQL needs to rebuild the index in # REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE # into an empty table. It is allocated per thread so be careful with # large settings.

It is entirely unclear to me why this affects SELECT statements, but so be it. Even more interesting to the inclined reader should be the fact that this setting is listed under the MyISAM section. The database in question is an InnoDB database, though. Makes me wonder.

regards, Markus