MariaDB [(none)]> SET optimizer_switch = 'index_condition_pushdown=off';

vi /etc/my.cnf.d/server.cnf
optimizer_switch=index_condition_pushdown=off

To check:
mysql -e 'show global variables like "%optimizer_switch%";' | grep index_condition_pushdown