mariadb ignoring force index
I'm pretty sure the problem is the "partial" index:

CREATE TABLE `smalltable` (
  ...
  KEY `ix_name` (`name`(10))
) 


Try running the query after adding an index on the full length of the column:

ALTER TABLE smalltable
    DROP INDEX ix_name
  , ADD INDEX ix_name_full (name) ;