Re: Bug in IN subselect without FROM clause

Hi!

On Thu, Nov 28, 2002 at 11:29:30PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> CREATE TABLE `t` (
> `id` int(11) default NULL,
> KEY `id` (`id`)
> ) TYPE=MyISAM CHARSET=latin1
>
> INSERT INTO t VALUES (1),(2);
>
> mysql> SELECT * FROM t WHERE id IN (SELECT 1);
> +------+
> | id |
> +------+
> | 1 |
> | 2 |
> +------+
> 2 rows in set (0.00 sec)

Thank you for bugreport! I fixed this bug (patch is committed & pushed (same
as for previous bug))

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

Bug in IN subselect without FROM clause

Hi,

How-to-repeat :

CREATE TABLE `t` (
`id` int(11) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM CHARSET=latin1

INSERT INTO t VALUES (1),(2);

mysql> SELECT * FROM t WHERE id IN (SELECT 1);
+------+
| id |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)

However :

mysql> SELECT * FROM t WHERE id IN (SELECT 1 FROM (SELECT 1));
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

works.

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