Re: Bug in MySQL-4.1 with IN subselect

Hi!

On Sat, Oct 26, 2002 at 11:42:26PM +0200, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> mysql> SELECT 1 IN (SELECT 1 FROM searchconthardwarefr3 HAVING a);
> ERROR 2013: Lost connection to MySQL server during query

[skip]

> mysql> EXPLAIN SELECT 1 IN (SELECT 1 FROM searchconthardwarefr3 HAVING a);
> ERROR 2013: Lost connection to MySQL server during query

[skip]

Thank you for good bugreport. This bugreport help me to found important
problem in IN subselects implementation, it will take some time to fix it.
BTW, it is better do not try any HAVING/ORDER BY with IN subselect, because
it will not work while problem present. Current rewriting IN -> EXISTS is
not complete, but I already have idea how to rewrite IN subselect with
GROUP BY inside it.

Also pls. note that current implementation of IN can be changed, it is not
pushed in bk repository yet (it is committed for review).

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