Bug in MySQL-4.1 with dependent subselect

Hi,

How-to-repeat :

mysql> SELECT 1 as a,(SELECT 1 FROM (SELECT 1 FROM (SELECT 1) HAVING a=1));
ERROR 2006: MySQL server has gone away

Stack trace :

0x80a1971 handle_segfault(int) + 481
0x8286668 pthread_sighandler + 176
0x81379b2 mysql_derived(THD*, st_lex*, st_select_lex_unit*, st_table_list*)
+ 50
0x80afa8e mysql_execute_command(THD*) + 16622
0x80b0585 mysql_parse(THD*, char*, unsigned) + 149
0x80aab27 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80aa7b6 do_command(THD*) + 118
0x80aa08f handle_one_connection(void*) + 895
0x8283efa pthread_start_thread + 218
0x82b83aa thread_start + 4

I don't know if this bug is related but just in case :

mysql> SELECT (SELECT 1 FROM (SELECT 1) HAVING a=1) as a;
ERROR 2006: MySQL server has gone away

(MySQL is unable to record the stack trace in this case)

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

Re: Bug in MySQL-4.1 with dependent subselect

Hi, Jocelyn!

On Sat, Nov 09, 2002 at 08:03:24PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> mysql> SELECT 1 as a,(SELECT 1 FROM (SELECT 1 FROM (SELECT 1) HAVING a=1));
> ERROR 2006: MySQL server has gone away

Thank you for your bug report!
I found cause of this bug, but we have some problem with previous patch for
derived table, thus we will send patch later, but ASAP.

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

Re: Bug in MySQL-4.1 with dependent subselect

Hi,

It seems I've just hit another new bug :

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

Stack trace :

0x80a1971 handle_segfault(int) + 481
0x8286668 pthread_sighandler + 176
0x827c755 my_strcasecmp_8bit + 21
0x80c34ba find_field_in_table(THD*, st_table*, char const*, unsigned, bool,
bool) + 74
0x80c384e find_field_in_tables(THD*, Item_field*, st_table_list*, bool) +
670
0x804c3db Item_field::fix_fields(THD*, st_table_list*, Item**) + 219
0x805736c Item_func::fix_fields(THD*, st_table_list*, Item**) + 140
0x80c4767 setup_conds(THD*, st_table_list*, Item**) + 1591
0x80c882f JOIN::prepare(st_table_list*, Item*, st_order*, st_order*, Item*,
st_order*, st_select_lex*, st_select_lex_unit*, bool) + 239
0x80ca8e6 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*) + 438
0x80c86f7 handle_select(THD*, st_lex*, select_result*) + 247
0x80abbe9 mysql_execute_command(THD*) + 585
0x80b0585 mysql_parse(THD*, char*, unsigned) + 149
0x80aab27 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80aa7b6 do_command(THD*) + 118
0x80aa08f handle_one_connection(void*) + 895
0x8283efa pthread_start_thread + 218
0x82b83aa thread_start + 4

Regards,
Jocelyn

----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc: ; "Sinisa Milivojevic"
Sent: Saturday, November 09, 2002 10:32 PM
Subject: Re: Bug in MySQL-4.1 with dependent subselect


> Hi, Jocelyn!
>
> On Sat, Nov 09, 2002 at 08:03:24PM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > mysql> SELECT 1 as a,(SELECT 1 FROM (SELECT 1 FROM (SELECT 1) HAVING
a=1));
> > ERROR 2006: MySQL server has gone away
>
> Thank you for your bug report!
> I found cause of this bug, but we have some problem with previous patch
for
> derived table, thus we will send patch later, but ASAP.
>
> [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-thread12931@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in MySQL-4.1 with dependent subselect

Hi,

I'm sending you this bug report just in case (it looks similar to the one I
already submitted, but have a different stack trace and is not be affected
by the derived table bug)

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

Stack trace :

0x80a1971 handle_segfault(int) + 481
0x8286968 pthread_sighandler + 176
(nil)
0x80c8c9a JOIN::optimize() + 58
0x8083aff subselect_single_select_engine::exec() + 223
0x8083277 Item_singleval_subselect::val() + 23
0x804ec51 Item::val_result() + 17
0x80510d9 Item_ref::val() + 25
0x8064cd9 Item_bool_func2::compare_real() + 25
0x8064dec Item_func_eq::val_int() + 44
0x80d559f end_send(JOIN*, st_join_table*, bool) + 383
0x80d4676 sub_select(JOIN*, st_join_table*, bool) + 246
0x80cfd95 do_select(JOIN*, List*, st_table*, Procedure*) + 261
0x80ca1ac JOIN::exec() + 2940
0x80ca79f 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*) + 111
0x8137e94 mysql_derived(THD*, st_lex*, st_select_lex_unit*, st_table_list*)
+ 1236
0x80afaa7 mysql_execute_command(THD*) + 16647
0x80b0585 mysql_parse(THD*, char*, unsigned) + 149
0x80aab27 dispatch_command(enum_server_command, THD*, char*, unsigned) + 855
0x80aa7b6 do_command(THD*) + 118
0x80aa08f handle_one_connection(void*) + 895
0x82841fa pthread_start_thread + 218
0x82b86aa thread_start + 4

However

SELECT 1 as a FROM (SELECT 1 FROM forumconthardwarefr7 HAVING a=1);

works

Regards,
Jocelyn

----- Original Message -----
From: "Sanja Byelkin"
To: "Jocelyn Fournier"
Cc: ; "Sinisa Milivojevic"
Sent: Saturday, November 09, 2002 10:32 PM
Subject: Re: Bug in MySQL-4.1 with dependent subselect


> Hi, Jocelyn!
>
> On Sat, Nov 09, 2002 at 08:03:24PM -0000, Jocelyn Fournier wrote:
> > Hi,
> >
> > How-to-repeat :
> >
> > mysql> SELECT 1 as a,(SELECT 1 FROM (SELECT 1 FROM (SELECT 1) HAVING
a=1));
> > ERROR 2006: MySQL server has gone away
>
> Thank you for your bug report!
> I found cause of this bug, but we have some problem with previous patch
for
> derived table, thus we will send patch later, but ASAP.
>
> [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-thread12940@lists.mysql.com
To unsubscribe, e-mail