Bug #185 constant IN (SELECT field ...) do not return NULL correctly

• Submitted: 24 Mar 2003 5:51
• Modified: 22 Apr 2003 14:02
• Reporter: Oleksandr Byelkin
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Any (any)
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[24 Mar 2003 5:51] Oleksandr Byelkin

Description:
 
created WHRE expression in subquery "constant IN (SELECT field ...)" incorrectly treated as 
constant. 

How to repeat:
create table t1 (a int, unique index indexa (a)); 
insert into t1 values (-1), (-4), (-2), (NULL); 
select -10 IN (select a from t1 FORCE INDEX (indexa)); 
-10 IN (select a from t1 FORCE INDEX (indexa)) 
0 
(should be NULL)