Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Hashes the given string or binary data using the so-called secure hash algorithm, version 1. SHA1 has been deprecated as a means of securely signing data. It is present in SingleStore DB 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].
SHA1(plaintext)
SHA(plaintext)
40 lower case hexadecimal digits corresponding to the 160-bit binary hash value.
SELECT SHA1('ohai');
+------------------------------------------+
| SHA1('ohai') |
+------------------------------------------+
| dca51952447d80bd35bf631bc21f06648798b7e0 |
+------------------------------------------+