Enhancement

While developing, I found this #29443 (comment), thanks to @lcwangchao for pointing it out.
and seaching the issues list, there is a known issue #28494 here

So small cached table doesn't support index merge

This limitation is imposed by the fact union scan doesn't support index merge...
small cached table implemetation depends on union scan, so it gets the same limitation.