Crash with SELECT COUNT(DISTINCT()) in MySQL 4.0.11

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&, bool, unsigned, char const*, Item*, Procedure*) + 251
0x80bc34b mysql_select(THD*, st_table_list*, List&, 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


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13726@lists.mysql.com
To unsubscribe, e-mail

Re: Crash with SELECT COUNT(DISTINCT()) in MySQL 4.0.11

Jocelyn Fournier writes:
> 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&, bool, unsigned, char const*, Item*, Procedure*) + 251
> 0x80bc34b mysql_select(THD*, st_table_list*, List&, 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

Hi!

This was fixed yesterday.

Fix was commited to 4.1 tree.


--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13739@lists.mysql.com
To unsubscribe, e-mail

Re: Crash with SELECT COUNT(DISTINCT()) in MySQL 4.0.11

Hi!

On Feb 11, Sinisa Milivojevic wrote:
> Jocelyn Fournier writes:
> > Hi,
> >
> > With MySQL 4.0.11, latest pull :
> >
> > How-to-repeat :
> >
> Hi!
>
> This was fixed yesterday.
>
> Fix was commited to 4.1 tree.

4.0, of course.

And thanks for spotting this bug the next day after it was introduced :)

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13751@lists.mysql.com
To unsubscribe, e-mail

Re: Crash with SELECT COUNT(DISTINCT()) in MySQL 4.0.11

Hi,

You mean 4.0 tree ? :)

Jocelyn
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Tuesday, February 11, 2003 12:29 PM
Subject: Re: Crash with SELECT COUNT(DISTINCT()) in MySQL 4.0.11


> Jocelyn Fournier writes:
> > 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&, bool, unsigned, char const*, Item*, Procedure*) + 251
> > 0x80bc34b mysql_select(THD*, st_table_list*, List&, 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
>
> Hi!
>
> This was fixed yesterday.
>
> Fix was commited to 4.1 tree.
>
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
> Join MySQL Users Conference and Expo:
> http://www.mysql.com/events/uc2003/
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13739@lists.mysql.com
> To unsubscribe, e-mail
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13750@lists.mysql.com
To unsubscribe, e-mail