Hello Sasha,
SP> Worked fine for me. You table did not have any records, by the way. Please
SP> create a full test case we can run and see the crash, preferably in
mysqltest
SP> format ( see mysql-test/t directory for examples in the source
distribution).
/usr/local/mysql-3.23.32/mysql-test> m alter_crash.test
#
# Test of alter table
#
drop table if exists t1;
CREATE TABLE t1 (
id int(11) unsigned NOT NULL default '0',
category_id tinyint(4) unsigned NOT NULL default '0',
type_id tinyint(4) unsigned NOT NULL default '0',
body text NOT NULL,
user_id int(11) unsigned NOT NULL default '0',
status enum('new','old') NOT NULL default 'new',
PRIMARY KEY (id)
) TYPE=MyISAM;
ALTER TABLE
t1
ORDER BY
t1.id,
t1.status,
t1.type_id,
t1.user_id,
t1.body;
/usr/local/mysql-3.23.32/mysql-test> mysqltest -D test -ppassword <
alter_crash.test
mysqltest: At line 19: query 'ALTER TABLE
t1
ORDER BY
t1.id,
t1.status,
t1.type_id,
t1.user_id,
t1.body' failed: 2013: Lost connection to MySQL server during query