Crash in MySQL-4.1 with simple select

Hi,

How-to-repeat :

SELECT (1,1);
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a2c91 handle_segfault + 481
0x828dbd8 pthread_sighandler + 176
0x82b845f strlen + 15
0x809e4cd net_store_data(String*, char const*) + 29
0x80c3a30 send_non_convert_fields(THD*, List&, unsigned) + 160
0x80c3d63 send_fields(THD*, List&, unsigned) + 179
0x8098292 select_send::send_fields(List&, unsigned) + 34
0x80cc5a6 JOIN::exec() + 166
0x80cd7bb mysql_select(THD*, st_table_list*, List&, Item*, st_order*,
st_order*, Item*, st_order*, unsigned long, select_result*,
st_select_lex_unit*, st_select_lex*) + 123
0x80cb57c handle_select(THD*, st_lex*, select_result*) + 252
0x80af3b9 mysql_execute_command(THD*) + 633
0x80b40a8 mysql_parse(THD*, char*, unsigned) + 248
0x80ae294 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852
0x80adf26 do_command(THD*) + 118
0x80ad80e handle_one_connection + 910
0x828b5fa pthread_start_thread + 218
0x82bf91a thread_start + 4

Other strange errors :

mysql> (SELECT (1,1));
ERROR 1239: Cardinality error (more/less than 2 columns)

mysql> (SELECT (1,1,1));
ERROR 2013: Lost connection to MySQL server during query (same bug than the
first one)

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-thread13156@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in MySQL-4.1 with simple select

Hi,

In fact I already applied changeset 1.1398 from Sanja, which perhaps
introduce this bug ?
Anyway Sanja seems to have fixed this bug in changeset 1.1399.

Regards,
Jocelyn
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc: ;
Sent: Friday, November 29, 2002 12:43 PM
Subject: Re: Crash in MySQL-4.1 with simple select


> Jocelyn Fournier writes:
> > Hi,
> >
> > How-to-repeat :
> >
> > SELECT (1,1);
> > ERROR 2013: Lost connection to MySQL server during query
> >
>
> For the above one I get a syntax error. Error 1064.
>
> > Stack trace :
> >
> > 0x80a2c91 handle_segfault + 481
> > 0x828dbd8 pthread_sighandler + 176
> > 0x82b845f strlen + 15
> > 0x809e4cd net_store_data(String*, char const*) + 29
> > 0x80c3a30 send_non_convert_fields(THD*, List&, unsigned) + 160
> > 0x80c3d63 send_fields(THD*, List&, unsigned) + 179
> > 0x8098292 select_send::send_fields(List&, unsigned) + 34
> > 0x80cc5a6 JOIN::exec() + 166
> > 0x80cd7bb mysql_select(THD*, st_table_list*, List&, Item*,
st_order*,
> > st_order*, Item*, st_order*, unsigned long, select_result*,
> > st_select_lex_unit*, st_select_lex*) + 123
> > 0x80cb57c handle_select(THD*, st_lex*, select_result*) + 252
> > 0x80af3b9 mysql_execute_command(THD*) + 633
> > 0x80b40a8 mysql_parse(THD*, char*, unsigned) + 248
> > 0x80ae294 dispatch_command(enum_server_command, THD*, char*, unsigned) +
852
> > 0x80adf26 do_command(THD*) + 118
> > 0x80ad80e handle_one_connection + 910
> > 0x828b5fa pthread_start_thread + 218
> > 0x82bf91a thread_start + 4
> >
> > Other strange errors :
> >
> > mysql> (SELECT (1,1));
> > ERROR 1239: Cardinality error (more/less than 2 columns)
> >
>
> Again 1064: Syntax Eror.
>
> > mysql> (SELECT (1,1,1));
> > ERROR 2013: Lost connection to MySQL server during query (same bug than
the
> > first one)
> >
> > 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-thread13156@lists.mysql.com
> > To unsubscribe, e-mail
> >
> >
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
>
>
>


------------------------------------------------------------ ---------
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-thread13160@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in MySQL-4.1 with simple select

Jocelyn Fournier writes:
> Hi,
>
> How-to-repeat :
>
> SELECT (1,1);
> ERROR 2013: Lost connection to MySQL server during query
>

For the above one I get a syntax error. Error 1064.

> Stack trace :
>
> 0x80a2c91 handle_segfault + 481
> 0x828dbd8 pthread_sighandler + 176
> 0x82b845f strlen + 15
> 0x809e4cd net_store_data(String*, char const*) + 29
> 0x80c3a30 send_non_convert_fields(THD*, List&, unsigned) + 160
> 0x80c3d63 send_fields(THD*, List&, unsigned) + 179
> 0x8098292 select_send::send_fields(List&, unsigned) + 34
> 0x80cc5a6 JOIN::exec() + 166
> 0x80cd7bb mysql_select(THD*, st_table_list*, List&, Item*, st_order*,
> st_order*, Item*, st_order*, unsigned long, select_result*,
> st_select_lex_unit*, st_select_lex*) + 123
> 0x80cb57c handle_select(THD*, st_lex*, select_result*) + 252
> 0x80af3b9 mysql_execute_command(THD*) + 633
> 0x80b40a8 mysql_parse(THD*, char*, unsigned) + 248
> 0x80ae294 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852
> 0x80adf26 do_command(THD*) + 118
> 0x80ad80e handle_one_connection + 910
> 0x828b5fa pthread_start_thread + 218
> 0x82bf91a thread_start + 4
>
> Other strange errors :
>
> mysql> (SELECT (1,1));
> ERROR 1239: Cardinality error (more/less than 2 columns)
>

Again 1064: Syntax Eror.

> mysql> (SELECT (1,1,1));
> ERROR 2013: Lost connection to MySQL server during query (same bug than the
> first one)
>
> 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-thread13156@lists.mysql.com
> To unsubscribe, e-mail
>
>

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


------------------------------------------------------------ ---------
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-thread13159@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in MySQL-4.1 with simple select

Hi!

On Sat, Nov 30, 2002 at 09:02:59AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> SELECT (1,1);
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bugreport. I fixed it (patch is committed & pushed)

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
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-thread13161@lists.mysql.com
To unsubscribe, e-mail