Hi,
LIKE/regex selectivity estimates for the same pattern depend on the
database encoding, because FIXED_CHAR_SEL is applied per byte rather
than per character. For example, `LIKE '%é'` is estimated at 0.2 in
LATIN1 but 0.04 in UTF8.
Patch attached.
--
Best regards,
Chengpeng Yan