LP:731276 - NULLs returned from SUBTIME() are not properly handled in IN() context

Not repeatable in mysql-5.1. The following query:

SELECT * FROM t1 WHERE f1 NOT IN ('00:08:08', SUBTIME( '0000-00-00 00:00:00' , '00:00:00' ));

returns rows even though SUBTIME() returns NULL, which should make the entire NOT IN predicate NULL .

Test case:

CREATE TABLE t1 (f1 TIME);
INSERT INTO t1 VALUES ('01:01:01');

SELECT * FROM t1 WHERE f1 NOT IN ('00:08:08', SUBTIME( '0000-00-00 00:00:00' , '00:00:00' ));