Incoherent result subqueries & materialization switch

Create a db from the attached dump file, the following select gives a wrong result

MariaDB [jira]> select fkey from t1 where fkey in (select distinct f4 from t2 where f1=147 and f5='S') order by fkey;
------

------

------

If I switch off materialization adding the following line to the my.cnf file

optimizer_switch='materialization=off'

the result is correct

------

------

------

Thanks