mysqld crashes on combination JOIN and ALIAS

Hi All,

When I use a query like
(Select a.host_name, b.iq_host_id from servicestatus a join nagios_iq_tra
nslation b on a.host_name = b.host_name
) as tblSS
mysqld crashes with a segfault. It seems that the combination of a JOIN
and an ALIAS is too much.
When I use the JOIN without the ALIAS mysqld complains that it really
wants the ALIAS.
If I remove the JOIN from the query it works like a charm (except that
the result is not what I wanted to have in the first place)

I use mysql 4.1.0-alpha on a RH 8.0 system.
I can easily generate a bugreport but the problem is so easy to
generate as well that I won't put it into this mail (don't want
to scare you away with a stackdump). :)

Thanks,
Martin
--
Tin will not rust or give in but melts directly when heated =B-)

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: mysqld crashes on combination JOIN and ALIAS

Err,
Well, err.. this is the embarrissing moment when you find out that
your first post is (a bit) nonsense. :)
It seems that mysqlcc cannot handle this query and makes the server
crash.
I still think it should be handled a bit better (without crashing e.g.)
but I can continue anyway.
Martin

>
> Hi All,
>
> When I use a query like
> (Select a.host_name, b.iq_host_id from servicestatus a join nagios_iq_tra
> nslation b on a.host_name = b.host_name
> ) as tblSS
> mysqld crashes with a segfault. It seems that the combination of a JOIN
> and an ALIAS is too much.
> When I use the JOIN without the ALIAS mysqld complains that it really
> wants the ALIAS.
> If I remove the JOIN from the query it works like a charm (except that
> the result is not what I wanted to have in the first place)
>
> I use mysql 4.1.0-alpha on a RH 8.0 system.
> I can easily generate a bugreport but the problem is so easy to
> generate as well that I won't put it into this mail (don't want
> to scare you away with a stackdump). :)
>
> Thanks,
> Martin
> --
> Tin will not rust or give in but melts directly when heated =B-)
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=martin@idefix.net
>


--
Tin will not rust or give in but melts directly when heated =B-)

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: mysqld crashes on combination JOIN and ALIAS

Hi!

On Jul 15, martin@idefix.net wrote:
> Err,
> Well, err.. this is the embarrissing moment when you find out that
> your first post is (a bit) nonsense. :)
> It seems that mysqlcc cannot handle this query and makes the server
> crash.
> I still think it should be handled a bit better (without crashing e.g.)
> but I can continue anyway.
> Martin

Nevertheless, we'd prefer to fix this bug - mysqld should not crash :)

Could you provide a resolved backtrace ?
http://www.mysql.com/doc/en/Using_stack_trace.html

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: mysqld crashes on combination JOIN and ALIAS

Hello,

martin@idefix.net wrote:
> Hi All,


> If I remove the JOIN from the query it works like a charm (except that
> the result is not what I wanted to have in the first place)

Please explain what do you mean by the above. If result is wrong this might be
another unrelated bug. Maybe you should fill separate report for this.


> I use mysql 4.1.0-alpha on a RH 8.0 system.
> I can easily generate a bugreport but the problem is so easy to
> generate as well that I won't put it into this mail (don't want
> to scare you away with a stackdump). :)

I tested it with 4.1.1 and failed to reproduce it

mysql> (Select t1.id, t2.?d from t1 join t2 on t1.id = t2.id) as tblSS;
ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near 'as
tblSS' at line 1;


I don't recall such, bug reported nor something similar can be found in our Bugs
database so test case will be appreciated.

As Serg already told you we are eager to fix any crashing bug.

Proper place for sending it is http://bugs.mysql.com

Send minumum dump of CREATEs and INSERTs which can help reproduce bug.

> Thanks,
> Martin

Best regards

--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org