MAKE_SET() on inner table of LEFT JOIN wrongly rejects NULL-complemented rows

CREATE TABLE t1 (a INT, b INT);

INSERT INTO t1 VALUES (1,1),(2,3);

-- Semantics

SELECT MAKE_SET(1, NULL) IS NOT NULL;  -- 1

-- SELECT-list: NULL-extended row satisfies the predicate

SELECT t1.a, t2.b, MAKE_SET(1, t2.b) IS NOT NULL AS p

FROM t1 LEFT JOIN t1 t2 ON t1.a = t2.b;

-- 1 | 1    | 1

-- 2 | NULL | 1

-- WHERE: same predicate wrongly drops the NULL-extended row

SELECT COUNT(*) AS c_where

FROM t1 LEFT JOIN t1 t2 ON t1.a = t2.b

WHERE MAKE_SET(1, t2.b) IS NOT NULL;

-- Actual: 1

-- Expected: 2

-- Equivalent filter outside the join (oracle)

SELECT COUNT(*) AS c_subq FROM (

  SELECT t1.a, MAKE_SET(1, t2.b) IS NOT NULL AS p

  FROM t1 LEFT JOIN t1 t2 ON t1.a = t2.b

) s WHERE p;

-- Actual: 2

-- Expected: 2

DROP TABLE t1;

CREATE TABLE t1 (c1 INT);

INSERT INTO t1 VALUES (1);

SELECT ref_1.c1,

       (MAKE_SET(1, BIN(ref_1.c1), BIN(ref_1.c1)) NOT LIKE '%_6') AS w_1

FROM t1 AS ref_1 RIGHT JOIN t1 AS ref_2 ON FALSE;

-- Returns 1 row: (NULL, 1)

SELECT ref_1.c1,

       (MAKE_SET(1, BIN(ref_1.c1), BIN(ref_1.c1)) NOT LIKE '%_6') AS w_1

FROM t1 AS ref_1 RIGHT JOIN t1 AS ref_2 ON FALSE

WHERE (MAKE_SET(1, BIN(ref_1.c1), BIN(ref_1.c1)) NOT LIKE '%_6');

-- Actual: empty set

-- Expected: 1 row (NULL, 1)

DROP TABLE t1;