Re: Crash in IN imbricated subselect with MySQL-4.1

On Fri, Nov 29, 2002 at 11:44:48PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> SELECT 1 FROM (SELECT 1 as a) WHERE 1 IN (SELECT (SELECT a));
> ERROR 2013: Lost connection to MySQL server during query

Thank you for bug report. 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-thread13154@lists.mysql.com
To unsubscribe, e-mail

Crash in IN imbricated subselect with MySQL-4.1

Hi,

How-to-repeat :

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

Stack trace :

0x80a2c91 handle_segfault + 481
0x828d798 pthread_sighandler + 176
0x8282795 my_strcasecmp_8bit + 21
0x80c6814 find_item_in_list(Item*, List&, find_item_error_report_type)
+ 324
0x804c860 Item_field::fix_fields(THD*, st_table_list*, Item**) + 464
0x80c6989 setup_fields(THD*, st_table_list*, List&, bool, List*,
bool) + 121
0x80cb699 JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 201
0x8086e4d subselect_single_select_engine::prepare() + 157
0x8085b7a Item_subselect::fix_fields(THD*, st_table_list*, Item**) + 106
0x80581d2 Item_func::fix_fields(THD*, st_table_list*, Item**) + 178
0x8085b59 Item_subselect::fix_fields(THD*, st_table_list*, Item**) + 73
0x80c75e7 setup_conds(THD*, st_table_list*, Item**) + 1623
0x80cb6fe JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 302
0x80cd8fa 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
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
0x828b1ba pthread_start_thread + 218
0x82bf4da 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-thread13150@lists.mysql.com
To unsubscribe, e-mail