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



Attachment: v1-0001-Count-characters-not-bytes-in-pattern-selectivity.patch
Description: v1-0001-Count-characters-not-bytes-in-pattern-selectivity.patch

Reply via email to