SELECT NULL,NULL IN (SUBQUERY) returns 0 instead of NULL

CREATE TABLE s (s INT);

INSERT INTO s VALUES(1);

SELECT (SELECT NULL, NULL) IN (SELECT 1, 2 FROM s) FROM s;

0

CREATE TABLE u(a INT, b INT);

INSERT INTO u VALUES (NULL, NULL);

SELECT (SELECT * FROM u) IN (SELECT 1, 2 FROM s) FROM s;

0