Crash in subselect in derived table with MySQL-4.1

Hi,

How-to-repeat :

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

Stack trace :

0x80a0711 handle_segfault + 481
0x828b218 pthread_sighandler + 176
0x80c57b6 setup_tables(st_table_list*) + 38
0x80ca377 JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 119
0x8084c0d subselect_single_select_engine::prepare() + 157
0x8084315 Item_subselect::fix_fields(THD*, st_table_list*, Item**) + 37
0x80c56c5 setup_fields(THD*, st_table_list*, List&, bool, List*,
bool) + 117
0x8139f0b mysql_derived(THD*, st_lex*, st_select_lex_unit*, st_table_list*)
+ 651
0x80b117e mysql_execute_command(THD*) + 17950
0x80b1c92 mysql_parse(THD*, char*, unsigned) + 146
0x80abcd7 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80ab966 do_command(THD*) + 118
0x80ab23f handle_one_connection + 895
0x8288c3a pthread_start_thread + 218
0x82bcf5a 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-thread13120@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in subselect in derived table with MySQL-4.1

Hi!

On Tue, Nov 26, 2002 at 11:40:52AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a)));
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bugreport! I fix it (patch is committed).

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

Re: Crash in subselect in derived table with MySQL-4.1

Hi !

Which patch should I use, Sinisa one or yours ? :)

Thanks and regards,
Jocelyn
----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc:
Sent: Tuesday, November 26, 2002 2:22 PM
Subject: Re: Crash in subselect in derived table with MySQL-4.1


> Hi!
>
> On Tue, Nov 26, 2002 at 11:40:52AM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a)));
> > ERROR 2013: Lost connection to MySQL server during query
>
> Thank you for bugreport! I fix it (patch is committed).
>
> --
> 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-thread13121@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-thread13122@lists.mysql.com
To unsubscribe, e-mail

Re: Crash in subselect in derived table with MySQL-4.1

Hi!

On Tue, Nov 26, 2002 at 04:01:52PM -0000, Jocelyn Fournier wrote:
> Hi !
>
> Which patch should I use, Sinisa one or yours ? :)

I think Sinisa's because it is pushed but my is not.

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