Hash Functions with return type HASHTYPE
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9336 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Background Exasol
currently provides the following hash functions: HASH_MD5, HASH_SHA[1], HASH_SHA256, HASH_SHA512, and HASH_TIGER. The return type of all these functions is CHAR. Using them with the newly introduced HASHTYPE therefore always requires an implicit conversion from CHAR to HASHTYPE.
Feature Description
For each existing hash function, there is now a version that directly returns HASHTYPE values. The new functions use a HASHTYPE prefix: HASHTYPE_MD5, HASHTYPE_SHA[1], HASHTYPE_SHA256, HASHTYPE_SHA512, and HASHTYPE_TIGER. Using the new functions in places where a HASHTYPE value is expected will improve performance.
