Wrong result (missing rows) with materialization=off, semijoin=off

--source include/have_innodb.inc

CREATE TABLE t1 (entityKey INT PRIMARY KEY) ENGINE=InnoDB;

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

CREATE TABLE t2 (entityKey INT, xhtmltext TEXT, FULLTEXT(xhtmltext)) ENGINE=InnoDB;

INSERT INTO t2 VALUES (1,"silver"),(2,"gold"),(3,"gold");

SET optimizer_switch='materialization=off,semijoin=off';

SELECT t1.entityKey FROM t1 

WHERE t1.entityKey IN (

  SELECT t2.entityKey FROM t2 

  WHERE MATCH (t2.xhtmltext) AGAINST ('gold')

) 

ORDER BY t1.entityKey DESC;

# Cleanup

DROP TABLE t1, t2;

+-----------+

| entityKey |

+-----------+

|         3 |

+-----------+

1 row in set (0.07 sec)

+-----------+

| entityKey |

+-----------+

|         3 |

|         2 |

+-----------+

2 rows in set (0.09 sec)