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 Email Updates:
Status: Closed Impact on me:
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
created WHRE expression in subquery "constant IN (SELECT field ...)" incorrectly treated as 

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)) 
(should be NULL)