Hi,

With MySQL 4.0.11, latest pull :

How-to-repeat :

CREATE TABLE `moderationcrazycity` ( `victime` mediumint(8) unsigned NOT NULL default '0', `modo` char(35) NOT NULL default '', `ipmodo` int(10) unsigned NOT NULL default '0', `cat` smallint(4) unsigned NOT NULL default '0', `ban` tinyint(1) unsigned NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `raison` char(255) NOT NULL default '', PRIMARY KEY (`victime`,`cat`,`ban`), KEY `modo` (`modo`,`ban`), KEY `victime` (`victime`,`modo`) ) TYPE=MyISAM

SELECT count(distinct(victime)) FROM moderationcrazycity WHERE modo = 'bardass' ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80943a7 handle_segfault + 487 0x826c618 pthread_sighandler + 176 0x80c0443 copy_fields(TMP_TABLE_PARAM*) + 35 0x80527f1 Item_sum_count_distinct::add() + 49 0x8052767 Item_sum_count_distinct::reset() + 39 0x8053694 Item_sum::no_rows_in_result() + 20 0x80c22fb return_zero_rows(JOIN*, select_result*, st_table_list*, List<Item>&, bool, unsigned, char const*, Item*, Procedure*) + 251 0x80bc34b mysql_select(THD*, st_table_list*, List<Item>&, Item*, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*) + 1883 0x80bbbdf handle_select(THD*, st_lex*, select_result*) + 175 0x80a101d mysql_execute_command() + 733 0x80a5a59 mysql_parse(THD*, char*, unsigned) + 329 0x809feea dispatch_command(enum_server_command, THD*, char*, unsigned) + 1162 0x809fa19 do_command(THD*) + 121 0x809f2e8 handle_one_connection + 888 0x826a03a pthread_start_thread + 218 0x829da4a thread_start + 4

Regards, Jocelyn