Structsยง
- KeyProber
- Probes a string primary key column. Only supports
utf8mb4_binagainst CHAR/VARCHAR columns up to 768 characters. Enforcement is deferred to the caller. There may be other collations we can support, but we should do more validation.
Constantsยง
- LIKE_
ESCAPE ๐ - The escape character for
LIKEpatterns built bylike_prefix_pattern. - MAX_
KEY_ LENGTH - The longest key the probe bounds cover, in characters. https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html caps an index key at 3072 bytes, or 768 utf8mb4 characters. Longer keys (possible through prefix indexes or narrower charsets) are not supported.
Functionsยง
- explain_
row_ ๐estimate - like_
prefix_ ๐pattern - LIKE uses % and _ as wildcard characters. By default MySQL uses a backslash as an escape character but that can be disabled via config, so we instead specify a specific escape character. LIKE operator: https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html#operator_like Backslash escapes: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_no_backslash_escapes