Skip to main content

Module probe

Module probe 

Source

Structsยง

KeyProber
Probes a string primary key column. Only supports utf8mb4_bin against 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 LIKE patterns built by like_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