3 messages in com.mysql.lists.bugsUNION Bug
FromSent OnAttachments
p.sc...@bluewin.ch24 Jul 2003 04:50 
Sinisa Milivojevic24 Jul 2003 05:07 
Sinisa Milivojevic24 Jul 2003 09:14 
Subject:UNION Bug
From:p.sc...@bluewin.ch (p.sc@bluewin.ch)
Date:07/24/2003 04:50:09 AM
List:com.mysql.lists.bugs

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