Bug with row() and subselect (4.1)

how-to-repeat:

mysql> create table a (a int, b int);
Query OK, 0 rows affected (0.00 sec)

mysql> create table b like a;
Query OK, 0 rows affected (0.02 sec)

mysql> insert into a values (1,2),(1,3),(1,4),(1,5);
Query OK, 4 rows affected (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> insert into b values (1,2),(1,3);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from a where row(a,b) in (select a,b from b);
+------+------+
| a | b |
+------+------+
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 1 | 5 |
+------+------+
4 rows in set (0.00 sec)

Should be only return the tuples from table b.

Regards

Georg

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

Re: Bug with row() and subselect (4.1)

Hi!

On Wed, Jan 08, 2003 at 10:40:25PM +0100, Georg Richter wrote:
> how-to-repeat:
>
> mysql> create table a (a int, b int);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> create table b like a;
> Query OK, 0 rows affected (0.02 sec)
>
> mysql> insert into a values (1,2),(1,3),(1,4),(1,5);
> Query OK, 4 rows affected (0.00 sec)
> Records: 4 Duplicates: 0 Warnings: 0
>
> mysql> insert into b values (1,2),(1,3);
> Query OK, 2 rows affected (0.00 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
> mysql> select * from a where row(a,b) in (select a,b from b);
> +------+------+
> | a | b |
> +------+------+
> | 1 | 2 |
> | 1 | 3 |
> | 1 | 4 |
> | 1 | 5 |
> +------+------+
> 4 rows in set (0.00 sec)
>
> Should be only return the tuples from table b.

Thank you for bug report. I test it on my current tree (not pushed yet) and
found that bug is gone, but I added test of it to mysql-test.

[skip]

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