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
v1-0001-Count-characters-not-bytes-in-pattern-selectivity.patch
Description: v1-0001-Count-characters-not-bytes-in-pattern-selectivity.patch
