Bug #32 ROW() IN (SELECT .... )
Submitted: 15 Jan 2003 0:20 Modified: 28 Jan 2003 10:45
Reporter: Alexander Keremidarski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (any)
Assigned to: CPU Architecture: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