Bug #32 ROW() IN (SELECT .... )

• Submitted: 15 Jan 2003 0:20
• Modified: 28 Jan 2003 10:45
• Reporter: Alexander Keremidarski
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Any (any)

[25 Jan 2003 12:42] MySQL Developer

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)
mysql> select * from a where row(a,b) in (select a,b from b);
+------+------+
| a    | b    |
+------+------+
|    1 |    2 |
|    1 |    3 |
|    1 |    4 |
|    1 |    5 |
+------+------+

Should only return first two rows