Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
MD5
On this page
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 SingleStore mainly for backwards compatibility and for systems which require a "good enough" hashing function and can tolerate collisions.
Note
MD5 is disabled when FIPS mode is enabled (via the ssl_ 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 |
+----------------------------------+Related Topics
Last modified: May 3, 2023