Crash with derived table in MySQL-4.1

Hi !

A crash with derived table this time (although it's more and more difficult
to find bug/crash now ;))

How-to-repeat :

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

Stack trace :

0x80a0711 handle_segfault + 481
0x828b218 pthread_sighandler + 176
0x80c4fea find_field_in_table(THD*, st_table*, char const*, unsigned, bool,
bool) + 26
0x80c53ae find_field_in_tables(THD*, Item_ident*, st_table_list*, bool) +
670
0x804c506 Item_field::fix_fields(THD*, st_table_list*, Item**) + 438
0x80c56c5 setup_fields(THD*, st_table_list*, List&, bool, List*,
bool) + 117
0x80ca3c9 JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 201
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-thread13105@lists.mysql.com
To unsubscribe, e-mail

Re: Crash with derived table in MySQL-4.1

Hi, Jocelyn!

On Tue, Nov 26, 2002 at 12:32:30AM -0000, Jocelyn Fournier wrote:
> Hi !
>
> A crash with derived table this time (although it's more and more difficult
> to find bug/crash now ;))
>
> How-to-repeat :
>
> mysql> SELECT 1 FROM (SELECT (SELECT a));
> ERROR 2013: Lost connection to MySQL server during query

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

[skip]

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