6 messages in com.mysql.lists.bugsRe[4]: Crash with ALTER TABLE (3.23.3...
FromSent OnAttachments
Andrew Sitnikov20 Feb 2001 07:50 
Sasha Pachev20 Feb 2001 09:24 
Andrew Sitnikov20 Feb 2001 09:39 
Sasha Pachev20 Feb 2001 10:12 
Andrew Sitnikov20 Feb 2001 10:38 
Michael Widenius20 Feb 2001 15:42 
Subject:Re[4]: Crash with ALTER TABLE (3.23.33-linux2.2.17)
From:Andrew Sitnikov (sitn@infonet.ee)
Date:02/20/2001 10:38:47 AM
List:com.mysql.lists.bugs

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