Bug #1638 row IN subquery crash
Submitted: 23 Oct 2003 11:00 Modified: 23 Oct 2003 13:58
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (any)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[23 Oct 2003 11:00] Oleksandr Byelkin 
Description:
as reported by Viktoria Reznichenko following subquery crash server: 
select * from g1 where (1,2,6) in (select * from g2); 

How to repeat:
CREATE TABLE g1 ( 
  id int(11) default NULL 
) TYPE=MyISAM CHARSET=latin1; 
 
INSERT INTO g1 VALUES (1); 
INSERT INTO g1 VALUES (5); 
 
CREATE TABLE g2 ( 
  id int(11) default NULL 
) TYPE=MyISAM CHARSET=latin1; 
 
INSERT INTO g2 VALUES (2); 
INSERT INTO g2 VALUES (6); 
 
 
select * from g1 where (1,2,6) in (select * from g2);
[23 Oct 2003 13:58] Oleksandr Byelkin 
ChangeSet 
  1.1621 03/10/23 23:54:21 bell@sanja.is.com.ua +3 -0 
  added check of cardinality to IN/ALL/ANY  subquery transformer 
  (BUG#1638)