UNION Bug

Hello

I' m using the new MySQL 4.1.0 Alpha version on a Windows 2000 system. I
need the new features like subselects etc. that's why I've chosen the development
version. But there's a bug in it, I think:
If I use UNION with .... IN (....) MySQL crashs.
ex.
SELECT * FROM User WHERE User_ID IN (SELECT User_ID FROM User WHERE Username
= 'test' UNION SELECT User_ID FROM User WHERE Username = 'somethingelse');

If the resultquery is empty, it works. In every other case MySQL crashs.

Greets
Pascal


--
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: UNION Bug

p.schiegg@bluewin.ch writes:
> Hello
>
> I' m using the new MySQL 4.1.0 Alpha version on a Windows 2000 system. I
> need the new features like subselects etc. that's why I've chosen the development
> version. But there's a bug in it, I think:
> If I use UNION with .... IN (....) MySQL crashs.
> ex.
> SELECT * FROM User WHERE User_ID IN (SELECT User_ID FROM User WHERE Username
> = 'test' UNION SELECT User_ID FROM User WHERE Username = 'somethingelse');
>
> If the resultquery is empty, it works. In every other case MySQL crashs.
>
> Greets
> Pascal
>

Hi!

In order to repeat the bug, we need all tables involved.

Upload them (tarred and gzipped) to :

ftp://support.mysql.com:/pub/mysql/secret

and let us know a filename.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
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: UNION Bug

p.schiegg@bluewin.ch writes:
> A simple example:
>
> SELECT * FROM User WHERE User_ID IN (SELECT User_ID FROM User WHERE Username='Webmaster'
> UNION SELECT User_ID FROM User WHERE Username='Azrael')
>
> Everytime when I try to use UNION between '(' and ')' in the IN syntax.
>
> Greets
> Pascal

Hi!

Thank you for your test case.

This was some bug fixed in 4.1.1, as it works just fine with latest
4.1.1 from BitKeeper:


mysql> SELECT * FROM user WHERE user_ID IN (SELECT User_ID FROM user WHERE Username='Webmaster' UNION SELECT user_ID FROM user WHERE Username='Azrael')
-> ;
+---------+-----------+----------+---------------------+---- -----+
| User_ID | Username | Password | Registered_since | Rank_ID |
+---------+-----------+----------+---------------------+---- -----+
| 1 | Webmaster | test | 2000-01-01 09:45:00 | 1 |
| 2 | Azrael | 123 | 2003-07-24 09:00:00 | 1 |
+---------+-----------+----------+---------------------+---- -----+
2 rows in set (0.10 sec)



--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
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