Re: Crash in IN subselect with MySQL-4.1

Hi!

On Thu, Nov 28, 2002 at 11:10:38PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT *);
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bugreport. I fixed this bug (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-thread13144@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in IN subselect with MySQL-4.1

Hi,

SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT 1,1);

crash ;)

Stack trace :

0x80a2bd1 handle_segfault + 481
0x828d6d8 pthread_sighandler + 176
0x8086832 Item_in_subselect::single_value_transformer(st_select_lex*, Item*,
Item_bool_func2* (*)(Item*, Item*)) + 1042
0x8086987 Item_in_subselect::select_transformer(st_select_lex*) + 39
0x80858a4 Item_subselect::init(THD*, st_select_lex*, select_subselect*) + 36
0x80860b0 Item_in_subselect::Item_in_subselect[in-charge](THD*, Item*,
st_select_lex*) + 96
0x80ba206 yyparse(void*) + 15878
0x80b3f5e mysql_parse(THD*, char*, unsigned) + 110
0x80ae1d4 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852
0x80ade66 do_command(THD*) + 118
0x80ad74e handle_one_connection + 910
0x828b0fa pthread_start_thread + 218
0x82bf41a thread_start + 4

Regards,
Jocelyn


----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc:
Sent: Thursday, November 28, 2002 6:37 PM
Subject: Re: Crash in IN subselect with MySQL-4.1


> Hi!
>
> On Thu, Nov 28, 2002 at 11:10:38PM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT *);
> > ERROR 2013: Lost connection to MySQL server during query
>
> Thank you for bugreport. I fixed this bug (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-thread13144@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-thread13148@lists.mysql.com
To unsubscribe, e-mail

Crash in IN subselect with MySQL-4.1

Hi,

How-to-repeat :

SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT *);
ERROR 2013: Lost connection to MySQL server during query

Stack trace :

0x80a1dd1 handle_segfault + 481
0x828c758 pthread_sighandler + 176
0x804c48e Item_asterisk_remover::fix_fields(THD*, st_table_list*, Item**) +
126
0x80580f4 Item_func::fix_fields(THD*, st_table_list*, Item**) + 148
0x80c66e2 setup_conds(THD*, st_table_list*, Item**) + 1634
0x80ca7fe JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 302
0x80861fd subselect_single_select_engine::prepare() + 157
0x8085135 Item_subselect::fix_fields(THD*, st_table_list*, Item**) + 37
0x80c66e2 setup_conds(THD*, st_table_list*, Item**) + 1634
0x80ca7fe JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 302
0x80cc9fa 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*) + 442
0x80ca67c handle_select(THD*, st_lex*, select_result*) + 252
0x80ae503 mysql_execute_command(THD*) + 643
0x80b3248 mysql_parse(THD*, char*, unsigned) + 152
0x80ad3d4 dispatch_command(enum_server_command, THD*, char*, unsigned) + 852
0x80ad066 do_command(THD*) + 118
0x80ac94e handle_one_connection + 910
0x828a17a pthread_start_thread + 218
0x82be49a 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-thread13133@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in IN subselect with MySQL-4.1

Hi!

On Fri, Nov 29, 2002 at 11:05:15PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> SELECT * FROM (SELECT 1) WHERE 1 IN (SELECT 1,1);

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