Description:
When using subquery to restrict the main query result, if using in(.....) returns the
right result, but when using NOT IN (....) if the subquery results more then a couple of
rows, the main query returns no result.

How to repeat:
create table test_table 
(id int not null primary key, text varchar(20) not null default '');

insert into test_table (id, text) values (1, 'text1'), (2, 'text2'), (3, 'text3'), (4,
'text4'), (5, 'text5'), (6, 'text6'), (7, 'text7'), (8, 'text8'), (9, 'text9'), (10,
'text10'), (11, 'text11'), (12, 'text12'); 

/*
the query below shoud return 7 rows, however, it returns nothing
*/

select * from test_table where id not in (select id from test_table where id < 8);

Verified against 4.1.2/Linux.  Thank you.

ChangeSet 
  1.1688 04/02/02 02:23:53 bell@sanja.is.com.ua +4 -0 
  avoid null check on fields where NULL is impossible 
  (BUG#2393)

Thank you for bug report.  
 
This bug is fixed in our internal repository => fix will be present in next 
server release.

I'm still seeing this bug in mysql version = 5.0.45-Debian_1ubuntu3.3-log

Not repeatable on 5.0.51a on mysql-5.0.51a-linux-i686.tar.gz official binary.