MD5
Hashes the given string or binary data using the message digest algorithm, version 5.
MD5
has been strongly deprecated as a means of securely signing data, given the multiple weaknesses discovered in the algorithm.
It is present in SingleStoreDB mainly for backwards compatibility and for systems which require a "good enough" hashing function and can tolerate collisions. For a more secure hash function, see SHA2.
Note
MD5
is disabled when FIPS mode is enabled (via the ssl_fips_mode
engine variable).
A warning is generated when MD5 is used:
SELECT MD5('a'); ERROR 2535 (HY000): SSL fips mode error: FIPS mode ON: MD5 digest is not supported. SHOW WARNINGS; **** +---------+------+------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+------------------------------------------------------------------------+ | Warning | 2535 | SSL FIPS mode error: FIPS mode ON/STRICT: MD5 digest is not supported. | +---------+------+------------------------------------------------------------------------+
Syntax
MD5(plaintext)
Arguments
plaintext: the data to hash.
Return Type
32 lower case hexadecimal digits corresponding to the 128-bit binary hash value.
Examples
SELECT MD5('ohai'); **** +----------------------------------+ | MD5('ohai') | +----------------------------------+ | 5a73678b7b674005056434a48054707d | +----------------------------------+